data_base

Tables (8)

Untitled (Users)

  • Key (UserID) — INTEGER — Primary key — NOT NULL
  • Field (Email) — VARCHAR(100)
  • Field (Name) — VARCHAR(100)
  • Field (Password) — VARCHAR(100)
  • Field (SignUpDate) — DATE
  • Field (AGE) — INTEGER
  • Field (DIET) — VARCHAR(255)
  • Field (MedicalHistory) — VARCHAR(255)

Untitled (ImageData)

  • Key (ImageID) — INTEGER — Primary key — NOT NULL
  • Key (UserID) — INTEGER — Foreign key → Untitled.Key — NOT NULL
  • Field (ImagePath) — VARCHAR(255)
  • Field (UploadDate) — DATE
  • Field (MetaData) — VARCHAR(255)

Untitled (SearchHistory)

  • Key (SearchID) — INTEGER — Primary key — NOT NULL
  • Field (SearchTerm) — VARCHAR(255)
  • Field (SearchDate) — DATE
  • Key (UserID) — INTEGER — Foreign key → Untitled.Key — NOT NULL

Untitled (ImageAnalysisResults)

  • Key (AnalysisID) — INTEGER — Primary key — NOT NULL
  • Field (DiseaseResult) — VARCHAR(255)
  • Field (AnalysisDate) — DATE
  • Field (AdditionalNotes) — VARCHAR(255)
  • Field
  • Key (ImageID) — INTEGER — Foreign key → Untitled.Key — NOT NULL

Untitled (FeedbackRecommend)

  • Key (FeedbackID) — INTEGER — Primary key — NOT NULL
  • Field (Advice) — VARCHAR(255)
  • Field (GenerateDate) — DATE
  • Field
  • Key (UserID) — INTEGER — Foreign key → Untitled.Key — NOT NULL

Untitled (SkinDiseaseInfo)

  • Key (DiseaseID) — INTEGER — Primary key — NOT NULL
  • Field (DiseaseName) — VARCHAR(100)
  • Field (Description) — VARCHAR(100)
  • Field (Treatment) — VARCHAR(100)
  • Field (Prevention) — VARCHAR(100)
  • Field (RelatedImages) — VARCHAR(100)

Untitled (FAQResponses)

  • Key (FAQID) — INTEGER — Primary key — NOT NULL
  • Field (Question) — VARCHAR(100)
  • Field (Answer) — VARCHAR(100)
  • Field (GenerateDate) — DATE
  • Key (UserID) — INTEGER — Foreign key → Untitled.Key — NOT NULL

Untitled (LanguageSupport)

  • Key (LangSupportID) — INTEGER — Primary key — NOT NULL
  • Field (LanguageCode) — VARCHAR(10)
  • Field (TranslatedDiseaseInfo) — VARCHAR(100)
  • Field (TranslatedAdvice) — VARCHAR(100)
  • Key (DiseaseID) — INTEGER — Foreign key → Untitled.Key — NOT NULL
  • Key (FeedbackID) — INTEGER — Foreign key → Untitled.Key — NOT NULL