BJBJ - ERD for posting

Tables (15)

BookLikes

  • Key (book_like_id) — bigInt — Primary key — NOT NULL
  • Key (book_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL

Comment

  • Key (comment_id) — bigInt — Primary key — NOT NULL
  • Field (comment_grp) — int
  • Field (comment_grps) — int
  • Field (comment_grpl) — int
  • Field (comment_content) — varchar(255)
  • Field (created_date) — date
  • Key (paragraph_id) — bigInt — Foreign key → Paragraph.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL

Paragraph

  • Key (paragraph_id) — bigInt — Primary key — NOT NULL
  • Field (paragraph_content) — varchar(255)
  • Field (paragraph_color) — varchar(30)
  • Field (created_date) — date
  • Key (book_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL

Review

  • Key (review_id) — bigInt — Primary key — NOT NULL
  • Field (review_content) — varchar(255)
  • Field (review_grade) — int
  • Field (created_date) — date
  • Key (book_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL

Scrap

  • Key (scrap_id) — bigInt — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
  • Key (paragraph_id) — bigInt — Foreign key → Paragraph.Key — NOT NULL

Untitled (UserImg)

  • Key (img_id) — bigint — Primary key — NOT NULL
  • Field (img_name) — varchar(64)
  • Field (img_path) — text
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL

Untitled (Follow)

  • Key (follow_id) — bigInt — Primary key — NOT NULL
  • Key (followings) — bigint — Foreign key → User.Key — NOT NULL
  • Key (followers) — bigint — Foreign key → User.Key — NOT NULL

Untitled (preferred)

  • Key (preffered_id) — bigint — Primary key — NOT NULL
  • Field (score) — int
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL

Untitled (Hashtag)

  • Key (hashtag_id) — bigint — Primary key — NOT NULL
  • Field (hashtag_name) — text
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL

Untitled (Genre)

  • Key (genre_id) — bigint — Primary key — NOT NULL
  • Field (genre_name) — varchar(16)

Untitled (Author)

  • Key (author_id) — bigint — Primary key — NOT NULL
  • Field (author_name) — varchar(16)
  • Key (book_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (Book)

  • Key (book_id) — bigint — Primary key — NOT NULL
  • Field (book_isbn) — varchar(16)
  • Field (book_title) — varchar(32)
  • Field (book_publisher) — varchar(16)
  • Field (book_price) — integer
  • Field (book_description) — text
  • Field (book_score) — float
  • Field (book_grade) — float

Untitled (BookImg)

  • Key (book_img_id) — bigint — Primary key — NOT NULL
  • Field (book_fimg_name) — varchar(64)
  • Field (book_fimg_path) — text
  • Field (book_bimg_name) — varchar(64)
  • Field (book_bimg_path) — text
  • Field (book_simg_name) — varchar(64)
  • Field (book_simg_path) — text
  • Key (book_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (BookGenre)

  • Key (book_genre_id) — bigint — Primary key — NOT NULL
  • Key (book_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (genre_id) — bigint — Foreign key → Untitled.Key — NOT NULL

User

  • Key (user_id) — bigint — Primary key — NOT NULL
  • Field (created_date) — datetime
  • Field (email) — varchar(64)
  • Field (username) — varchar(32)
  • Field (nickname) — varchar(32)
  • Field (password) — varchar(128)
  • Field (type) — int
  • Field (role) — varchar(32)
  • Field (age) — int
  • Field (sex) — int