book

Tables (6)

Untitled (ratings)

  • Key — Primary key — NOT NULL
  • Key (id) — Foreign key → books.Key — NOT NULL
  • Field
  • Key (id2) — Foreign key → users.Key — NOT NULL

Untitled (replies)

  • Key — Primary key — NOT NULL
  • Key (id) — Foreign key → users.Key — NOT NULL
  • Key (id2) — Foreign key → books.Key — NOT NULL
  • Field
  • Field2

authors

  • Key (id) — Primary key — NOT NULL
  • Field (name)

books

  • Key (id) — Primary key — NOT NULL
  • Field (name)
  • Field (publish_date)

books_authors

  • Key (id) — Primary key — NOT NULL
  • Key (author_id) — Foreign key → authors.Key — NOT NULL
  • Key (books_id) — Foreign key → books.Key — NOT NULL

users

  • Key (id) — Primary key — NOT NULL
  • Field (email)