BookSystem
Tables (8)
book
- book_id — BIGINT — Primary key — NOT NULL
- title — TEXT — NOT NULL
- description — TEXT — NOT NULL
book_hashtag
- book_hashtag_id — BIGINT — Primary key — NOT NULL
- book_id — BIGINT — Foreign key → book.book_id — NOT NULL
- hashtag_id — BIGINT — Foreign key → hashtag.hashtag_id — NOT NULL
book_like
- book_like_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → users.member_id — NOT NULL
- book_id — BIGINT — Foreign key → book.book_id — NOT NULL
category
- category_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(10) — NOT NULL
- book_id — BIGINT — Foreign key → book.book_id — NOT NULL
hashtag
- hashtag_id — BIGINT — Primary key — NOT NULL
- title — TEXT — NOT NULL
notification_allow_list
- notification_allow_list_id — BIGINT — Primary key — NOT NULL
- is_allow_notice — BOOLEAN — NOT NULL
- is_allow_book_return — BOOLEAN — NOT NULL
- is_allow_marketing — BOOLEAN — NOT NULL
rental (rent)
- rent_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → users.member_id — NOT NULL
- book_id — BIGINT — Foreign key → book.book_id — NOT NULL
users (member)
- member_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(5) — NOT NULL
- nickname — VARCHAR(15) — NOT NULL
- phone_number — VARCHAR(11) — NOT NULL
- gender — ENUM('NONE', 'MALE', 'FEMALE') — NOT NULL
- social_provider — ENUM('LOCAL', 'KAKAO') — NOT NULL
- social_uid — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
- notification_allow_list_id — BIGINT — Foreign key → notification_allow_list.notification_allow_list_id — NOT NULL