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