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