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