Patient Demographic Data Model

Overview

These tables represent a Patient in the system.

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