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