# ASIS 일반 ERD

```mermaid
erDiagram
    cm_patient["cm_patient<br/>(공통_환자정보)"] {
        string patient_no PK
        string patient_name
    }
    cm_department["cm_department<br/>(공통_부서정보)"] {
        string dept_code PK
        string dept_name
    }
    cm_staff["cm_staff<br/>(공통_직원정보)"] {
        string staff_no PK
        string staff_name
    }
    gn_appointment["gn_appointment<br/>(일반_예약정보)"] {
        number appointment_id PK
        string appointment_no
        string patient_no
        string dept_code
        string doctor_no
    }
    gn_checkin["gn_checkin<br/>(일반_체크인정보)"] {
        number checkin_id PK
        string appointment_no
        string patient_no
    }
    gn_waiting_queue["gn_waiting_queue<br/>(일반_대기열)"] {
        number queue_id PK
        string patient_no
        string dept_code
        number queue_no
    }
    gn_patient_notice["gn_patient_notice<br/>(일반_환자안내알림)"] {
        number notice_id PK
        string patient_no
        string notice_type_cd
    }

    cm_patient ||--o{ gn_appointment : logical
    cm_department ||--o{ gn_appointment : logical
    cm_staff ||--o{ gn_appointment : logical
    gn_appointment ||--o{ gn_checkin : logical
    cm_patient ||--o{ gn_waiting_queue : logical
    cm_department ||--o{ gn_waiting_queue : logical
    cm_patient ||--o{ gn_patient_notice : logical
```