ERD

erDiagram
    organisation_location ||--o{ organisation : "location_id"
    organisation_location ||--o{ location : "organisation_id"


   organisation_location {
    _ingest_time VARCHAR
    is_deleted BOOLEAN
    load_datetime datetime
    organisation_id VARCHAR PK
    organisation_guid VARCHAR
    location_id VARCHAR PK
    location_guid VARCHAR
    is_main_location BOOLEAN
    organisation VARCHAR
    transform_datetime datetime
    _execution_date VARCHAR
    }

    organisation {
        organisation_id VARCHAR PK
        organisation_guid VARCHAR
        organisation VARCHAR
    }

    location {
        location_id VARCHAR
        location_guid VARCHAR
        is_main_location BOOLEAN
    }