todok-todok
Tables (12)
Book
- Key (book_id) — integer — Primary key — NOT NULL
- Field (title) — char
- Field (genre) — char
- Field (book_image) — image
- Field (author) — char
Notification
- Key (user_id) — integer — Foreign key → User.Key — NOT NULL
- Field (title) — char
- Field (content) — text
- Field (created_at) — datetime
Question
- Key (question_id) — integer — Primary key — NOT NULL
- Key (book_id) — integer — Foreign key → Book.Key — NOT NULL
- Field (content) — text
- Field (disclosure) — boolean
Review
- Key (review_id) — integer — Primary key — NOT NULL
- Key (book_id) — integer — Foreign key → Book.Key — NOT NULL
- Field (title) — char
- Field (content) — text
- Field (storage) — boolean
- Field (category) — integer
- Field (saved_at) — datetime
- Field (like_count) — integer
- Field (scrap_count) — integer
- Field (disclosure) — boolean
Review_Comment
- Key (review_id) — integer — Foreign key → Review.Key — NOT NULL
- Key (book_id) — integer — Foreign key → Review.Key — NOT NULL
- Key (user_id) — integer — Foreign key → User.Key — NOT NULL
- Field (comment) — text
- Field (created_at) — datetime
Review_like
- Key (user_id) — integer — Foreign key → User.Key — NOT NULL
- Key (review_id) — integer — Foreign key → Review.Key — NOT NULL
- Key (book_id) — integer — Foreign key → Review.Key — NOT NULL
- Field (like) — boolean
Review_scrap
- Key (user_id) — integer — Foreign key → User.Key — NOT NULL
- Key (review_id) — integer — Foreign key → Review.Key — NOT NULL
- Key (book_id) — integer — Foreign key → Review.Key — NOT NULL
- Field (scrap) — boolean
Text_Analysis
- Key (review_id) — integer — Foreign key → Review.Key — NOT NULL
- Key (book_id) — integer — Foreign key → Review.Key — NOT NULL
User
- Key (user_id) — integer — Primary key — NOT NULL
- Field (profile_image_url) — char
- Field (email) — char
- Field (password) — char
- Field (nickname) — char
User_Book
- Key (book_id) — integer — Foreign key → Book.Key — NOT NULL
- Key (user_id) — integer — Foreign key → User.Key — NOT NULL
- Field (status) — integer
User_Question
- Key (user_id) — integer — Foreign key → User.Key — NOT NULL
- Key (question_id) — integer — Foreign key → Question.Key — NOT NULL
- Key (book_id) — integer — Foreign key → Question.Key — NOT NULL
- Field (opinion) — text
- Field (like) — boolean
- Field (q_owner) — boolean
User_Review
- Key (user_id) — integer — Foreign key → User.Key — NOT NULL
- Key (review_id) — integer — Foreign key → Review.Key — NOT NULL
- Key (book_id) — integer — Foreign key → Review.Key — NOT NULL