| 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 | - old table. I don't think it's used anymore
|
| 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 |
|
|