ㅇㄹ

Tables (11)

Diagnosis

  • diagnosis_id — INT
  • diagnosis_code — VARCHAR(20)
  • diagnosis_content — TEXT

DiagnosisCode

  • diagnosis_code — VARCHAR(20)
  • diagnosis_name — VARCHAR(50)
  • disease_classification — VARCHAR(20)

Drug

  • drug_code — VARCHAR(20)
  • drug_name — VARCHAR(100)
  • specification — VARCHAR(50)
  • manufacturer — VARCHAR(50)
  • unit — VARCHAR(10)

ExternalCardCompany

  • external_card_company_id — INT
  • name — VARCHAR(50)
  • discount_rate — DECIMAL(5,2)

Patient

  • patient_id — VARCHAR(10)
  • name — VARCHAR(50)
  • birth_date — DATE
  • gender — CHAR(1)
  • address — VARCHAR(200)
  • contact — VARCHAR(15)
  • nationality_flag — CHAR(1)

Payment

  • payment_id — INT
  • patient_id — VARCHAR(10)
  • treatment_id — INT
  • amount — DECIMAL(10,2)
  • payment_method — VARCHAR(20)
  • payment_type — VARCHAR(20)
  • external_card_company_id — INT

PrescriptionItem

  • prescription_item_id — INT
  • treatment_id — INT
  • drug_code — VARCHAR(20)
  • quantity — INT
  • dosage_instructions — TEXT
  • medication_period — INT
  • precautions — TEXT
  • drug_type — VARCHAR(20)

Registration

  • registration_id — INT
  • reservation_id — INT
  • registration_status — VARCHAR(20)

Reservation

  • reservation_id — INT
  • patient_id — VARCHAR(10)
  • staff_id — VARCHAR(8)
  • department_code — VARCHAR(10)
  • reservation_status — VARCHAR(20)
  • date_time — DATETIME

Staff

  • staff_id — VARCHAR(8)
  • name — VARCHAR(50)
  • birth_date — DATE
  • gender — CHAR(1)
  • contact — VARCHAR(15)
  • position — VARCHAR(20)
  • specialty — VARCHAR(50)
  • department_code — VARCHAR(10)

Treatment

  • treatment_id — INT
  • registration_id — INT
  • diagnosis_id — INT
  • medical_opinion — TEXT
  • treatment_status — VARCHAR(10)