erd
Tables (5)
DEPARTMENT
- DEP_CODE — VARCHAR2(4)
- DEP_NAME — VARCHAR2(100) — NOT NULL
DOCTOR
- DOC_CODE — NUMBER
- DOC_NAME — VARCHAR2(50) — NOT NULL
- DEP_CODE — VARCHAR2(4) — Foreign key → DEPARTMENT.DEP_CODE — NOT NULL
INPATIENT
- INP_CODE — NUMBER
- PAT_CODE — NUMBER — Foreign key → PATIENT.PAT_CODE — NOT NULL
- INP_YEAR — VARCHAR2(4) — NOT NULL
- INP_DATE — VARCHAR2(4) — NOT NULL
- INP_TIME — VARCHAR2(4) — NOT NULL
PATIENT
- PAT_CODE — NUMBER
- PAT_NAME — VARCHAR2(50) — NOT NULL
- PAT_BIRTH — NUMBER(8) — NOT NULL
- PAT_GENDER — VARCHAR2(1) — NOT NULL
- PAT_TEL — VARCHAR2(11)
- PAT_POSTCODE — VARCHAR2(5)
- PAT_ADDR1 — VARCHAR2(300)
- PAT_ADDR2 — VARCHAR2(200)
- Field
TREAT
- TRT_CODE — NUMBER
- PAT_CODE — NUMBER — Foreign key → PATIENT.PAT_CODE — NOT NULL
- TRT_YEAR — VARCHAR2(4) — NOT NULL
- TRT_DATE — VARCHAR2(4) — NOT NULL
- TRT_TIME — VARCHAR2(4) — NOT NULL
- TRT_RECEIPT — VARCHAR2(4) — NOT NULL
- DOC_CODE — NUMBER — Foreign key → DOCTOR.DOC_CODE — NOT NULL