E-R diagram showing a data model subset related to survey:

This diagram is simplified:

• Not all fields in the tables are displayed

• Not all relations to other parts of the data model is shown. Examples:

  • Tables Finding, Assessment and SurveyIndicatorRecordAudit all have references to tables in the data model subset standards (base data for standards and indicators).

  • The table SurveyEmployee has relation to the table Employee in the "core" data model, subset Employee.

Note that even if the diagram hides some details, the documentation on each table contains the full specification of primary and foreign keys - and hence the relations to other tables.