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