DSU_Hospital

Tables (5)

Chart

  • number (chart_number) — integer — Primary key — NOT NULL
  • ID (nurse_ID) — integer — Foreign key → nurses.ID — NOT NULL
  • doctor's_opinion — varchar(50)
  • ID (doc_ID) — integer — Foreign key → Doctor.ID — NOT NULL
  • ID (patients_ID) — integer — Foreign key → patients.ID — NOT NULL
  • ID (nurse_ID2) — integer — Foreign key → nurses.ID — NOT NULL
  • ID (Treatment_ID) — date — Foreign key → Treatment.ID — NOT NULL

Doctor

  • ID (doc_ID) — integer — Primary key — NOT NULL
  • name (doc_name) — varchar(25)
  • gender (doc_gender) — varchar(10)
  • contact_information (con_inf)
  • email (doc_email) — varchar(40)
  • job_title (job_doc) — varchar(30)
  • medical_field (doc_field) — varchar(35)
  • ID (patients_ID) — integer — Foreign key → patients.ID — NOT NULL
  • ID (Treatment_ID) — date — Foreign key → Treatment.ID — NOT NULL
  • ID (nurse_ID) — integer — Foreign key → Chart.ID — NOT NULL

Treatment

  • ID (Treatment_ID) — date — Primary key — NOT NULL
  • date (treatment_date) — date
  • number (treatment_number) — integer
  • details (treatment_details) — varchar(40)
  • ID (patients_ID) — integer — Foreign key → patients.ID — NOT NULL
  • ID (doc_ID) — integer — Foreign key → Doctor.ID — NOT NULL

nurses

  • ID (nurse_ID) — integer — Primary key — NOT NULL
  • responsibilty (nurse_resp) — varchar(40)
  • name (nurse_name) — varchar(26)
  • gender (nurse_gender) — varchar(11)
  • phone number (nurse_phone_number) — integer
  • email (nurse_email) — varchar(32)
  • job (nurse_job_title) — varchar(25)

patients

  • ID (patients_ID) — integer — Primary key — NOT NULL
  • medical_attendant (pat_atten) — varchar(40)
  • nurse in charge (patient_nurse) — varchar(38)
  • name (patient_name) — varchar(29)
  • social security number (sec_number) — integer
  • gender (patient_gender) — varchar(10)
  • address (patient_add) — varchar(31)
  • email (patient_email) — varchar(28)
  • job (patient_job) — varchar(45)
  • ID (doc_ID) — integer — Foreign key → Doctor.ID — NOT NULL
  • ID (nurse_ID) — integer — Foreign key → nurses.ID — NOT NULL
  • ID (Treatment_ID) — date — Foreign key → Treatment.ID — NOT NULL