1
Tables (12)
admission
- admission_code — VARCHAR(255) — Primary key — NOT NULL
- patient_code — VARCHAR(255) — Foreign key → patient.patient_code — NOT NULL
- doctor_code — VARCHAR(255) — Foreign key → doctor.doctor_code — NOT NULL
- key — VARCHAR(255) — NOT NULL
- ward_code — VARCHAR(255) — Foreign key → ward.ward_code — NOT NULL
chart
- chart_code — VARCHAR(255) — Primary key — NOT NULL
- nurse_code — VARCHAR(255) — Foreign key → nurse.nurse_code — NOT NULL
- treatment_code — VARCHAR(255) — Foreign key → treatment.treatment_code — NOT NULL
- chart_content — VARCHAR(255)
doctor
- doctor_code — VARCHAR(255) — Primary key — NOT NULL
- doctor_name — VARCHAR(255)
- doctor_ssn — VARCHAR(255)
- doctor_gender — VARCHAR(255)
- doctor_major — VARCHAR(255)
- doctor_contact — VARCHAR(255)
icu
- icu_code — VARCHAR(255) — Primary key — NOT NULL
- icu_name — VARCHAR(255)
- icu_capacity — VARCHAR(255)
medication
- medication_code — VARCHAR(255) — Primary key — NOT NULL
- medication_name — VARCHAR(255)
- effectiveness — VARCHAR(255)
- usage — VARCHAR(255)
- side_effects — VARCHAR(255)
nurse
- nurse_code — VARCHAR(255) — Primary key — NOT NULL
- nurse_name — VARCHAR(255)
- nurse_ssn — VARCHAR(255)
- nurse_gender — VARCHAR(255)
- nurse_address — VARCHAR(255)
- nurse_contact — VARCHAR(255)
operating_room
- operating_room_code — VARCHAR(255) — Primary key — NOT NULL
- operating_room_name — VARCHAR(255)
- operating_room_capacity — VARCHAR(255)
patient
- patient_code — VARCHAR(255) — Primary key — NOT NULL
- patient_gender — VARCHAR(255)
- patient_name — VARCHAR(255)
- patient_ssn — VARCHAR(255)
- patient_address — VARCHAR(255)
- patient_contact — VARCHAR(255)
- patient_ktas_stage — VARCHAR(255)
prescription
- prescription_code — VARCHAR(255) — Primary key — NOT NULL
- patient_code — VARCHAR(255) — Foreign key → patient.patient_code — NOT NULL
- doctor_code — VARCHAR(255) — Foreign key → doctor.doctor_code — NOT NULL
- prescription_content — VARCHAR(255)
surgery
- surgery_code — VARCHAR(255) — Primary key — NOT NULL
- patient_code — VARCHAR(255) — Foreign key → patient.patient_code — NOT NULL
- doctor_code — VARCHAR(255) — Foreign key → doctor.doctor_code — NOT NULL
- surgery_date — VARCHAR(255)
- surgery_name — VARCHAR(255)
treatment
- treatment_code — VARCHAR(255) — Primary key — NOT NULL
- patient_code — VARCHAR(255) — Foreign key → patient.patient_code — NOT NULL
- doctor_code — VARCHAR(255) — Foreign key → doctor.doctor_code — NOT NULL
- treatment_content — VARCHAR(255)
- treatment_date — VARCHAR(255)
ward
- ward_code — VARCHAR(255) — Primary key — NOT NULL
- ward_name — VARCHAR(255)
- ward_capacity — VARCHAR(255)