3team_Book

Tables (5)

Book (Type)

  • PK (book_id) — Not Null — Primary key — NOT NULL
  • FK (author_id) — Not Null — Foreign key → author.PK — NOT NULL
  • Field (title) — NotNull
  • Field (description) — NULL
  • Field (publication_date) — NULL
  • Field (created_at) — NotNull

CustomerUser (Untitled4)

  • PK (id) — NotNuLL
  • Field

Review (Untitled3)

  • PK (review_id) — Not Null — Primary key — NOT NULL
  • FK (user_id) — NotNull — Foreign key → User.PK — NOT NULL
  • FK (book_id) — Not Null — Foreign key → Book.PK — NOT NULL
  • Field (created_at) — NotNull
  • Field (rating) — Null
  • Field (content) — NotNull

User (Untitled2)

  • PK (user_id) — NotNull — Primary key — NOT NULL
  • Field (username) — NotNull
  • Field (email) — NotNull
  • Field (pwd) — NotNull

author (Untitled)

  • PK (author_id) — int — Primary key — NOT NULL
  • field (author_name) — NotNull