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