BookLog
Tables (12)
AUTHOR (작가)
- author_id (Key) — Primary key — NOT NULL
- book_id (PK) — Foreign key → BOOK.book_id — NOT NULL
- author_id (FK) — Foreign key → BOOK.author_id — NOT NULL
- genre_id (Key3) — Foreign key → BOOK.genre_id — NOT NULL
- book_id (Key2) — Foreign key → BOOK.book_id — NOT NULL
- tag_id (Key22) — Foreign key → BOOK.tag_id — NOT NULL
- book_id + tag_id (Key32) — Foreign key → BOOK.book_id + tag_id — NOT NULL
- name (Field)
- description (Field2)
BOOK (책)
- book_id (PK) — Primary key — NOT NULL
- author_id (FK) — Primary key — NOT NULL
- genre_id (Key3) — Primary key — NOT NULL
- book_id (Key) — Foreign key → BOOK_TAG.book_id — NOT NULL
- tag_id (Key2) — Foreign key → BOOK_TAG.tag_id — NOT NULL
- book_id + tag_id (Key32) — Foreign key → BOOK_TAG.book_id + tag_id — NOT NULL
- title (Field)
- description (Field2)
- cover_image (Field3)
- published_date (Field4)
BOOKMARK (북마크)
- bookmark_id (Key) — Primary key — NOT NULL
- user_id (Key2) — nullable — Primary key — NOT NULL
- post_id (Key3) — nullable — Primary key — NOT NULL
- user_id (PK) — unique — Foreign key → USER.user_id — NOT NULL
BOOK_TAG (책 태그)
- book_id (Key) — Primary key — NOT NULL
- tag_id (Key2) — Primary key — NOT NULL
- book_id + tag_id (Key3) — Primary key — NOT NULL
COMMENT (댓글)
- comment_id (Key) — Primary key — NOT NULL
- post_id (Key2) — Primary key — NOT NULL
- user_id (Key3) — Primary key — NOT NULL
- user_id (PK) — unique — Foreign key → USER.user_id — NOT NULL
- content (Field)
- created_at (Field2)
GENRE (장르)
- genre_id (Key) — Primary key — NOT NULL
- book_id (PK) — Foreign key → BOOK.book_id — NOT NULL
- author_id (FK) — Foreign key → BOOK.author_id — NOT NULL
- genre_id (Key3) — Foreign key → BOOK.genre_id — NOT NULL
- book_id (Key2) — Foreign key → BOOK.book_id — NOT NULL
- tag_id (Key22) — Foreign key → BOOK.tag_id — NOT NULL
- book_id + tag_id (Key32) — Foreign key → BOOK.book_id + tag_id — NOT NULL
- name (Field)
POST (피드 게시물)
- post_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Primary key — NOT NULL
- user_id (PK) — unique — Foreign key → USER.user_id — NOT NULL
- content (Field)
- created_id (Field2)
READING_LOG (기록)
- log_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Primary key — NOT NULL
- book_id (Key3) — Primary key — NOT NULL
- user_id (PK) — unique — Foreign key → USER.user_id — NOT NULL
- pages_read (Field)
- reading_date (Field2)
TAG (태그)
- tag_id (Key) — Primary key — NOT NULL
- book_id (Key2) — Foreign key → BOOK_TAG.book_id — NOT NULL
- tag_id (Key22) — Foreign key → BOOK_TAG.tag_id — NOT NULL
- book_id + tag_id (Key3) — Foreign key → BOOK_TAG.book_id + tag_id — NOT NULL
- name (Field)
USER (사용자)
- user_id (PK) — unique — Primary key — NOT NULL
- email (Field)
- password (Field2)
- nickname (Field3)
- profile_image (Field4)
- created_at (Field5)
USER_BOOK (사용자 책)
- user_book_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Primary key — NOT NULL
- book_id (Key3) — Primary key — NOT NULL
- user_id (PK) — unique — Foreign key → USER.user_id — NOT NULL
- book_id (PK2) — Foreign key → BOOK.book_id — NOT NULL
- author_id (FK) — Foreign key → BOOK.author_id — NOT NULL
- genre_id (Key32) — Foreign key → BOOK.genre_id — NOT NULL
- book_id (Key4) — Foreign key → BOOK.book_id — NOT NULL
- tag_id (Key22) — Foreign key → BOOK.tag_id — NOT NULL
- book_id + tag_id (Key322) — Foreign key → BOOK.book_id + tag_id — NOT NULL
- status (Field)
- started_at (Field2)
- finished_at (Field3)
USER_INTEREST (유저 관심)
- user_id (Key) — Primary key — NOT NULL
- author_id (Key2) — nullable — Primary key — NOT NULL
- genre_id (Key3) — nullable — Primary key — NOT NULL
- user_id (PK) — unique — Foreign key → USER.user_id — NOT NULL