Patient Demographic Data Model
Marc Dumontier
Owned by Marc Dumontier
Overview
These tables represent a Patient in the system.
Tables
| Name | Description |
|---|---|
| demographic | primary table which represents a patient in the system. demographic_no is the primary identifier |
| DemographicContact | relationship table which represents a demographic's association with personal and professional contacts. Links to different tables based on the type |
| demographicArchive | archived version of every change to a demographic record |
| demographicExt | key-value pairs for demographic. Simple way to add custom attributes. |
| demographicExtArchive | archived version of all key-value pairs |
| demographicPharmacy | relationship table for preferred pharmacy used in Rx module |
| demographic_merged | merged records are maintained here. headRecord is the active record, and the others are inactive records which link back to head. |
| demographicaccessory |
|
| demographiccust | contains a few values from the master record like note, alert and midwife |
| demographiccustArchive | archives of demographiccust entries |
| client_image | for the image in the echart.stores the byte contents |