# ASIS 진료지원 ERD

```mermaid
erDiagram
    cl_procedure_order["cl_procedure_order<br/>(진료_처치오더)"] {
        string order_no PK
    }
    cl_medication_order["cl_medication_order<br/>(진료_투약오더)"] {
        string order_no PK
    }
    cs_specimen["cs_specimen<br/>(진료지원_검체정보)"] {
        number specimen_id PK
        string specimen_no
        string order_no
    }
    cs_lab_order["cs_lab_order<br/>(진료지원_검사오더)"] {
        number lab_order_id PK
        string lab_order_no
        string procedure_order_no
        string specimen_no
    }
    cs_lab_result["cs_lab_result<br/>(진료지원_검사결과)"] {
        number lab_result_id PK
        string lab_order_no
        string analyte_code
    }
    cs_imaging_order["cs_imaging_order<br/>(진료지원_영상오더)"] {
        number imaging_order_id PK
        string imaging_order_no
        string procedure_order_no
    }
    cs_imaging_result["cs_imaging_result<br/>(진료지원_영상판독결과)"] {
        number imaging_result_id PK
        string imaging_order_no
    }
    cs_dispense["cs_dispense<br/>(진료지원_조제정보)"] {
        number dispense_id PK
        string dispense_no
        string order_no
    }

    cl_procedure_order ||--o{ cs_specimen : logical
    cs_specimen ||--o{ cs_lab_order : logical
    cl_procedure_order ||--o{ cs_lab_order : logical
    cs_lab_order ||--o{ cs_lab_result : logical
    cl_procedure_order ||--o{ cs_imaging_order : logical
    cs_imaging_order ||--o| cs_imaging_result : logical
    cl_medication_order ||--o{ cs_dispense : logical
```