실험용
테이블 (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)