book

Tables (6)

author (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • book_id (Key2) — Foreign key → book.id — NOT NULL
  • name (Field)
  • country (Field2)
  • created_at (Field3)
  • updated_at (Field4)

book (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • publisher_id (Key2) — Foreign key → publisher.id — NOT NULL
  • name (Field)
  • author (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • category (Field5)
  • author_id (Field6)

publisher (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • created_at (Field2)
  • updated_at (Field3)

review (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • book_id (Key2) — Foreign key → book.id — NOT NULL
  • user_id (Key3) — Foreign key → user.id — NOT NULL
  • title (Field)
  • content (Field2)
  • score (Field3)
  • created_at (Field4)
  • updated_at (Field5)

user (Untitled)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • email (Field2)
  • gender (Field3)
  • created_at (Field4)
  • updated_at (Field5)

user_history (CopyOfUntitled)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.id — NOT NULL
  • name (Field)
  • email (Field2)
  • gender (Field3)
  • created_at (Field4)
  • updated_at (Field5)