hospital
Tables (5)
Clinic_data (진료정보)
- c_id (날짜+진료순번) — Primary key — NOT NULL
- p_id (매니) — Foreign key → Patient.p_id — NOT NULL
- num (순서)
- clinic_date (진료날) — date
- clinic (진료내용)
Nurse (간호사들)
- n_id (Key) — Primary key — NOT NULL
- n_name (Field)
- work (업무)
- n_gender (Field3)
- n_phon_num (Field4)
- n_e-mail (Field5)
- n_position (Field6)
Patient (환자님)
- p_id (Key) — Primary key — NOT NULL
- p_name (Field)
- room (병실)
- p_gender (Field2)
- Resident_num (주민번호)
- p_phoen_num (Field3)
- p_e-mail (Field4)
- job (Field5)
- addres (Field6)
- d_id (Key2) — Foreign key → docter.d_id — NOT NULL
chart (차트기록)
- c_num (기록) — Primary key — NOT NULL
- Opinion (의사소견)
- n_id (간호사) — Foreign key → Nurse.n_id — NOT NULL
- c_id (날짜+진료순번) — Foreign key → Clinic_data.c_id — NOT NULL
- p_id (환자) — Foreign key → Clinic_data.p_id — NOT NULL
docter (의사쌤)
- d_id (Key) — Primary key — NOT NULL
- d_name (Field)
- d_position (직위)
- d_gender (성별) — char(1)
- d_phon_num (Field4)
- d_e-mail (Field5)
- medical treatment (담당진료과)