# ASIS 원무 ERD

```mermaid
erDiagram
    cm_patient["cm_patient<br/>(공통_환자정보)"] {
        string patient_no PK
    }
    cm_room["cm_room<br/>(공통_병실정보)"] {
        string room_code PK
    }
    gn_appointment["gn_appointment<br/>(일반_예약정보)"] {
        string appointment_no PK
    }
    ad_encounter["ad_encounter<br/>(원무_내원정보)"] {
        number encounter_id PK
        string encounter_no
        string patient_no
        string appointment_no
    }
    ad_admission["ad_admission<br/>(원무_입원정보)"] {
        number admission_id PK
        string encounter_no
        string patient_no
        string room_code
    }
    ad_order_charge["ad_order_charge<br/>(원무_오더청구내역)"] {
        number order_charge_id PK
        string encounter_no
        string charge_code
    }
    ad_bill["ad_bill<br/>(원무_청구서)"] {
        number bill_id PK
        string bill_no
        string encounter_no
    }
    ad_payment["ad_payment<br/>(원무_수납정보)"] {
        number payment_id PK
        string bill_no
    }
    ad_insurance_claim["ad_insurance_claim<br/>(원무_보험청구)"] {
        number claim_id PK
        string bill_no
    }

    gn_appointment ||--o{ ad_encounter : logical
    cm_patient ||--o{ ad_encounter : logical
    ad_encounter ||--o{ ad_admission : logical
    cm_room ||--o{ ad_admission : logical
    ad_encounter ||--o{ ad_order_charge : logical
    ad_encounter ||--o| ad_bill : logical
    ad_bill ||--o{ ad_payment : logical
    ad_bill ||--o{ ad_insurance_claim : logical
```