ver.4

Tables (5)

AI_ANALYSIS

  • analysis_id — INT
  • diagnosis_id — INT — Foreign key → DIAGNOSIS.diagnosis_id — NOT NULL
  • predicted_condition — VARCHAR(100)
  • confidence_score — FLOAT
  • severity_level — VARCHAR(20)
  • hospital_visit_recommended — BOOLEAN
  • analyzed_at — DATETIME

DIAGNOSIS

  • diagnosis_id — INT
  • diagnosis_date — DATETIME — NOT NULL
  • created_at — DATETIME

GUIDE

  • guide_id — INT
  • analysis_id — INT — Foreign key → AI_ANALYSIS.analysis_id — NOT NULL
  • diagnosis_id — INT — Foreign key → DIAGNOSIS.diagnosis_id — NOT NULL
  • home_care_instructions — TEXT
  • follow_up_recommendations — TEXT
  • created_at — DATETIME

IMAGE

  • image_id — INT
  • diagnosis_id — INT — Foreign key → DIAGNOSIS.diagnosis_id — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • uploaded_at — DATETIME

SYMPTOM

  • symptom_id — INT
  • diagnosis_id — INT — Foreign key → DIAGNOSIS.diagnosis_id — NOT NULL
  • location — VARCHAR(50)
  • fever — BOOLEAN
  • itching — BOOLEAN
  • inflammation — BOOLEAN
  • description — TEXT