ERD

erDiagram
  issue_record {
    bigint issue_record_id PK
    varchar organisation PK
    bigint patient_id FK
    bigint drug_record_id FK
    bigint authorising_user_in_role_id FK
    bigint entered_by_user_in_role_id FK
    bigint cancelled_by_user_in_role_id FK
  }

  drug_record {
    bigint drug_record_id PK
    varchar organisation PK
  }

  patient {
    bigint patient_id PK
    varchar organisation PK
  }

  user_in_role {
    bigint user_in_role_id PK
    varchar organisation FK
  }

  issue_record }o--|| drug_record : "issued against"
  issue_record }o--|| patient : "belongs to"
  issue_record }o--o| user_in_role : "authorising_user_in_role_id"
  issue_record }o--o| user_in_role : "entered_by_user_in_role_id"
  issue_record }o--o| user_in_role : "cancelled_by_user_in_role_id"