병원
테이블 (14)
admissions
- admission_id — VARCHAR(10) — 기본 키 — NOT NULL
- appointment_id — INT — 외래 키 → appointments.appointment_id — NOT NULL
- ward_bed — VARCHAR(10)
- type — VARCHAR(10)
- status — VARCHAR(3)
- admission_date — DATETIME
- discharge_date — DATETIME
- employee_number — VARCHAR(20)
- records — TEXT
allergy
- resident_number — VARCHAR(15) — 외래 키 → patients.resident_number — NOT NULL — identification_number
- category — VARCHAR(45)
- allergen — VARCHAR(45)
- reaction — TEXT
- severity — INT
- record_date — DATETIME
appointments
- appointment_id — INT — 기본 키 — NOT NULL
- resident_number — VARCHAR(15) — 외래 키 → patients.resident_number — NOT NULL — identification_number
- employee_number — VARCHAR(13) — 외래 키 → doctors.employee_number — NOT NULL
- date — DATETIME
- CC — VARCHAR(45)
chart_records
- chart_id — INT — 기본 키 — NOT NULL
- resident_number — VARCHAR(15) — 외래 키 → patients.resident_number — NOT NULL — identification_number
- employee_number — VARCHAR(13) — 외래 키 → doctors.employee_number — NOT NULL
- date — DATE
- KCD_code — VARCHAR(10)
- diagnosis — VARCHAR(45)
- CC — VARCHAR(45)
- manifestation — TEXT
doctors
- employee_number — VARCHAR(13) — 기본 키 — NOT NULL
- custodian_id — VARCHAR(12) — 외래 키 → medical_institution.custodian_id — NOT NULL
- password — VARCHAR(12)
- name — VARCHAR(10)
- license_id — VARCHAR(10)
- phone_number — VARCHAR(15)
- specialty — VARCHAR(10) — 의료진이 의사인지 간호사인지 구분 목적
drugs
- drugs_name — VARCHAR(45) — 기본 키 — NOT NULL
- drugs_code — VARCHAR(20) — 기본 키 — NOT NULL
- drugs_component — VARCHAR(45)
- generic_name — VARCHAR(45)
- dosage_Form — VARCHAR(20)
- side_effects — VARCHAR(45)
- interactions — VARCHAR(45)
- quantity_unit — VARCHAR(45)
- quantity — INT
- expiry_period — DATE
- manufacturer — VARCHAR(20)
- storage — VARCHAR(20)
inspections
- inspection_id — VARCHAR(10) — 기본 키 — NOT NULL
- appointment_id — INT — 외래 키 → appointments.appointment_id — NOT NULL
- name — VARCHAR(45)
- employee_number — VARCHAR(20)
- status — VARCHAR(3)
- inspection_date — DATETIME
- inspection — TEXT
medical_institution
- custodian_id — VARCHAR(10) — 기본 키 — NOT NULL
- department_code — VARCHAR(10)
- department — VARCHAR(15)
- contact — VARCHAR(15)
operations
- operation_id — VARCHAR(10) — 기본 키 — NOT NULL
- appointment_id — INT — 외래 키 → appointments.appointment_id — NOT NULL
- name — VARCHAR(40)
- operating_room — VARCHAR(10)
- status — VARCHAR(3)
- employee_number — VARCHAR(20)
- s_date — DATETIME
- e_date — DATETIME
- notes — TEXT
patients
- resident_number — VARCHAR(15) — 기본 키 — NOT NULL — identification_number
- name — VARCHAR(10) — 환자이름
- gender — VARCHAR(1)
- address — VARCHAR(20)
- phone_number — VARCHAR(15)
- emergency_number — VARCHAR(15)
- dosing_list — TEXT
- blood_type — VARCHAR(4)
payments
- payment_id — INT — 기본 키 — NOT NULL
- resident_number — VARCHAR(15) — 외래 키 → patients.resident_number — NOT NULL — identification_number
- custodian_id — VARCHAR(10) — 외래 키 → medical_institution.custodian_id — NOT NULL
- date — DATETIME
- p_date — DATETIME
- status — VARCHAR(10)
- total — INT
prescriptions
- prescription_id — INT — 기본 키 — NOT NULL
- drugs_name — VARCHAR(45) — 외래 키 → drugs.drugs_name — NOT NULL
- resident_number — VARCHAR(15) — 외래 키 → patients.resident_number — NOT NULL — identification_number
- employee_number — VARCHAR(13) — 외래 키 → doctors.employee_number — NOT NULL
- date — DATE
- method — VARCHAR(20)
- dosage — VARCHAR(20)
- daily_dosage — FLOAT
- frequency — INT — QD (Quaque Die): 매일 한 번 BID (Bis In Die): 하루 두 번 TID (Ter In Die): 하루 세 번 QID (Quater In Die): 하루 네 번
- duration — INT
- notes — TEXT
vaccinations
- resident_number — VARCHAR(15) — 외래 키 → patients.resident_number — NOT NULL — identification_number
- date — DATE
- v_name — VARCHAR(40)
- d_name — VARCHAR(40)
- th — INT
- status — VARCHAR(3)
- reason — VARCHAR(40)
vitalsign_status
- chart_id — INT — 외래 키 → chart_records.chart_id — NOT NULL
- resident_number — VARCHAR(15) — 외래 키 → chart_records.resident_number — NOT NULL — identification_number
- D.BP — INT
- S.BP — INT
- PR — INT
- RR — INT
- BT — FLOAT
- spO2 — INT
- height — FLOAT
- weight — FLOAT