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