DSU_hospital
Tables (5)
chart
- chartnumber — integer — Primary key — NOT NULL
- doctoropinion — varchar(200)
- doctorid — integer — Foreign key → doctors.doctorid — NOT NULL
- nurseid — integer — Foreign key → nurses.nurseid — NOT NULL
- treatmentid — date — Foreign key → treatment.treatmentid — NOT NULL
- patientid — integer — Foreign key → patients.patientid — NOT NULL
doctors
- doctorid — integer — Primary key — NOT NULL
- name — varchar(40)
- gender — varchar(20)
- charge — varchar(50)
- contact — varchar40()
- email — varchar(40)
- job_title — varchar(25)
- patientid — integer — Foreign key → patients.patientid — NOT NULL
- patientid (patientid2) — integer — Foreign key → patients.patientid — NOT NULL
nurses
- nurseid — integer — Primary key — NOT NULL
- responsibilities (respobsibilities) — varchar(40)
- nurse_name — varchar(40)
- nurse_gender — varchar(20)
- phone_number — varchar(20)
- nurse_email — varchar(20)
- nurse_job — varchar(30)
- patientid — integer — Foreign key → patients.patientid — NOT NULL
patients
- patientid — integer — Primary key — NOT NULL
- ss_number — integer
- med_attendant — varchar(40)
- pgender — varchar(20)
- pemail — varchar(40)
- address — varchar(50)
- pjob — varchar(40)
- nurse — varchar(40)
- doctorid — integer — Foreign key → doctors.doctorid — NOT NULL
- nurseid — integer — Foreign key → nurses.nurseid — NOT NULL
treatment
- treatmentid — date — Primary key — NOT NULL
- traetmentdetails (treatmentdetails) — varchar(60)
- treatment_date — date
- doctorid — integer — Foreign key → doctors.doctorid — NOT NULL
- patientid — integer — Foreign key → patients.patientid — NOT NULL
- nurseid — integer — Foreign key → nurses.nurseid — NOT NULL