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