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.
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 utilize the Read Replica can connect SQL tooling 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.