SKKU's Archive

Tables (5)

Untitled (user)

  • Key (user_id) — int — Primary key — NOT NULL
  • Field (name) — varchar
  • Field (email) — varchar
  • Field (department) — varchar
  • Field (grade) — int
  • Field (number) — varchar

Untitled (book)

  • Key (book_id) — int — Primary key — NOT NULL
  • Field (title) — varchar
  • Field (author) — varchar
  • Field (publication_year) — date
  • Field (publisher) — varchar
  • Field (ISBN) — varchar
  • Field (loan) — enum
  • Field (call number) — varchar
  • Field (reviews) — text
  • Field (description) — text
  • Field (sentiment_nlp) — text
  • Field (topic_nlp) — text
  • Field (sentiment__user) — text
  • Field (topic_user) — text
  • Field (keyword_sentiment) — varchar
  • Field (keyword_topic) — varchar

Untitled (reading_history)

  • Key (history_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (Book_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (reading_date) — date
  • Field (start_time) — time
  • Field (end_tume) — time

Untitled (reading_performance)

  • Key (performance_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (frequency) — int
  • Field (duration) — int
  • Field (style) — varchar
  • Field (recorded_date) — date
  • Field (recommended_books) — JSON

Untitled (Book_User)

  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (book_id) — int — Foreign key → Untitled.Key — NOT NULL