{"id":4268,"date":"2023-09-06T16:38:52","date_gmt":"2023-09-06T16:38:52","guid":{"rendered":"https:\/\/help.iristrace.com\/?post_type=docs&#038;p=4268"},"modified":"2023-11-14T16:47:10","modified_gmt":"2023-11-14T16:47:10","password":"","slug":"modelo-de-datos","status":"publish","type":"docs","link":"https:\/\/help.iristrace.com\/es\/docs\/modelo-de-datos\/","title":{"rendered":"Modelo de datos"},"content":{"rendered":"\n<p>El <strong>Modelo Entidad-Relaci\u00f3n (ER)<\/strong> es una herramienta visual que te ayuda a comprender c\u00f3mo diferentes entidades (objetos o conceptos) est\u00e1n relacionadas y c\u00f3mo se almacenan los datos en una base de datos.<\/p>\n\n\n\n<p>A continuaci\u00f3n se describe el diagrama de las relaciones entre tablas de la base de datos intermedia que Iristrace pone a disposici\u00f3n de sus clientes.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">1. Diagrama Entidad-Relaci\u00f3n<\/h2>\n\n\n\n<p>Este diagrama representa las relaciones entre las tablas de la base de datos intermedia de Iristrace V2.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"926\" height=\"559\" src=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image.png\" alt=\"\" class=\"wp-image-4270\" srcset=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image.png 926w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-300x181.png 300w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-768x464.png 768w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-12x7.png 12w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-36x22.png 36w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-48x29.png 48w\" sizes=\"auto, (max-width: 926px) 100vw, 926px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">2. Tablas relacionadas con la plantilla <\/h2>\n\n\n\n<p>VS_TEMPLATE<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"732\" height=\"333\" src=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-1.png\" alt=\"\" class=\"wp-image-4273\" srcset=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-1.png 732w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-1-300x136.png 300w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-1-12x5.png 12w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-1-36x16.png 36w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-1-48x22.png 48w\" sizes=\"auto, (max-width: 732px) 100vw, 732px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">3. Tablas relacionadas con departamento y subdepartamento <\/h2>\n\n\n\n<p>VS_UNIT<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"757\" height=\"501\" src=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-2.png\" alt=\"\" class=\"wp-image-4276\" srcset=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-2.png 757w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-2-300x199.png 300w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-2-12x8.png 12w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-2-36x24.png 36w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-2-48x32.png 48w\" sizes=\"auto, (max-width: 757px) 100vw, 757px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">4. Tablas relacionadas con checklist<\/h2>\n\n\n\n<p>VS_CHECKLIST<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-2-1024x688.png\" alt=\"\" class=\"wp-image-4568\" width=\"774\" height=\"519\" srcset=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-2-1024x688.png 1024w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-2-300x202.png 300w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-2-768x516.png 768w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-2-12x8.png 12w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-2-36x24.png 36w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-2-48x32.png 48w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-2.png 1420w\" sizes=\"auto, (max-width: 774px) 100vw, 774px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-4-1024x437.png\" alt=\"\" class=\"wp-image-4574\" width=\"781\" height=\"333\" srcset=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-4-1024x437.png 1024w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-4-300x128.png 300w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-4-768x328.png 768w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-4-12x5.png 12w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-4-36x15.png 36w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-4-48x20.png 48w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-4.png 1438w\" sizes=\"auto, (max-width: 781px) 100vw, 781px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">5. Tablas relacionadas con categor\u00edas, preguntas y respuestas <\/h2>\n\n\n\n<p>VS_QUESTION_ANSWER<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-5-1024x494.png\" alt=\"\" class=\"wp-image-4577\" width=\"840\" height=\"405\" srcset=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-5-1024x494.png 1024w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-5-300x145.png 300w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-5-768x371.png 768w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-5-1536x742.png 1536w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-5-12x6.png 12w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-5-36x17.png 36w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-5-48x23.png 48w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/11\/image-5.png 1984w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">6. Tablas relacionadas con incidencias <\/h2>\n\n\n\n<p>VS_ISSUE<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-5.png\" alt=\"\" class=\"wp-image-4288\" width=\"839\" height=\"284\" srcset=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-5.png 815w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-5-300x102.png 300w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-5-768x260.png 768w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-5-12x4.png 12w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-5-36x12.png 36w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-5-48x16.png 48w\" sizes=\"auto, (max-width: 839px) 100vw, 839px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">7. Tablas relacionadas con planes de acci\u00f3n <\/h2>\n\n\n\n<p>VS_ACTION_PLAN<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-20.png\" alt=\"\" class=\"wp-image-4372\" width=\"838\" height=\"98\" srcset=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-20.png 857w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-20-300x35.png 300w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-20-768x91.png 768w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-20-12x1.png 12w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-20-36x4.png 36w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-20-48x6.png 48w\" sizes=\"auto, (max-width: 838px) 100vw, 838px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">8. Tablas relacionadas con comentarios <\/h2>\n\n\n\n<p>VS_COMMENT<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-15.png\" alt=\"\" class=\"wp-image-4325\" width=\"839\" height=\"230\" srcset=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-15.png 769w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-15-300x82.png 300w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-15-12x3.png 12w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-15-36x10.png 36w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-15-48x13.png 48w\" sizes=\"auto, (max-width: 839px) 100vw, 839px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">9. Tablas relacionadas con las etiquetas por plantillas<\/h2>\n\n\n\n<p>VS_TEMPLATE_TAG<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"854\" height=\"102\" src=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-21.png\" alt=\"\" class=\"wp-image-4375\" srcset=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-21.png 854w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-21-300x36.png 300w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-21-768x92.png 768w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-21-12x1.png 12w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-21-36x4.png 36w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-21-48x6.png 48w\" sizes=\"auto, (max-width: 854px) 100vw, 854px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">10. Tablas relacionadas con los archivos<\/h2>\n\n\n\n<p>VS_FILES<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"740\" height=\"230\" src=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-9.png\" alt=\"\" class=\"wp-image-4300\" srcset=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-9.png 740w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-9-300x93.png 300w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-9-12x4.png 12w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-9-36x11.png 36w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-9-48x15.png 48w\" sizes=\"auto, (max-width: 740px) 100vw, 740px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">11. Tablas relacionadas con las etiquetas por checklist <\/h2>\n\n\n\n<p>VS_CHECKLIST_TAG<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-16.png\" alt=\"\" class=\"wp-image-4329\" width=\"751\" height=\"103\" srcset=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-16.png 684w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-16-300x41.png 300w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-16-12x2.png 12w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-16-36x5.png 36w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-16-48x7.png 48w\" sizes=\"auto, (max-width: 751px) 100vw, 751px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">12. Tablas relacionadas con los usuarios <\/h2>\n\n\n\n<p>VS_USER<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"746\" height=\"140\" src=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-14.png\" alt=\"\" class=\"wp-image-4321\" srcset=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-14.png 746w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-14-300x56.png 300w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-14-12x2.png 12w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-14-36x7.png 36w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2023\/08\/image-14-48x9.png 48w\" sizes=\"auto, (max-width: 746px) 100vw, 746px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>El Modelo Entidad-Relaci\u00f3n (ER) es una herramienta visual que te ayuda a comprender c\u00f3mo diferentes entidades (objetos o conceptos) est\u00e1n relacionadas y c\u00f3mo se almacenan los datos en una base de datos. A continuaci\u00f3n se describe el diagrama de las relaciones entre tablas de la base de datos intermedia que Iristrace pone a disposici\u00f3n de [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[203],"glossaries":[],"doc_tag":[205,206,204],"class_list":["post-4268","docs","type-docs","status-publish","hentry","doc_category-integraciones-bi","doc_tag-base-de-datos-intermedia","doc_tag-bi","doc_tag-integraciones"],"year_month":"2026-04","word_count":171,"total_views":"674","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Isaac Sanchez","author_nicename":"isaac","author_url":"https:\/\/help.iristrace.com\/es\/author\/isaac\/"},"doc_category_info":[{"term_name":"Integraciones &amp; BI","term_url":"https:\/\/help.iristrace.com\/es\/docs-category\/integraciones-bi\/"}],"doc_tag_info":[{"term_name":"base de datos intermedia","term_url":"https:\/\/help.iristrace.com\/es\/docs-tag\/base-de-datos-intermedia\/"},{"term_name":"BI","term_url":"https:\/\/help.iristrace.com\/es\/docs-tag\/bi\/"},{"term_name":"integraciones","term_url":"https:\/\/help.iristrace.com\/es\/docs-tag\/integraciones\/"}],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/docs\/4268","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/comments?post=4268"}],"version-history":[{"count":26,"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/docs\/4268\/revisions"}],"predecessor-version":[{"id":4589,"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/docs\/4268\/revisions\/4589"}],"wp:attachment":[{"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/media?parent=4268"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/doc_category?post=4268"},{"taxonomy":"glossaries","embeddable":true,"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/glossaries?post=4268"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/doc_tag?post=4268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}