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