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 — 마케팅 알림 허용여부