| E-R Diagram Log |
[This is preliminary documentation and is subject to change.]
LogEntry (base data)
Tables in this part of the data modelTable name | Summary |
|---|---|
The LogEntry table holds log entries for events logged in TOPICA application | |
The LogActionType table is a lookup table for finding names for action type codes |
Tables relating to LogEntry
Table name | Summary |
|---|---|
Database Table StandardVersionDistributionDatabase Table Employee | The Employee table holds general data about the employee inclduing name, address, username etc. |
The OrgUnit table holds general data about organizational unit including type, code, name, contact information etc. | |
The Patient table holds general data about the patient inclduing name, address, age etc. | |
The StdGroup table holds the standard hierarchy | |
The Standard table is a lookup table for finding the names for accreditation standards | |
The StandardVersion table holds general data about accreditation standard versions. | |
The Indicator table holds general data about accreditation indicators. | |
The Survey table holds general data about accreditation surveys. | |
The SurveyInterationBody table holds data about accreditation surveys iterations. | |
The RecordAudit table holds data about accreditation record audits. | |
The RecordAuditRecord table holds data about? | |
The RecordAuditParticipant table holds links between recordaudits and the employees who takes part in the audit | |
The Tracer table holds data about tracers and their link to a survey | |
The Finding table holds general data about findings name, links to organizal units, standards, indicators etc. | |
The SelfEvaluationRound table holds data about selfevaluation rounds | |
The Datadictionary table holds the root data for dynamic forms. | |
The ResultLookUp table is a lookup table for finding the names for the combinaiton of result code and result type |