ERD

erDiagram
  current_appointment {
    varbinary slot_id PK
    varchar organisation PK
    varbinary patient_id FK
  }

  patient {
    varbinary patient_id PK
    varchar organisation PK
  }

  current_appointment }o--|| patient : "patient_id + organisation"