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