ERD

erDiagram
  mart_attendance_register {
    INT attendance_register_id PK
    VARCHAR organisation PK
  }

  attendance_register {
    INT attendance_register_id PK
    VARCHAR organisation PK
  }

  stg_attendance_register {
    INT attendance_register_id PK
    VARCHAR organisation PK
  }

  stg_attendance_register_edit {
    INT attendance_register_id PK
    VARCHAR organisation PK
  }

  active_pharmacy {
    INT pharmacy_id PK
    VARCHAR organisation PK
  }

  mart_attendance_absences {
    INT leave_register_id PK
    VARCHAR organisation PK
    INT attendance_register_id FK
  }

  stg_attendance_register ||--o{ attendance_register : source
  stg_attendance_register_edit ||--o{ attendance_register : edited_times
  active_pharmacy ||--o{ attendance_register : pharmacy_context
  attendance_register ||--|| mart_attendance_register : builds
  mart_attendance_register ||--o{ mart_attendance_absences : attendance_register_id