Skip to content
Partner Developer Portal

ERD

erDiagram
    appointment_slot {
        timestamp arrived_datetime
        timestamp booked_datetime
        timestamp call_ended_datetime
        timestamp call_started_datetime
        timestamp current_status_datetime
        varchar   current_status_description
        bigint    current_status_id
        varchar   current_status_type_description
        boolean   is_deleted
        timestamp left_datetime
        timestamp model_updated_datetime
        varchar   organisation
        varbinary patient_id                   FK
        timestamp sent_in_datetime
        timestamp slot_end_datetime
        varbinary slot_id                      PK
        timestamp slot_start_datetime
        varchar   slot_type_description
        bigint    slot_type_id
        timestamp transform_datetime
    }

    patient {
        varbinary patient_id PK
    }

    appointment_slot }o--|| patient : "patient_id"