readBuddy

Tables (5)

Diary (diaries)

  • id (Key2) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → User.id — NOT NULL
  • user_book_id (FK2) — bigint — Foreign key → UserBook.id — NOT NULL
  • content (Field) — varchar(500)
  • uploadDate (Field2) — timestamp

HeartBook (heart_books)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → User.id — NOT NULL
  • name (Field) — varchar

ReadAmount (read_amounts)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_book_id (FK) — bigint — Foreign key → UserBook.id — NOT NULL
  • user_id (FK@) — bigint — Foreign key → User.id — NOT NULL
  • total_pages (Field) — int
  • days (Field2) — int

User (users)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar
  • genre (Field2) — varchar

UserBook (user_books)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (FK3) — bigint — Foreign key → User.id — NOT NULL
  • name (Field) — varchar
  • status (Field2) — varchar
  • startDate (Field3) — timestamp
  • finishDate (Field4) — timestamp
  • pages (Field5) — int