B4 After

Tables (4)

Book (Untitled3)

  • id (book_id) — int — Primary key — NOT NULL
  • title (Field)

Profile (Untitled2)

  • id (profile_id) — int — Primary key — NOT NULL
  • id (user_id) — int — Foreign key → User.id — NOT NULL
  • user (username) — one to one
  • bio — text
  • image — image
  • favorite — many to many

Review (Untitled4)

  • id (review_id) — int — Primary key — NOT NULL
  • id (book_id) — int — Foreign key → Book.id — NOT NULL
  • id (user_id) — int — Foreign key → User.id — NOT NULL
  • Field
  • Field2

User (Untitled)

  • id (user_id) — int — Primary key — NOT NULL
  • username — varchar
  • password — varchar
  • nickname — varchar