1
Tables (10)
Documents
- DocumentID — NUMBER — Primary key — NOT NULL
- SourceType — VARCHAR2(100)
- ContentChunk — CLOB
- Keywords — VARCHAR2(255)
- MoodTag — VARCHAR2(100)
- CreatedDate — DATE
Emotions
- EmotionID — NUMBER — Primary key — NOT NULL
- EmotionName — VARCHAR2(100)
Feedback
- FeedbackID — NUMBER — Primary key — NOT NULL
- IsHelpful — CHAR(1)
- FeedbackDate — DATE
- UserID — NUMBER — Foreign key → Users.UserID — NOT NULL
- ResultID — NUMBER — Foreign key → GeneratedResult.ResultID — NOT NULL
GeneratedResult
- ResultID — NUMBER — Primary key — NOT NULL
- GeneratedText — CLOB
- RecommendedGenre — NUMBER
- RecommendedMood — NUMBER
- ReasonText — CLOB
- GeneratedDate — DATE
- SearchID — NUMBER — Foreign key → SearchHistory.SearchID — NOT NULL
- UserID — NUMBER — Foreign key → Users.UserID — NOT NULL
Genres
- GenreID — NUMBER — Primary key — NOT NULL
- GenreName — VARCHAR2(100)
ListeningHistory
- HistoryID — NUMBER — Primary key — NOT NULL
- Platform — VARCHAR2(100)
- TrackName — VARCHAR2(200)
- ArtistName — VARCHAR2(100)
- PlayedDate — DATE
- UserID — NUMBER — Foreign key → Users.UserID — NOT NULL
SearchHistory
- SearchID — NUMBER — Primary key — NOT NULL
- SearchTerm — VARCHAR2(255)
- SearchDate — DATE
- UserID — NUMBER — Foreign key → Users.UserID — NOT NULL
UserEmotions
- UserID — NUMBER — Foreign key → Users.UserID — NOT NULL
- EmotionID — NUMBER — Foreign key → Emotions.EmotionID — NOT NULL
UserGenres
- UserID — NUMBER — Foreign key → Users.UserID — NOT NULL
- GenreID — NUMBER — Foreign key → Genres.GenreID — NOT NULL
Users
- UserID — NUMBER — Primary key — NOT NULL
- Name — VARCHAR2(100)
- Email — VARCHAR2(100)
- Password — VARCHAR2(100)
- RegistrationDate — DATE