Epilogue

Tables (5)

Untitled (User)

  • Key (user_id) — int — Primary key — NOT NULL
  • Field (id) — varchar
  • Field (password) — varchar
  • Field (name) — varchar
  • Field (contact) — varchar
  • Field (created_at) — date
  • Field (updated_at) — date
  • Field (deleted_at) — date

Untitled (Sale)

  • Key (sale_id) — int — Primary key — NOT NULL
  • Key (book_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (Basket)

  • Key (basket_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (Book)

  • Key (book_id) — int — Primary key — NOT NULL
  • Field (title) — varchar
  • Field (author) — varchar
  • Field (price) — int
  • Field (status) — char
  • Field (description) — varchar
  • Field (is_selling) — bool
  • Field (picture) — varchar
  • Field (created_at) — date
  • Field (updated_at) — date
  • Field (deleted_at) — date

Untitled (Basket_Book)

  • Key (basket_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (book_id) — int — Foreign key → Untitled.Key — NOT NULL