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)