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