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