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)