ERD

erDiagram
  sharing_agreement {
    agreement_guid VARCHAR PK, FK
    requester_organisation_guid VARCHAR PK
    sharer_organisation_guid VARCHAR PK
    emis_index_schema_id INTEGER PK, FK
    user_id BIGINT PK, FK
    cognito_username VARCHAR
    organisation VARCHAR
  }

  sharing_agreement }|--|| agreement : agreement_guid
  agreement {
    agreement_guid VARCHAR PK
    emis_index_schema_id INTEGER PK
    requester_organisation_guid VARCHAR
    sharer_organisation_guid VARCHAR
  }

  sharing_agreement }|--|| user_agreement : agreement_guid
  user_agreement {
    agreement_guid VARCHAR PK, FK
    user_id BIGINT PK
    cognito_username VARCHAR
  }