book

Tables (7)

book

  • id — bigint — Primary key — NOT NULL — 책 PK
  • book_category_id (id2) — bigint — Foreign key → book_category.id — NOT NULL — 카테고리 PK
  • name (title) — varchar(40) — NOT NULL — 제목
  • description — text — 책 설명
  • created_at — datetime(6) — NOT NULL
  • updated_at (Field) — datetime(6)

book_category (category)

  • id — bigint — Primary key — NOT NULL — 카테고리 PK
  • name — varchar(20) — NOT NULL — 카테고리명
  • created_at (book_count) — datetime(6) — NOT NULL — 카테고리 내 책 수 (집계)
  • updated_at (Field) — datetime(6)

book_hashtag

  • id (Key) — bigint — Primary key — NOT NULL
  • book_id — bigint — Foreign key → book.id — NOT NULL — 책 FK
  • hashtag_id — bigint — Foreign key → hashtag.id — NOT NULL — 해시태그 FK

book_likes (book_like)

  • id — bigint — Primary key — NOT NULL — 좋아요 PK
  • book_id (id2) — bigint — Foreign key → book.id — NOT NULL — 책 PK
  • member_id (id3) — bigint — Foreign key → member.id — NOT NULL — 사용자 PK
  • created_at — datetime(6) — NOT NULL
  • updated_at (Field) — datetime(6)

hashtag

  • id — bigint — Primary key — NOT NULL — 해시태그 PK
  • name — varchar(20) — NOT NULL — 태그명
  • created_at (Field) — datetime(6)
  • updated_at (Field2) — datetime(6)

member (user)

  • id — bigint — Primary key — NOT NULL — 사용자 PK
  • kakao_id — varchar(100) — NOT NULL — 카카오 소셜 ID
  • phone_num (phone) — varchar(15) — NOT NULL — 전화번호
  • name — varchar(10) — NOT NULL — 이름
  • nickname — varchar(20) — NOT NULL — 닉네임
  • gender — varchar(10) — NOT NULL — 성별
  • created_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6) — 탈퇴 일시 (소프트 삭제)
  • status — varchar(15) — NOT NULL — 계정 상태
  • inactive_date (Field) — datetime

rent (rental)

  • id — bigint — Primary key — NOT NULL — 대여 PK
  • book_id (id2) — bigint — Foreign key → book.id — NOT NULL — 책 PK
  • member_id (id3) — bigint — Foreign key → member.id — NOT NULL — 사용자 PK
  • created_at (returned_at) — datetime(6) — 실제 반납일
  • updated_at (status) — datetime(6) — NOT NULL — 대여 상태