ERD

erDiagram
  drug_code {
    emis_code_id VARCHAR PK
    dmd_product_code_id VARCHAR FK
  }

  clinical_code {
    emis_code_id VARCHAR PK
  }

  drug_code }|--|{ clinical_code : "dmd_product_code_links"