ㅇㄹ
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)