ver.1
Tables (6)
Baby
- baby_id — INT — Primary key
- user_id — INT — Foreign key → User.user_id
- name — VARCHAR(255) — NOT NULL
- birth_date — DATE — NOT NULL
- gender — VARCHAR(10)
- created_at — DATETIME
- updated_at — DATETIME
DiagnosisImage
- image_id — INT — Primary key
- diagnosis_id — INT — Foreign key → SkinDiagnosis.diagnosis_id
- image_url — VARCHAR(255) — NOT NULL
- created_at — DATETIME
SkinDiagnosis
- diagnosis_id — INT — Primary key
- user_id — INT — Foreign key → User.user_id
- baby_id — INT — Foreign key → Baby.baby_id
- diagnosis_date — DATETIME — NOT NULL
- ai_diagnosis — VARCHAR(255)
- severity — VARCHAR(50)
- hospital_visit_recommended — BOOLEAN
- notes — TEXT
- created_at — DATETIME
- updated_at — DATETIME
Symptom
- symptom_id — INT — Primary key
- diagnosis_id — INT — Foreign key → SkinDiagnosis.diagnosis_id
- name — VARCHAR(255) — NOT NULL
- description — TEXT
Treatment
- treatment_id — INT — Primary key
- diagnosis_id — INT — Foreign key → SkinDiagnosis.diagnosis_id
- name — VARCHAR(255) — NOT NULL
- description — TEXT
User
- user_id — INT — Primary key
- username — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME