hospital

Tables (5)

chart (Untitled8)

  • 차트ID (c_id) — integer — Primary key — NOT NULL
  • 의사ID (d_id) — integer — Foreign key → doctor.의사ID — NOT NULL
  • 담당진료과목 (d_department) — varchar(30) — Foreign key → doctor.담당진료과목 — NOT NULL
  • 환자ID (p_id) — integer — Foreign key → patient.환자ID — NOT NULL
  • 간호사ID (n_id) — integer — Foreign key → nurse.간호사ID — NOT NULL
  • 날짜 (s_date) — date — Foreign key → station.날짜 — NOT NULL
  • 의사소견 (c_comment) — varchar(100)
  • 접수순번 (s_id) — integer — Foreign key → station.진료순번 — NOT NULL

doctor (Untitled)

  • 의사ID (d_id) — integer — Primary key — NOT NULL
  • 담당진료과목 (d_department) — varchar(30) — Primary key — NOT NULL
  • 의사이름 (d_name) — varchar(30)
  • 의사성별 (d_gender) — char(1)
  • 의사연락처 (d_tellnum) — varchar(20)
  • 의사이메일 (d_email) — varchar(30)
  • 직급 (d_rank) — varchar(20)

nurse (Untitled7)

  • 간호사ID (n_id) — integer — Primary key — NOT NULL
  • 간호사이름 (n_name) — varchar(30)
  • 담당업무 (n_job) — varchar(30)
  • 성별 (n_gender) — char(1)
  • 전화번호 (n_tellnum) — varchar(20)
  • 이메일 (n_email) — varchar(30)
  • 직급 (n_rank) — varchar(20)

patient (Untitled2)

  • 환자ID (p_id) — integer — Primary key — NOT NULL
  • 환자이름 (p_name) — varchar(30)
  • 주민번호 (p_snum) — varchar(20)
  • 의사ID (d_id) — integer — Foreign key → doctor.의사ID — NOT NULL
  • 진료과목 (d_department) — varchar(30) — Foreign key → doctor.담당진료과목 — NOT NULL
  • 성별 (p_gender) — char(1)
  • 연락처 (p_tellnum) — varchar(20)
  • 주소 (p_address) — varchar(50)
  • 이메일 (p_email) — varchar(30)
  • 직업 (p_job) — varchar(20)

station (Untitled3)

  • 날짜 (s_date) — date — Primary key — NOT NULL
  • 진료순번 (s_id) — integer — Primary key — NOT NULL
  • 의사ID (d_id) — integer — Foreign key → doctor.의사ID — NOT NULL
  • 담당진료과목 (d_department) — varchar(30) — Foreign key → doctor.담당진료과목 — NOT NULL
  • 환자ID (p_id) — integer — Foreign key → patient.환자ID — NOT NULL
  • 간호사ID (n_id) — integer — Foreign key → nurse.간호사ID — NOT NULL
  • 진료내용 (s_details) — varchar(100)