.....
Tables (6)
ChatHistory
- ChatID — INT — Primary key — NOT NULL
- UserID — INT — NOT NULL
- ChatContent — TEXT — NOT NULL
- ChatDate — DATETIME — NOT NULL
- UserID (UserID2) — INT — Foreign key → Users.UserID — NOT NULL
EmotionAnalysis
- AnalysisID — INT — Primary key — NOT NULL
- UserID — INT — NOT NULL
- EmotionType — VARCHAR(50) — NOT NULL
- AnalysisData — TEXT — NOT NULL
- AnalysisDate — DATETIME — NOT NULL
- RecommendationResult — TEXT
- UserID (UserID2) — INT — Foreign key → Users.UserID — NOT NULL
LiveData
- DataID — INT — Primary key — NOT NULL
- LocationID — INT — NOT NULL
- DataType — VARCHAR(50) — NOT NULL
- UpdateTime — DATETIME — NOT NULL
- DataContent — TEXT — NOT NULL
TravelTrends
- TrendID — INT — Primary key — NOT NULL
- TrendType — VARCHAR(50) — NOT NULL
- TrendContent — TEXT — NOT NULL
- OccurrenceDate — DATETIME — NOT NULL
- DataSource — VARCHAR(255) — NOT NULL
UserTravelHistory
- RecordID — INT — Primary key — NOT NULL
- UserID — INT — NOT NULL
- TravelScheduleID — INT — NOT NULL
- VisitedPlace — VARCHAR(255) — NOT NULL
- VisitDate — DATETIME — NOT NULL
- RecommendedSchedule — TEXT
- Feedback — TEXT
- UserID (UserID2) — INT — Foreign key → Users.UserID — NOT NULL
Users
- UserID — INT — Primary key — NOT NULL
- Name — VARCHAR(255) — NOT NULL
- Email — VARCHAR(255) — NOT NULL
- Password — VARCHAR(255) — NOT NULL
- RegistrationDate — DATETIME — NOT NULL
- ProfilePicture — VARCHAR(255)