ERD

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

  snomed_concept {
    snomed_concept_id BIGINT PK
  }

  snomed_description {
    snomed_description_id BIGINT PK
  }

  codeable_concept }|--|{ snomed_concept : "maps_to_concept"
  codeable_concept }|--|{ snomed_description : "has_description"