e-commerce

Tables (7)

Cart

  • Key — Primary key — NOT NULL
  • Field

CartItem

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Cart.Key — NOT NULL
  • Field
  • Field2
  • Field3

Category

  • Key — Primary key — NOT NULL
  • Field — NOT NULL

Order

  • Key — Primary key — NOT NULL
  • Field — NOT NULL
  • Field3 — NOT NULL
  • Field4
  • Field5 — NOT NULL

OrderItem

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Order.Key — NOT NULL
  • Field
  • Field2
  • Field3

Products

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Category.Key — NOT NULL
  • Field — NOT NULL
  • Field2 — NOT NULL
  • Field3 — NOT NULL
  • Field4
  • Field5 — NOT NULL
  • Field6

USER (User)

  • Key — binint(20) — Primary key — NOT NULL
  • Field
  • Field2 — NOT NULL
  • Field3
  • Field6
  • Field4 — NOT NULL
  • Field5
  • Field7
  • Field8
  • Field9
  • Field10