패션 AI 플랫폼 기획
테이블 (7)
Feedback
- FeedbackID — INT
- UserID — INT
- ProductID — INT
- Comment — TEXT — EX
- CreatedAt — DATE
GeneratedResult
- ResultID — INT
- SearchID — INT
- GeneratedText — TEXT
- GeneratedImageURL — TEXT
- SourceSummary — TEXT
- GeneratedDate — DATE
Product
- ProductID — INT
- Name — VARCHAR(100)
- Description — TEXT
- Price — DECIMAL(10,2)
- StockQuantity — INT
- Category — VARCHAR(50)
- Brand — VARCHAR(100)
- ImageURL — TEXT
- Season — VARCHAR(20)
- Material — VARCHAR(50)
SearchHistory
- SearchID — INT
- UserID — INT
- SearchTerm — TEXT
- InputImageURL — TEXT
- SearchDate — DATE
StyleExperiment
- ExperimentID — INT
- UserID — INT
- BaseItem — VARCHAR(100)
- ContextA — VARCHAR(50)
- ContextB — VARCHAR(50)
- ImageAURL — TEXT
- ImageBURL — TEXT
- Explanation — TEXT
- CreatedAt — DATE
TrendInsight
- InsightID — INT
- DataType — VARCHAR(50)
- Content — TEXT
- RelatedUserGroup — VARCHAR(50)
- CreatedAt — DATE
User
- UserID — INT
- Name — VARCHAR(100)
- Email — VARCHAR(100)
- Password — VARCHAR(100)
- RegistrationDate — DATE
- Gender — VARCHAR(20)
- BodyType — VARCHAR(50)
- SkinTone — VARCHAR(50)
- StylePreference — TEXT