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