ERD

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

  attendance_absences {
    INT leave_register_id PK
    VARCHAR organisation PK
  }

  stg_leave_register {
    INT leave_register_id PK
    VARCHAR organisation PK
  }

  mart_attendance_register {
    INT attendance_register_id PK
    VARCHAR organisation PK
  }

  stg_leave_register ||--o{ attendance_absences : source
  attendance_absences ||--|| mart_attendance_absences : builds
  mart_attendance_absences }o--|| mart_attendance_register : attendance_register_id