Book

Tables (9)

Board (게시판)

  • board_id (Key) — Primary key — NOT NULL
  • type (Field)
  • title (Field4)
  • content (Field2)
  • image (Field5)
  • like (Field6)
  • created_at (Field7)
  • updated_at (Field3)
  • ISBN (Key2) — Foreign key → Book.ISBN — NOT NULL
  • user_id (Key3) — Foreign key → User.user_id — NOT NULL

BoardReaction (게시글 반응)

  • user_id (Key) — Foreign key → User.user_id — NOT NULL
  • board_id (Key2) — Foreign key → Board.board_id — NOT NULL
  • reaction_type (Field)
  • created_at (Field3)
  • updated_at (Field2)

Board_comment (게시판 댓글)

  • board_cid (Key2) — Primary key — NOT NULL
  • board_id (Key) — Foreign key → Board.board_id — NOT NULL
  • user_id (Key3) — Foreign key → User.user_id — NOT NULL
  • content (Field)
  • like_count (Field3)
  • hate_count (Field4)
  • created_at (Field2)
  • updated_at (Field5)

Board_comment_reaction (게시글 댓글 반응)

  • user_id (Key) — Foreign key → User.user_id — NOT NULL
  • board_cid (Key22) — Foreign key → Board_comment.board_cid — NOT NULL
  • reaction_type (Field)

Book (외부API)

  • ISBN (Key) — Primary key — NOT NULL

Book_Comment (책 한줄평)

  • book_cid (Key) — Primary key — NOT NULL
  • ISBN (Key2) — Foreign key → Book.ISBN — NOT NULL
  • user_id (Key3) — Foreign key → User.user_id — NOT NULL
  • content (Field)
  • rate (Field2)
  • created_at (Field3)
  • updated_at (Field4)

History (유저 독서 기록)

  • HistoryID (Key) — Primary key — NOT NULL
  • ISBN (Key2) — Foreign key → Book.ISBN — NOT NULL
  • user_id (Key3) — Foreign key → User.user_id — NOT NULL
  • start_date (Field)
  • end_date (Field2)
  • status (Field3)
  • memo (Field4)
  • created_at (Field5)
  • updated_at (Field6)

Refersh_token (리프레시 토큰)

  • token_id (Key2) — Primary key — NOT NULL
  • user_id (Key) — Foreign key → User.user_id — NOT NULL
  • token (Field)
  • expire_date (Field2)

User (사용자)

  • user_id (Key) — Primary key — NOT NULL
  • nickname (Field)
  • email (Field2)
  • password (Field4)
  • profile_image (Field5)
  • created_at (Field3)
  • bio (Field6)
  • read_history_visible (Field7)