FrontErd

Tables (4)

Untitled (User)

  • Key (user_id) — BIGINT — Primary key — NOT NULL
  • Field (name) — VARCHAR
  • Field2 (email) — VARCHAR
  • Field3 (password) — VARCHAR

Untitled (Event)

  • Key (events_id) — BIGINT — Primary key — NOT NULL
  • Field (name) — VARCHAR
  • Field
  • Key (item_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (Products)

  • Key (item_id) — BIGINT — Primary key — NOT NULL
  • Field (name) — VARCHAR
  • Field2 (thumbnail) — VARCHAR
  • Field3 (price) — INT
  • Field4 (discount) — INT
  • Field5 (description) — VARCHAR
  • Field6 (category) — VARCHAR
  • Field7 (brand) — VARCHAR
  • Field8 (rating) — DOUBLE

Untitled2 (Carts)

  • Key (carts_id) — BIGINT — Primary key — NOT NULL
  • Field (quantity) — INT
  • Key (item_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL