Table of Contents
- 1. Entity-Relationship Diagram
- 2. Tables related to the template
- 3. Tables related to department and sub-department
- 4. Tables related to checklist
- 5. Tables related to categories, questions and answers
- 6. Tables related to issues
- 7. Tables related to action plans
- 8. Tables related to comments
- 9. Tables related to the labels by templates
- 10. Tables related to files
- 11. Tables related to the labels per checklist
- 12. Tables related to users
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