Database Schema Reference
SureClinical uses two distinct persistence layers. Each layer is documented separately:
-
SureNetwork Global Database Schema — the platform-level relational database (PostgreSQL, managed by Liquibase). Covers tenants, users, persons, organisations, projects, hubs, roles, credentials, and clinical metadata. Includes 5 ER diagrams and a full 50-table column reference.
-
SureDMS Nuxeo Document Object Model — the document-oriented Nuxeo content repository. Covers archives, documents, content types, categories, users, roles, discrepancies, and audit records. Includes object model diagram and Java entity reference.
Layer Summary
| Layer | Technology | Purpose | Schema Source |
|---|---|---|---|
| SureNetwork Global | PostgreSQL (Liquibase) | Relational platform data — tenants, users, persons, organisations, projects | SC/SureNetwork-Global/network-global-service/src/main/resources/db/changelog/ |
| SureDMS / Nuxeo | Nuxeo Content Repository | Document management — archives, documents, audit logs, content types | SC/suredms-nuxeo-extensions/suredms-nuxeo-doctypes/src/main/resources/schemas/ |