ERD

erDiagram
  patient ||--o{ patient_registration_history : "has history"
  organisation ||--o{ patient_registration_history : "records"

  patient_registration_history {
    bigint patient_history_id PK
    varchar organisation PK
    bigint patient_id FK
    varchar patient_guid
    varchar patient_uuid
    varchar person_guid
    bigint patient_status_id
    varchar patient_status_description
    bigint caseload_patient_status_id
    boolean is_registered
    bigint patient_type_id
    varchar patient_type_description
    timestamp recorded_datetime
    date recorded_date
    bigint recorded_year
  }

  patient {
    bigint patient_id PK
    varchar organisation PK
  }

  organisation {
    varchar organisation PK
  }