# ASIS 진료 ERD

```mermaid
erDiagram
    ad_encounter["ad_encounter<br/>(원무_내원정보)"] {
        string encounter_no PK
        string patient_no
    }
    cl_vital_sign["cl_vital_sign<br/>(진료_바이탈사인)"] {
        number vital_sign_id PK
        string encounter_no
        string patient_no
    }
    cl_clinical_note["cl_clinical_note<br/>(진료_진료기록)"] {
        number note_id PK
        string encounter_no
        string patient_no
        string author_no
    }
    cl_diagnosis["cl_diagnosis<br/>(진료_진단정보)"] {
        number diagnosis_id PK
        string encounter_no
        string icd_code
    }
    cl_medication_order["cl_medication_order<br/>(진료_투약오더)"] {
        number medication_order_id PK
        string order_no
        string encounter_no
        string medication_code
    }
    cl_procedure_order["cl_procedure_order<br/>(진료_처치오더)"] {
        number procedure_order_id PK
        string order_no
        string encounter_no
        string procedure_code
    }

    ad_encounter ||--o{ cl_vital_sign : logical
    ad_encounter ||--o{ cl_clinical_note : logical
    ad_encounter ||--o{ cl_diagnosis : logical
    ad_encounter ||--o{ cl_medication_order : logical
    ad_encounter ||--o{ cl_procedure_order : logical
```