ERD

erDiagram
    organisation ||--o{ location : "has locations"
    location ||--o{ location : "has parent location"

    location {
        bigint location_id PK
        varchar organisation PK
        timestamp extract_datetime
        timestamp load_datetime
        boolean is_deleted
        timestamp transform_datetime
        varchar location_guid
        varchar location_name
        bigint parent_location_id
        varchar email_address
        varchar phone_number
        varchar fax_number
        varchar main_contact_name
        date open_date
        date close_date
        varchar location_type_description
        bigint code_id
        varchar house_name_flat_number
        varchar number_and_street
        varchar village
        varchar town
        varchar county
        varchar postcode
        varchar _execution_date
    }

    organisation {
        bigint organisation_id PK
        varchar organisation PK
        varchar name
        varchar ods_code
        varchar organisation_type_description
        timestamp open_datetime
        timestamp close_datetime
        boolean is_open
    }

    appointment_session ||--o{ location : "held at"

    appointment_session {
        bigint session_id PK
        varchar organisation PK
        varchar session_description
        timestamp session_start_datetime
        timestamp session_end_datetime
        bigint location_guid FK
    }