실험용

테이블 (17)

admission

  • admission_code — VARCHAR(255) — 기본 키 — NOT NULL
  • patient_code — VARCHAR(255) — 외래 키 → patient.patient_code — NOT NULL
  • doctor_code — VARCHAR(255) — 외래 키 → doctor.doctor_code — NOT NULL
  • Key — VARCHAR(255) — 외래 키 → ward.ward_code — NOT NULL
  • ward_code — VARCHAR(255) — 외래 키 → ward.ward_code — NOT NULL

chart

  • chart_code — VARCHAR(255) — 기본 키 — NOT NULL
  • nurse_code — VARCHAR(255) — 외래 키 → nurse.nurse_code — NOT NULL
  • treatment_code — VARCHAR(255) — 외래 키 → treatment.treatment_code — NOT NULL
  • chart_content — VARCHAR(255)

doctor

  • doctor_code — VARCHAR(255) — 기본 키 — NOT NULL

doctor_information

  • doctor_code — VARCHAR(255) — 외래 키 → doctor.doctor_code — NOT NULL
  • name — VARCHAR(255)
  • ssn — VARCHAR(255)
  • gender — VARCHAR(255)
  • major — VARCHAR(255)
  • contact — VARCHAR(255)

icu

  • Key — VARCHAR(255) — 기본 키 — NOT NULL
  • icu_name — VARCHAR(255)
  • icu_capacity — VARCHAR(255)

medication

  • medication_code — VARCHAR(255) — 기본 키 — NOT NULL
  • medication_name — VARCHAR(255)
  • effectiveness — VARCHAR(255)
  • usage — VARCHAR(255)
  • side_effects — VARCHAR(255)

nurse

  • nurse_code — VARCHAR(255) — 기본 키 — NOT NULL

nurse_information

  • nurse_code — VARCHAR(255) — 외래 키 → nurse.nurse_code — NOT NULL
  • name — VARCHAR(255)
  • ssn — VARCHAR(255)
  • gender — VARCHAR(255)
  • address — VARCHAR(255)
  • contact — VARCHAR(255)

operating_room

  • Key — VARCHAR(255) — 기본 키 — NOT NULL
  • operating_room_code — VARCHAR(255)
  • operating_room_capacity — VARCHAR(255)

patient

  • patient_code — VARCHAR(255) — 기본 키 — NOT NULL

patient_information

  • patient_code — VARCHAR(255) — 외래 키 → patient.patient_code — NOT NULL
  • gender — VARCHAR(255)
  • name — VARCHAR(255)
  • ssn — VARCHAR(255)
  • address — VARCHAR(255)
  • contact — VARCHAR(255)
  • ktas_stage — VARCHAR(255)

prescription

  • Key — VARCHAR(255) — 기본 키 — NOT NULL
  • patient_code — VARCHAR(255) — 외래 키 → patient.patient_code — NOT NULL
  • doctor_code — VARCHAR(255) — 외래 키 → doctor.doctor_code — NOT NULL

prescription_details

  • Key — VARCHAR(255) — 외래 키 → prescription.Key — NOT NULL
  • content — VARCHAR(255)

surgery

  • Key — VARCHAR(255) — 기본 키 — NOT NULL
  • patient_code — VARCHAR(255) — 외래 키 → patient.patient_code — NOT NULL
  • doctor_code — VARCHAR(255) — 외래 키 → doctor.doctor_code — NOT NULL
  • surgery_date — VARCHAR(255)
  • surgery_name — VARCHAR(255)

treatment

  • treatment_code — VARCHAR(255) — 기본 키 — NOT NULL
  • patient_code — VARCHAR(255) — 외래 키 → patient.patient_code — NOT NULL
  • doctor_code — VARCHAR(255) — 외래 키 → doctor.doctor_code — NOT NULL

treatment_details

  • treatment_code — VARCHAR(255) — 외래 키 → treatment.treatment_code — NOT NULL
  • content — VARCHAR(255)
  • date — VARCHAR(255)

ward

  • ward_code — VARCHAR(255) — 기본 키 — NOT NULL
  • ward_name — VARCHAR(255)
  • ward_capacity — VARCHAR(255)