병원

테이블 (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