dsu_hospital

Tables (5)

Treatment

  • treatmentID — INTEGER — Primary key — NOT NULL
  • doctorID — INTEGER
  • patientID — INTEGER
  • treatmentdetails — varchar(60)
  • treatmentdate — INTEGER
  • doctorID (doctorID2) — INTEGER — Foreign key → doctors.doctorID — NOT NULL
  • patientID (patientID2) — INTEGER — Foreign key → patients.patientID — NOT NULL
  • nurseid — INTEGER — Foreign key → nurses.nurseid — NOT NULL

doctors

  • doctorID — INTEGER — Primary key — NOT NULL
  • specialty — varchar(30)
  • doctorName — varchar(30)
  • Gender — varchar(20)
  • contactInfo — varchar(30)
  • e-mail — varchar(30)
  • job_title — varchar
  • patientID — INTEGER — Foreign key → patients.patientID — NOT NULL
  • nurseid — INTEGER — Foreign key → nurses.nurseid — NOT NULL

medicalchart

  • chartNo — INTEGER — Primary key — NOT NULL
  • doctorID — INTEGER
  • nurseid — INTEGER
  • patientID — INTEGER
  • treatmentID — INTEGER
  • opinionDoctor — varchar(60)
  • doctorID (doctorID2) — INTEGER — Foreign key → doctors.doctorID — NOT NULL
  • patientID (patientID2) — INTEGER — Foreign key → patients.patientID — NOT NULL
  • nurseid (nurseid2) — INTEGER — Foreign key → nurses.nurseid — NOT NULL

nurses

  • nurseid — INTEGER — Primary key — NOT NULL
  • responsibility — varchar(20)
  • Nursename — varchar(30)
  • nursegender — varchar(20)
  • phoneNo — INTEGER
  • e-mail — varchar(30)
  • job_title — varchar(40)
  • doctorID — INTEGER — Foreign key → doctors.doctorID — NOT NULL
  • patientID — INTEGER — Foreign key → patients.patientID — NOT NULL

patients

  • patientID — INTEGER — Primary key — NOT NULL
  • patient_name — varchar(30)
  • m_attentand (m_attendant) — INTEGER
  • nurse_in_charge — varchar(30)
  • gender — varchar(20)
  • e-mail — varchar(30)
  • socialsecurityNo — INTEGER
  • address — varchar(30)
  • job — varchar(30)
  • doctorID — INTEGER — Foreign key → doctors.doctorID — NOT NULL
  • nurseid — INTEGER — Foreign key → nurses.nurseid — NOT NULL