Skip to main content

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​

LayerTechnologyPurposeSchema Source
SureNetwork GlobalPostgreSQL (Liquibase)Relational platform data — tenants, users, persons, organisations, projectsSC/SureNetwork-Global/network-global-service/src/main/resources/db/changelog/
SureDMS / NuxeoNuxeo Content RepositoryDocument management — archives, documents, audit logs, content typesSC/suredms-nuxeo-extensions/suredms-nuxeo-doctypes/src/main/resources/schemas/