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