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)