readingbook

Tables (15)

author

  • author_id — bigint — Primary key — NOT NULL
  • created_time — datetime(6)
  • last_edited_time — datetime(6)
  • birth_year — varchar(255)
  • description — varchar(255)
  • name — varchar(255)
  • nationality — varchar(255)
  • author_option — enum('AUTHOR','TRANSLATOR','ILLUSTRATOR')
  • gender — enum('MEN','WOMEN','SECRET')

book

  • book_id — bigint — Primary key — NOT NULL
  • discount_rate — int — NOT NULL
  • ebook_price — int — NOT NULL
  • is_on_sale — bit(1) — NOT NULL
  • paper_price — int — NOT NULL
  • review_count — int — NOT NULL
  • sale_price — int — NOT NULL
  • book_group_id — bigint — Foreign key → book_group.book_group_id
  • category_id — bigint — Foreign key → category.category_id
  • created_time — datetime(6)
  • last_edited_time — datetime(6)
  • description — text
  • isbn — varchar(255)
  • publisher — varchar(255)
  • publishing_date — varchar(255)
  • saved_image_name — varchar(255)
  • title — varchar(255)

book_author_list

  • book_author_list_id — bigint — Primary key — NOT NULL
  • author_id — bigint — Foreign key → author.author_id
  • book_id — bigint — Foreign key → book.book_id
  • created_time — datetime(6)
  • last_edited_time — datetime(6)
  • ordinal — bigint

book_content

  • book_content_id — bigint — Primary key — NOT NULL
  • book_id — bigint — Foreign key → book.book_id
  • created_time — datetime(6)
  • last_edited_time — datetime(6)
  • content — longtext

book_group

  • book_group_id — bigint — Primary key — NOT NULL
  • created_time — datetime(6)
  • last_edited_time — datetime(6)
  • saved_image_name — varchar(255)
  • title — varchar(255)

category

  • category_id — bigint — Primary key — NOT NULL
  • category_group_id — bigint — Foreign key → category_group.category_group_id
  • created_time — datetime(6)
  • last_edited_time — datetime(6)
  • name — varchar(255)

category_group

  • category_group_id — bigint — Primary key — NOT NULL
  • created_time — datetime(6)
  • last_edited_time — datetime(6)
  • name — varchar(255)

library

  • library_id — bigint — Primary key — NOT NULL
  • book_id — bigint — Foreign key → book.book_id
  • created_time — datetime(6)
  • last_edited_time — datetime(6)
  • member_id — bigint — Foreign key → member.member_id

member

  • member_id — bigint — Primary key — NOT NULL
  • created_time — datetime(6)
  • last_edited_time — datetime(6)
  • birth_year — varchar(255)
  • email — varchar(255)
  • name — varchar(255)
  • password — varchar(255)
  • phone_no — varchar(255)
  • gender — enum('MEN','WOMEN','SECRET')
  • role — enum('ROLE_MEMBER','ROLE_VENDOR','ROLE_ADMIN')

order_books

  • order_books_id — bigint — Primary key — NOT NULL
  • book_id — bigint — Foreign key → book.book_id
  • created_time — datetime(6)
  • last_edited_time — datetime(6)
  • orders_id — bigint — Foreign key → orders.orders_id

orders

  • orders_id — bigint — Primary key — NOT NULL
  • discount_amount — int — NOT NULL
  • order_amount — int — NOT NULL
  • payment_amount — int — NOT NULL
  • created_time — datetime(6)
  • last_edited_time — datetime(6)
  • member_id — bigint — Foreign key → member.member_id
  • choosing_option — varchar(255)
  • email — varchar(255)
  • imp_uid — varchar(255)
  • order_name — varchar(255)
  • order_no — varchar(255)

review

  • review_id — bigint — Primary key — NOT NULL
  • comments_count — int — NOT NULL
  • is_hidden — bit(1) — NOT NULL
  • is_purchased — bit(1) — NOT NULL
  • likes_count — int — NOT NULL
  • star_rating — int
  • book_id — bigint — Foreign key → book.book_id
  • created_time — datetime(6)
  • last_edited_time — datetime(6)
  • member_id — bigint — Foreign key → member.member_id
  • content — varchar(255)

review_comment

  • review_comment_id — bigint — Primary key — NOT NULL
  • is_hidden — bit(1) — NOT NULL
  • created_time — datetime(6)
  • last_edited_time — datetime(6)
  • member_id — bigint — Foreign key → member.member_id
  • review_id — bigint — Foreign key → review.review_id
  • content — varchar(255)

review_like_log

  • review_like_log_id — bigint — Primary key — NOT NULL
  • created_time — datetime(6)
  • last_edited_time — datetime(6)
  • member_id — bigint — Foreign key → member.member_id
  • review_id — bigint — Foreign key → review.review_id

wishlist

  • wishlist_id — bigint — Primary key — NOT NULL
  • book_id — bigint — Foreign key → book.book_id
  • created_time — datetime(6)
  • last_edited_time — datetime(6)
  • member_id — bigint — Foreign key → member.member_id