NookBook

Tables (16)

BaseEntity (Untitled)

  • createdAt (Field)
  • updatedAt (Field2)
  • Status (Field3)

BestSeller (Untitled5)

  • bestseller_id (Key) — Primary key — NOT NULL
  • book_id (Key2) — Foreign key → Book.book_id — NOT NULL
  • rank (Field)

Book (Untitled4)

  • book_id (Key) — Primary key — NOT NULL
  • title (Field)
  • author (Field2)
  • page (Field3)
  • isbn (Field4)
  • published_date (Field5)
  • info (Field6)
  • index (Field7)
  • category (Field8)
  • image (Field9)
  • publisher (Field10)

BookStatus (Untitled15)

  • Before (Field)
  • After (Field2)

Challenge (Untitled8)

  • challenge_id (Key) — Primary key — NOT NULL
  • title (Field)
  • start (Field2)
  • end (Field3)
  • goal (Field5)

Collection (Untitled2)

  • collection_id (Key) — Primary key — NOT NULL
  • user_id (id) — Long — Foreign key → User.user_id — NOT NULL
  • book_id (Key2) — Foreign key → Book.book_id — NOT NULL
  • title (Field)

Library (Untitled3)

  • library_id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → User_Book.id — NOT NULL
  • book_id (Key22) — Foreign key → User_Book.book_id — NOT NULL
  • user_id (id) — Long — Foreign key → User_Book.user_id — NOT NULL

Mate (Untitled11)

  • id (Key) — Primary key — NOT NULL
  • user_id (id) — Long — Foreign key → User.user_id — NOT NULL
  • Mate_Status (Field)
  • mate_id (Field2)

Mate_Status (Untitled12)

  • Send (Field)
  • Complete (Field2)
  • Recieve (Field3)

Note (Untitled6)

  • note_id (Key3) — Primary key — NOT NULL
  • id (Key) — Foreign key → User_Book.id — NOT NULL
  • book_id (Key2) — Foreign key → User_Book.book_id — NOT NULL
  • user_id (id) — Long — Foreign key → User_Book.user_id — NOT NULL
  • content (Field)

Notice (Untitled13)

  • notice_id (Key) — Primary key — NOT NULL
  • user_id (id) — Long — Foreign key → User.user_id — NOT NULL
  • content (Field)

Participant (Untitled14)

  • id (Key) — Primary key — NOT NULL
  • challenge_id (Key2) — Foreign key → Challenge.challenge_id — NOT NULL
  • user_id (id) — Long — Foreign key → User.user_id — NOT NULL
  • User_Status (Field)
  • total_time (Field2)

Timer (Untitled7)

  • timer_id (Key3) — Primary key — NOT NULL
  • id (Key) — Foreign key → User_Book.id — NOT NULL
  • book_id (Key2) — Foreign key → User_Book.book_id — NOT NULL
  • user_id (id) — Long — Foreign key → User_Book.user_id — NOT NULL
  • timestamp (Field)

User (Member)

  • user_id (id) — Long — Primary key — NOT NULL
  • email (Field)
  • password (Field2)
  • nickname_id (Field5)
  • nickname (Field3)
  • login_type (Field4)

User_Book (Untitled9)

  • id (Key) — Primary key — NOT NULL
  • book_id (Key2) — Foreign key → Book.book_id — NOT NULL
  • user_id (id) — Long — Foreign key → User.user_id — NOT NULL
  • Book_Status (Field)

User_Status (Untitled10)

  • In_Progress (Field)
  • Rest (Field2)