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
}