Book

Tables (8)

activity

  • id — bigint — Primary key — NOT NULL
  • status_id — bigint — Foreign key → status.status_id — NOT NULL
  • activity_dt — datetime
  • page — int
  • current_page — int
  • activity_type — ENUM
  • created_dt — datetime

book (도서)

  • book_id (도서 고유 아이디) — bigint — Primary key — NOT NULL
  • title — varchar(200)
  • isbn — varchar(50)
  • author — varchar(100)
  • publisher — varchar(100)
  • page — int
  • description — text
  • image_url — varchar(1000)
  • link — varchar(1000)
  • published_date — date
  • created_dt — datetime
  • deleted_dt — datetime

delete_user

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint
  • role — VARCHAR(255)
  • nickname — VARCHAR(255)
  • email — VARCHAR(255)
  • joined_at — VARCHAR(255)
  • created_at — VARCHAR(255)

file

  • id — bigint — Primary key — NOT NULL
  • name — varchar(255)
  • url — varchar(255)
  • size — bigint
  • type — varchar(50)
  • created_dt — datetime
  • updated_dt — datetime

review (리뷰)

  • review_id (리뷰 고유 아이디) — bigint — Primary key — NOT NULL
  • user_id (유저 고유 아이디) — bigint — Foreign key → user.user_id — NOT NULL
  • book_id (도서 고유 아이디) — bigint — Foreign key → book.book_id — NOT NULL
  • rating (평점(별점)) — decimal(2,1)
  • content (내용) — varchar(800)
  • created_dt (등록일시) — datetime
  • updated_dt (수정일시) — datetime
  • deleted_dt (삭제일시) — datetime

status (독서기록)

  • status_id (독서기록 고유 아이디) — bigint — Primary key — NOT NULL
  • user_id (유저 고유 아이디) — bigint — Foreign key → user.user_id — NOT NULL
  • book_id (도서 고유 아이디) — bigint — Foreign key → book.book_id — NOT NULL
  • status (독서 상태) — varchar(20)
  • current_page (현재 페이지 수) — int
  • start_dt (시작일) — date
  • end_dt (종료일) — date
  • created_dt (등록일시) — datetime
  • updated_dt (수정일시) — datetime
  • deleted_dt (삭제일시) — datetime

user (유저)

  • user_id (유저 고유 아이디) — bigint — Primary key — NOT NULL
  • role — varchar(10)
  • nickname — varchar(50)
  • email — varchar(100)
  • social_id — varchar(100)
  • social_type — varchar(10)
  • refresh_token — varchar(255)
  • created_dt — datetime
  • updated_dt — datetime

user_book (사용자 도서)

  • Key — Primary key — NOT NULL
  • Field