AI medical
Tables (18)
analysis_result
- id — BIGINT — Primary key — NOT NULL
- document_id — BIGINT — Foreign key → document.id — NOT NULL
- llm_model — VARCHAR(50) — NOT NULL
- extracted_json — TEXT
- plain_summary — TEXT
- ocr_confidence — FLOAT
- analyzed_at — DATETIME — NOT NULL
diagram
- id — BIGINT — Primary key — NOT NULL
- analysis_result_id — BIGINT — Foreign key → analysis_result.id — NOT NULL
- svg_content — TEXT — NOT NULL
- template_code — VARCHAR(50)
- generated_at — DATETIME — NOT NULL
document
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- document_type_id — BIGINT — Foreign key → document_type.id — NOT NULL
- file_url — VARCHAR(500) — NOT NULL
- mime_type — VARCHAR(50) — NOT NULL
- captured_at — DATETIME
- uploaded_at — DATETIME — NOT NULL
document_type
- id — BIGINT — Primary key — NOT NULL
- code — VARCHAR(30) — NOT NULL
- name_ko — VARCHAR(50) — NOT NULL
infographic
- id — BIGINT — Primary key — NOT NULL
- reference_paper_id — BIGINT — Foreign key → reference_paper.id — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- svg_content — TEXT — NOT NULL
- generated_at — DATETIME — NOT NULL
lab_item
- id — BIGINT — Primary key — NOT NULL
- loinc_code — VARCHAR(30) — NOT NULL
- name_ko — VARCHAR(100) — NOT NULL
- unit_std — VARCHAR(20)
- ref_low — DOUBLE
- ref_high — DOUBLE
lab_result
- id — BIGINT — Primary key — NOT NULL
- analysis_result_id — BIGINT — Foreign key → analysis_result.id — NOT NULL
- lab_item_id — BIGINT — Foreign key → lab_item.id — NOT NULL
- value_raw — DOUBLE — NOT NULL
- unit_raw — VARCHAR(20)
- value_norm — DOUBLE
- measured_at — DATE — NOT NULL
medication
- id — BIGINT — Primary key — NOT NULL
- kdcode — VARCHAR(30) — NOT NULL
- name_ko — VARCHAR(100) — NOT NULL
- name_en — VARCHAR(100)
- ingredient — VARCHAR(255)
medication_log
- id — BIGINT — Primary key — NOT NULL
- medication_schedule_id — BIGINT — Foreign key → medication_schedule.id — NOT NULL
- taken_at — DATETIME — NOT NULL
- status — VARCHAR(20) — NOT NULL
medication_schedule
- id — BIGINT — Primary key — NOT NULL
- prescription_item_id — BIGINT — Foreign key → prescription_item.id — NOT NULL
- cron_expr — VARCHAR(100) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE
- active — INT — NOT NULL
member
- id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- age — INT — NOT NULL
- sex — VARCHAR(10)
- specificity_disease — VARCHAR(255)
- created_at — DATETIME
membership
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- tier — VARCHAR(20) — NOT NULL
- started_at — DATE — NOT NULL
- expires_at — DATE
notification
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- medication_schedule_id — BIGINT — Foreign key → medication_schedule.id — NOT NULL
- channel — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- scheduled_at — DATETIME — NOT NULL
- sent_at — DATETIME
payment
- id — BIGINT — Primary key — NOT NULL
- membership_id — BIGINT — Foreign key → membership.id — NOT NULL
- amount — INT — NOT NULL
- method — VARCHAR(30) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- paid_at — DATETIME — NOT NULL
prescription
- id — BIGINT — Primary key — NOT NULL
- analysis_result_id — BIGINT — Foreign key → analysis_result.id — NOT NULL
- hospital_name — VARCHAR(100)
- prescriber — VARCHAR(50)
- prescribed_at — DATE — NOT NULL
prescription_item
- id — BIGINT — Primary key — NOT NULL
- prescription_id — BIGINT — Foreign key → prescription.id — NOT NULL
- medication_id — BIGINT — Foreign key → medication.id — NOT NULL
- dose — FLOAT
- dose_unit — VARCHAR(20)
- frequency_raw — VARCHAR(100)
- duration_days — INT
reference_paper
- id — BIGINT — Primary key — NOT NULL
- pmid — VARCHAR(30) — NOT NULL
- title — VARCHAR(500) — NOT NULL
- source — VARCHAR(100)
- chroma_collection — VARCHAR(100)
tts_audio
- id — BIGINT — Primary key — NOT NULL
- analysis_result_id — BIGINT — Foreign key → analysis_result.id — NOT NULL
- audio_url — VARCHAR(500) — NOT NULL
- engine — VARCHAR(50)
- duration_sec — INT
- generated_at — DATETIME — NOT NULL