practice

Tables (4)

order (Untitled3)

  • order_id (Key) — INT — Primary key — NOT NULL
  • user_id (Key2) — INT — Foreign key → user.user_id — NOT NULL
  • user_id (Field) — INT
  • order_date (Field2) — INT
  • total_price (Field3) — INT
  • product_name (Field4) — VARCHAR

order_item (Untitled4)

  • order_item (Key) — VARCHAR — Primary key — NOT NULL
  • order_id (Key2) — INT — Foreign key → order.order_id — NOT NULL
  • user_id (Key22) — INT — Foreign key → order.user_id — NOT NULL
  • product_id (Key3) — INT — Foreign key → product.product_id — NOT NULL
  • quantity (Field) — INT
  • Field2

product (Untitled2)

  • product_id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR
  • price (Field2) — INT
  • stock (Field3) — INT
  • description (Field4) — VARCHAR

user (Untitled)

  • user_id (Key) — INT — Primary key — NOT NULL
  • username (Field) — VARCHAR
  • email (Field2) — VARCHAR
  • password (Field3) — VARCHAR
  • join_at (Field4) — VARCHAR