hospital
Tables (5)
chart (Untitled5)
- chart_num (Key) — Primary key — NOT NULL
- t_date (Field2) — Foreign key → treatment.t_date
- t_num (Key5) — Foreign key → treatment.t_num — NOT NULL
- doctor_opinion (Field)
doctor (Untitled)
- doctor_id (Key) — int — Primary key — NOT NULL
- d_subject (Field)
- d_name (Field2)
- d_gender (Field3)
- d_phone (Field4)
- d_email (Field5)
- d_position (Field6)
nurse (Untitled2)
- nurse_id (Key) — Primary key — NOT NULL
- n_work (Field)
- n_gender (Field2)
- n_phone (Field3)
- n_email (Field4)
- n_position (Field5)
patient (Untitled3)
- petient_id (Key) — Primary key — NOT NULL
- p_doctor (Field)
- p_nurse (Field2)
- p_name (Field3)
- p_number (Field4)
- p_gender (Field5)
- p_address (Field6)
- p_email (Field7)
- p_job (Field8)
- doctor_id (Key2) — int — Foreign key → doctor.doctor_id — NOT NULL
treatment (Untitled4)
- t_date (Field) — Primary key
- t_num (Key) — Primary key — NOT NULL
- petient_id (Key3) — Foreign key → patient.petient_id — NOT NULL
- nurse_id (Key4) — Foreign key → nurse.nurse_id — NOT NULL
- t_treat (Field2)