DSU Hospital

Tables (3)

doctor

  • ID (doctorid) — Primary key — NOT NULL
  • medical field (medical_field)
  • name (doctor_name)
  • gender
  • contact information (contact_info)
  • email
  • job title (job_title)

nurse

  • ID (nurseid) — Primary key — NOT NULL
  • responsibility
  • name (nurse_name)
  • gender
  • phone number (phone_number)
  • email
  • jobtitle (job_title)

patient

  • ID (patientid) — Primary key — NOT NULL
  • ssn (patient_ssn) — Primary key — NOT NULL
  • ID (doctorid) — Foreign key → doctor.ID — NOT NULL
  • ID (nurseid2) — Foreign key → nurse.ID — NOT NULL
  • medical attendant (medical_attendant)
  • nurse (nurseid)
  • name (patient_name)
  • gender
  • address
  • email
  • job