ERD

erDiagram
  organisation {
    organisation_id BIGINT PK
    organisation VARCHAR PK
    organisation_guid VARCHAR
    main_location_id BIGINT FK
    main_location_guid VARCHAR
  }

  organisation }|--|| location : main_location_id
  location {
    location_id BIGINT PK
    organisation VARCHAR PK, FK
    location_guid VARCHAR
  }

  organisation ||--o{ user_in_role : organisation_id
  user_in_role {
    user_in_role_id BIGINT PK
    organisation VARCHAR PK, FK
    organisation_id BIGINT FK
  }

  organisation ||--o{ organisation_location : organisation_id
  organisation_location {
    organisation_id BIGINT PK, FK
    location_id BIGINT PK, FK
    organisation VARCHAR PK, FK
  }