e-commerce

Tables (8)

Categories (Untitled2)

  • category_id (Key) — String — Primary key — NOT NULL
  • name (Field) — NOT NULL
  • image (Field6)

Order (Untitled3)

  • order_id (session_id) — String — Primary key — NOT NULL
  • user_id — String — Foreign key → User.user_id — NOT NULL
  • ammount (Field) — String — NOT NULL
  • shipping_address (Field2) — NOT NULL
  • shipping_postal_code (Field5) — NOT NULL
  • order_status (Field4) — NOT NULL
  • order_address (Field3)
  • order_date (Field6) — NOT NULL

Orderdetails (Untitled6)

  • detail_id (Key) — String — Primary key — NOT NULL
  • order_id (session_id) — String — Foreign key → Order.order_id — NOT NULL
  • product_id (Field3) — String — Foreign key → product.product_id — NOT NULL
  • price (Field) — String — NOT NULL
  • quantity (Field2) — String — NOT NULL

User (Untitled)

  • user_id — String — Primary key — NOT NULL
  • username — NOT NULL
  • password (id) — NOT NULL
  • first_name — NOT NULL
  • last_name — NOT NULL
  • phone — NOT NULL
  • createdat — NOT NULL
  • modifiedat
  • auth (Field) — NOT NULL

options (Untitled1)

  • option_id (method_id) — String — Primary key — NOT NULL
  • option_name (expiration) — NOT NULL

product (Untitled5)

  • product_id (Field) — String — Primary key — NOT NULL
  • name (Field2) — NOT NULL
  • desc (Field3) — NOT NULL
  • price (Field4) — NOT NULL
  • created_at (Field5) — NOT NULL
  • modified_at (Field6) — NOT NULL
  • deleted_at (Field7) — NOT NULL
  • stock (Field8) — String — NOT NULL

product_category (Untitled7)

  • pc_id (Key) — String — Primary key — NOT NULL
  • product_id (Key2) — String — Foreign key → Categories.category_id — NOT NULL

product_options (Untitled4)

  • po_id (cart_id) — String — Primary key — NOT NULL
  • product_id (Field) — String — Foreign key → product.product_id — NOT NULL
  • option_id (method_id) — String — Foreign key → options.option_id — NOT NULL