umc11th-web-study-1th
Tables (8)
book
- book_id — BIGINT — Primary key — NOT NULL — 책ID
- category_id — BIGINT — Foreign key → category.category_id — NOT NULL — 카테고리ID
- title — VARCHAR(200) — NOT NULL — 제목
- description — TEXT — 설명
book_hashtag
- book_hashtag_id — BIGINT — Primary key — NOT NULL — PK
- book_id — BIGINT — Foreign key → book.book_id — NOT NULL — 책ID
- hashtag_id — BIGINT — Foreign key → hashtag.hashtag_id — NOT NULL — 해시태그ID
book_like
- book_like_id — BIGINT — Primary key — NOT NULL — PK
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 사용자ID
- book_id — BIGINT — Foreign key → book.book_id — NOT NULL — 책ID
borrow
- borrow_id — BIGINT — Primary key — NOT NULL — PK
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 사용자ID
- book_id — BIGINT — Foreign key → book.book_id — NOT NULL — 책ID
- borrowed_at — TIMESTAMP — NOT NULL — 대여일
- returned_at — TIMESTAMP — 반납일 (NULL = 대여중)
category
- category_id — BIGINT — Primary key — NOT NULL — 카테고리ID
- name — VARCHAR(30) — NOT NULL — 카테고리명
hashtag
- hashtag_id — BIGINT — Primary key — NOT NULL — 해시태그ID
- title — VARCHAR(30) — NOT NULL — 해시태그명
member
- member_id — BIGINT — Primary key — NOT NULL — 사용자ID
- name — VARCHAR(20) — 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) — 소셜 로그인 제공자가 발급한 사용자 UID
- created_at — TIMESTAMP — NOT NULL — 생성일자
- updated_at — TIMESTAMP — NOT NULL — 수정일자
- deleted_at — TIMESTAMP — 삭제일자 (Soft Delete)
notification_allow_list
- notification_allow_list_id — BIGINT — Primary key — NOT NULL — PK
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 사용자ID
- is_allow_notice — BOOLEAN — NOT NULL — 공지관련 알림 허용여부
- is_allow_book_return — BOOLEAN — NOT NULL — 책반납 시간 임박 알림 허용여부
- is_allow_marketing — BOOLEAN — NOT NULL — 마케팅 알림 허용여부