병원 ERD
테이블 (5)
chart (Untitled5)
- c_id (Key) — bigint — 기본 키 — NOT NULL
- treatment_id (FK) — varchar(10) — 외래 키 → treatment.treatment_id — NOT NULL
- n_id (FK2) — bigint — 외래 키 → nurse.n_id — NOT NULL
- d_id (FK3) — bigint — 외래 키 → doctor.d_id — NOT NULL
- p_id (FK4) — bigint — 외래 키 → patient.p_id — NOT NULL
- memo (Field) — varchar(100)
doctor (Untitled)
- d_id (Key) — bigint — 기본 키 — NOT NULL
- subject (Field) — varchar(20)
- name (Field2) — varchar(20)
- gender (Field3) — varchar(20)
- phone (Field4) — varchar(20)
- e-mail (Field5) — varchar(20)
- rank (Field6) — varchar(20)
nurse (Untitled3)
- n_id (Key) — bigint — 기본 키 — NOT NULL
- gender (Field) — varchar(20)
- phone (Field2) — varchar(20)
- name (Field3) — varchar(20)
- e-mail (Field4) — varchar(20)
- rank (Field5) — varchar(20)
- work (Field6) — varchar(20)
patient (Untitled2)
- p_id (Key) — bigint — 기본 키 — NOT NULL
- d_id (FK) — bigint — 외래 키 → doctor.d_id — NOT NULL
- n_id (FK2) — bigint — 외래 키 → nurse.n_id — NOT NULL
- name (Field) — varchar(20)
- se_num (Field2) — varchar(20)
- gender (Field3) — varchar(20)
- adress (Field4) — varchar(40)
- phone (Field5) — varchar(20)
- e-mail (Field6) — varchar(20)
- job (Field7) — varchar(20)
treatment (Untitled4)
- treatment_id (PK) — varchar(10) — 기본 키 — NOT NULL
- d_id (FK) — bigint — 외래 키 → doctor.d_id — NOT NULL
- p_id (FK2) — bigint — 외래 키 → patient.p_id — NOT NULL
- content (Field) — varchar(100)
- date (Field2) — date