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)