The Entity-Relationship Model (ER) is a visual tool that helps you understand how different entities (objects or concepts) are related and how data is stored in a database.
The following is a diagram of the relationships between tables in the intermediate database that Iristrace makes available to its customers.
1. Entity-Relationship Diagram #
This diagram represents the relationships between the tables in the intermediate database of Iristrace V2.
2. Tables related to the template #
VS_TEMPLATE
3. Tables related to department and sub-department #
VS_UNIT
4. Tables related to checklist #
VS_CHECKLIST
5. Tables related to categories, questions and answers #
VS_QUESTION_ANSWER
6. Tables related to issues #
VS_ISSUE
7. Tables related to action plans #
VS_ACTION_PLAN
8. Tables related to comments #
VS_COMMENT
9. Tables related to the labels by templates #
VS_TEMPLATE_TAG
10. Tables related to files #
VS_FILES
11. Tables related to the labels per checklist #
VS_CHECKLIST_TAG
12. Tables related to users #
VS_USER
