HOSPITAL_ERD

Tables (4)

DOCTOR_TBL (의사정보)

  • DEPARTMENT_ID (병원부서코드) — NUMBER(2) — Primary key — NOT NULL
  • D_NAME (주치의명) — NCHAR(6)
  • IN_TIME (출근시간) — DATE
  • OUT_TIME (퇴근시간) — DATE

HOSPITALIZATION_TBL (입원정보)

  • ROOM_NUM (병실코드) — NUMBER(3) — Primary key — NOT NULL
  • PATIENT_ID (환자코드) — CHAR(8)
  • P_NAME (환자명) — NCHAR(6)
  • DEPARTMENT_ID (병원부서코드) — NUMBER(2)
  • SURG_DATE (수술날짜) — DATE
  • HOSP_DATE (입원날짜) — DATE

PATIENT_TBL (환자정보)

  • PATIENT_ID (환자코드) — CHAR(8 BYTE) — Primary key — NOT NULL
  • P_NAME (환자명) — NCHAR(6)
  • P_BIRTH (생년월일) — NUMBER(6)
  • D_NAME (주치의명) — NCHAR(6)
  • G_NAME (보호자명) — NCHAR(6)
  • DEPARTMENT_ID (병원부서코드) — NUMBER(2)
  • SURGERY (수술여부) — CHAR(1)
  • HOSPITALIZATION (입원여부) — CHAR(1)
  • RECENT (최근방문날짜) — DATE

SURGERY_TBL (수술정보)

  • PATIENT_ID (환자코드) — CHAR(8)
  • P_NAME (환자명) — NCHAR(6)
  • D_NAME (주치의명) — NCHAR(6)
  • SURGERY_DATE (수술날짜) — DATE