# ASIS 공통 ERD

```mermaid
erDiagram
    cm_code_group["cm_code_group<br/>(공통_코드그룹)"] {
        number code_group_id PK
        string group_code
        string group_name
    }
    cm_code["cm_code<br/>(공통_코드정보)"] {
        number code_id PK
        string code_group_code
        string code_value
        string code_name
    }
    cm_department["cm_department<br/>(공통_부서정보)"] {
        number dept_id PK
        string dept_code
        string dept_name
    }
    cm_staff["cm_staff<br/>(공통_직원정보)"] {
        number staff_id PK
        string staff_no
        string staff_name
        string dept_code
    }
    cm_patient["cm_patient<br/>(공통_환자정보)"] {
        number patient_id PK
        string patient_no
        string patient_name
    }
    cm_patient_insurance["cm_patient_insurance<br/>(공통_환자보험)"] {
        number patient_insurance_id PK
        string patient_no
        string payer_name
        datetime effective_from
    }
    cm_room["cm_room<br/>(공통_병실정보)"] {
        number room_id PK
        string room_code
        string room_name
        string dept_code
    }

    cm_code_group ||--o{ cm_code : logical
    cm_department ||--o{ cm_staff : logical
    cm_department ||--o{ cm_room : logical
    cm_patient ||--o{ cm_patient_insurance : logical
```