ERD

erDiagram
  clinical_code {
    emis_code_id BIGINT PK
    parent_emis_code_id BIGINT FK
    organisation VARCHAR FK
  }

  codeable_concept {
    emis_code_id BIGINT PK
    organisation VARCHAR FK
  }

  clinical_code ||--o{ codeable_concept : "for other info"