Database Schema
The database schema for the Read Replica is the same as the schema for ClinSpark itself. This schema evolves somewhat with each ClinSpark release.
Here are schema DDL files for recent ClinSpark versions:
Entity Relationship Diagram
The ClinSpark database schema is challenging to understand. There is no simple visualization we can provide in our documentation here that can provide a high level ERD.
That said, customers who download the DDL files can load them into a SQL tool of their choosing and create a visual ERD. For example, MySQL Workbench can support this (along with other tooling).
If necessary, our engineering team can also provide example BI visualizations and the SQL behind them to help gain an understanding of certain entity relationships. This can be done via request on our service desk.