erDiagram
patient ||--o{ patient_registration_history : "has history"
patient_registration_history {
varbinary patient_history_id PK
varchar organisation
timestamp load_datetime
boolean is_deleted
timestamp transform_datetime
varbinary patient_id FK
varbinary nhs_number
boolean is_valid_hc_number
boolean has_died
boolean has_left
varchar patient_status_description
boolean is_registered
varchar patient_type_description
timestamp recorded_datetime
date recorded_date
bigint recorded_year
timestamp model_updated_datetime
}
patient {
varbinary patient_id PK
varbinary nhs_number
}