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