hospitalEx

Tables (5)

chartTBL

  • chart_id — int — Primary key — NOT NULL
  • consul_id — VARCHAR(12) — Foreign key → consultationTBL.consul_id — NOT NULL
  • doctor_id — VARCHAR(12) — Foreign key → consultationTBL.doctor_id — NOT NULL
  • patient_id — VARCHAR(12) — Foreign key → consultationTBL.patient_id — NOT NULL
  • nurse_id — VARCHAR(12) — Foreign key → nurseTBL.nurse_id — NOT NULL
  • drs_opinion — TEXT — NOT NULL

consultationTBL

  • consul_id — VARCHAR(12) — Primary key — NOT NULL
  • doctor_id — VARCHAR(12) — Foreign key → doctorTBL.doctor_id — NOT NULL
  • patient_id — VARCHAR(12) — Foreign key → patientTBL.patient_id — NOT NULL
  • details — VARCHAR(20) — NOT NULL
  • consul_date — datetime

doctorTBL

  • doctor_id — VARCHAR(12) — Primary key — NOT NULL
  • department — VARCHAR(20) — NOT NULL
  • name — VARCHAR(10) — NOT NULL
  • gender — CHAR(1) — NOT NULL
  • contact — VARCHAR(20)
  • email — VARCHAR(40)
  • job_grade — VARCHAR(20) — NOT NULL

nurseTBL

  • nurse_id — VARCHAR(12) — Primary key — NOT NULL
  • department — VARCHAR(20) — NOT NULL
  • name — VARCHAR(10) — NOT NULL
  • gender — CHAR(1) — NOT NULL
  • contact — VARCHAR(20)
  • email — VARCHAR(40)
  • job_grade — VARCHAR(20) — NOT NULL

patientTBL

  • patient_id — VARCHAR(12) — Primary key — NOT NULL
  • doctor_id — VARCHAR(12) — Foreign key → doctorTBL.doctor_id — NOT NULL
  • name — VARCHAR(10) — NOT NULL
  • resident_no — CHAR(13) — NOT NULL
  • gender — CHAR(1) — NOT NULL
  • address — VARCHAR(100) — NOT NULL
  • contact — VARCHAR(20)
  • email — VARCHAR(40)
  • profession — VARCHAR(20)