bookflip

Tables (5)

Follow (follow)

  • ID (Key) — Primary key — NOT NULL
  • follower_id (Key2) — Foreign key → users.user_id — NOT NULL
  • follower_ing (Key3) — Foreign key → users.user_id — NOT NULL
  • is_followed (Field)

book_stats

  • book_stat_id (Key) — Primary key — NOT NULL
  • readersCount (Field)
  • maleCount (Field2)
  • femaleCount (Field3)
  • ratingCount (Field4)
  • ratingSum (Field5)
  • pickCount (인생책)
  • book_id (Key2) — Foreign key → books.book_id — NOT NULL

books

  • book_id (Key) — Primary key — NOT NULL
  • categoryName (Field)
  • readerCount (Field2)
  • isbn13 (Field3)
  • pickCount (인생책)
  • publishedDate (Field5)
  • authors (Field6)
  • title (Field7)

reader

  • ID (Key) — Primary key — NOT NULL
  • gender (Field2)
  • birthDate (Field3)
  • ratingStr (Field4)
  • PickId (Field5)
  • user_id (Key2) — Foreign key → users.user_id — NOT NULL
  • book_id (Key3) — Foreign key → books.book_id — NOT NULL

users (s)

  • user_id (Key) — Primary key — NOT NULL
  • birthDate (Field)
  • lastReaderAt (Field2)
  • bestAuthors (Field3)
  • gender (M/F)
  • followingCount (Field5)
  • followerCount (Field6)
  • readingBlue (Field7)