LightNovelReview

Tables (4)

Book (Untitled2)

  • book_id (Key) — int — Primary key — NOT NULL
  • title (Field) — char(50)
  • author (Field2) — char(50)
  • description (Field3) — text
  • published_date (Field4) — datetime
  • user_id (Key2) — int — Foreign key → User.user_id — NOT NULL

Request (Untitled4)

  • request_id (Key) — int — Primary key — NOT NULL
  • requested_at (Field) — datetime
  • status (Field2) — char(20)
  • updated_title (Field3) — text
  • updated_description (Field4) — text
  • updated_published_date (Field5) — text
  • reviewed_at (Field6) — datetime
  • book_id (Key2) — int — Foreign key → Book.book_id — NOT NULL
  • user_id (Key3) — int — Foreign key → User.user_id — NOT NULL

Review (Untitled3)

  • review_id (Key) — int — Primary key — NOT NULL
  • content (Field) — text
  • rating (Field2) — int
  • created_at (Field3) — datetime
  • user_id (Key2) — int — Foreign key → User.user_id — NOT NULL
  • book_id (Key3) — int — Foreign key → Book.book_id — NOT NULL

User (Untitled)

  • user_id (Key) — int — Primary key — NOT NULL
  • username (Field) — char(50)
  • password (Field2) — char(50)
  • email (Field3) — char(100)
  • created_at (Field4) — datetime