{"id":4514,"date":"2023-09-06T16:38:52","date_gmt":"2023-09-06T16:38:52","guid":{"rendered":"https:\/\/help.iristrace.com\/docs\/datenmodell\/"},"modified":"2023-11-14T16:47:15","modified_gmt":"2023-11-14T16:47:15","password":"","slug":"datenmodell","status":"publish","type":"docs","link":"https:\/\/help.iristrace.com\/de\/docs\/datenmodell\/","title":{"rendered":"Datenmodell"},"content":{"rendered":"\n<p>Das <strong>Entity-Relationship Model (ER)<\/strong> ist ein visuelles Werkzeug, das Ihnen hilft zu verstehen, wie verschiedene Entit\u00e4ten (Objekte oder Konzepte) miteinander verbunden sind und wie Daten in einer Datenbank gespeichert werden.<\/p>\n\n<p>Nachfolgend sehen Sie ein Diagramm der Beziehungen zwischen den Tabellen in der Zwischendatenbank, die Iristrace seinen Kunden zur Verf\u00fcgung stellt.<\/p>\n\n<h2 class=\"wp-block-heading\">1 Entity-Relationship-Diagramm<\/h2>\n\n<p>Dieses Diagramm stellt die Beziehungen zwischen den Tabellen in der Zwischendatenbank von Iristrace V2 dar.<\/p>\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<h2 class=\"wp-block-heading\">2. Die mit der Vorlage verbundenen Tabellen <\/h2>\n\n<p>VS_TEMPLATE<\/p>\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<h2 class=\"wp-block-heading\">3. Die Tabellen f\u00fcr die Abteilungen und Unterabteilungen <\/h2>\n\n<p>VS_UNIT<\/p>\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<h2 class=\"wp-block-heading\">4. Tabellen f\u00fcr die Checkliste<\/h2>\n\n<p>VS_CHECKLIST<\/p>\n\n<p><\/p>\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<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<h2 class=\"wp-block-heading\">5. Tabellen zu den Kategorien, Fragen und Antworten <\/h2>\n\n<p>VS_QUESTION_ANSWER<\/p>\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<h2 class=\"wp-block-heading\">6. Tabellen zu den Vorf\u00e4llen <\/h2>\n\n<p>VS_ISSUE<\/p>\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<h2 class=\"wp-block-heading\">7. Tabellen zu den Aktionspl\u00e4nen <\/h2>\n\n<p>VS_ACTION_PLAN<\/p>\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<h2 class=\"wp-block-heading\">8. Tabellen zu den Kommentaren <\/h2>\n\n<p>VS_COMMENT<\/p>\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<h2 class=\"wp-block-heading\">9. Tabellen zu den Etiketten nach Vorlagen<\/h2>\n\n<p>VS_TEMPLATE_TAG<\/p>\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<h2 class=\"wp-block-heading\">10. Tabellen zu den Dateien<\/h2>\n\n<p>VS_FILES<\/p>\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<h2 class=\"wp-block-heading\">11. Tabellen zu den Etiketten pro Checkliste <\/h2>\n\n<p>VS_CHECKLIST_TAG<\/p>\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<h2 class=\"wp-block-heading\">12. Tabellen zu den Benutzern <\/h2>\n\n<p>VS_USER<\/p>\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>Das Entity-Relationship Model (ER) ist ein visuelles Werkzeug, das Ihnen hilft zu verstehen, wie verschiedene Entit\u00e4ten (Objekte oder Konzepte) miteinander verbunden sind und wie Daten in einer Datenbank gespeichert werden. Nachfolgend sehen Sie ein Diagramm der Beziehungen zwischen den Tabellen in der Zwischendatenbank, die Iristrace seinen Kunden zur Verf\u00fcgung stellt. 1 Entity-Relationship-Diagramm Dieses Diagramm stellt [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[214],"glossaries":[],"doc_tag":[217,215,216],"class_list":["post-4514","docs","type-docs","status-publish","hentry","doc_category-integrationen-bi","doc_tag-bi-de","doc_tag-integrationen","doc_tag-intermediate-datenbank"],"year_month":"2026-04","word_count":154,"total_views":"501","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Isaac Sanchez","author_nicename":"isaac","author_url":"https:\/\/help.iristrace.com\/de\/author\/isaac\/"},"doc_category_info":[{"term_name":"Integrationen &amp; BI","term_url":"https:\/\/help.iristrace.com\/de\/docs-category\/integrationen-bi\/"}],"doc_tag_info":[{"term_name":"BI","term_url":"https:\/\/help.iristrace.com\/de\/docs-tag\/bi-de\/"},{"term_name":"Integrationen","term_url":"https:\/\/help.iristrace.com\/de\/docs-tag\/integrationen\/"},{"term_name":"Intermediate Datenbank","term_url":"https:\/\/help.iristrace.com\/de\/docs-tag\/intermediate-datenbank\/"}],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/help.iristrace.com\/de\/wp-json\/wp\/v2\/docs\/4514","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.iristrace.com\/de\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/help.iristrace.com\/de\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/help.iristrace.com\/de\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/help.iristrace.com\/de\/wp-json\/wp\/v2\/comments?post=4514"}],"version-history":[{"count":6,"href":"https:\/\/help.iristrace.com\/de\/wp-json\/wp\/v2\/docs\/4514\/revisions"}],"predecessor-version":[{"id":4590,"href":"https:\/\/help.iristrace.com\/de\/wp-json\/wp\/v2\/docs\/4514\/revisions\/4590"}],"wp:attachment":[{"href":"https:\/\/help.iristrace.com\/de\/wp-json\/wp\/v2\/media?parent=4514"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/help.iristrace.com\/de\/wp-json\/wp\/v2\/doc_category?post=4514"},{"taxonomy":"glossaries","embeddable":true,"href":"https:\/\/help.iristrace.com\/de\/wp-json\/wp\/v2\/glossaries?post=4514"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/help.iristrace.com\/de\/wp-json\/wp\/v2\/doc_tag?post=4514"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}