Click or drag to resize
E-R Diagram Patient

[This is preliminary documentation and is subject to change.]

The database diagram below gives an overview of the tables used for holding patient related data.

Database Model Patient
Database Model Patient
Tables in this part of the data model

Table name

Summary

Patient

The Patient table holds general data about the patient inclduing name, address, age etc.

SexType

The SexType table holds the legal values for SexType

ZipCodeNumeric

The ZipCodeNumeric table is a lookup table for finding the names for numeric zip codes

MaritalStatus

The MaritalStatus table holds the legal values for MaritalStatus (such as married, unmarried, divorced etc.)

OrgUnit

Holds organizational units (used as part of patient address)

PatientCheck

Holds info about updates of patient data from external systems

PatientProject

Not used

PatientChildren

Not used