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 (담당진료과)