ERD

erDiagram
  mkb_mapping_ethnicity {
    snomed_concept_id BIGINT PK
    snomed_description_id BIGINT FK
    emis_code_id BIGINT FK
  }

  snomed_description {
    snomed_description_id BIGINT PK
  }

  clinical_code {
    emis_code_id BIGINT PK
  }

  mkb_mapping_ethnicity }|--|{ snomed_description : "has_description"
  mkb_mapping_ethnicity }|--|{ clinical_code : "maps_to_code"