reqwrew

Tables (5)

category (Untitled2)

  • category_id (Key) — Primary key — NOT NULL
  • product__id (Key2) — Foreign key → product.product__id — NOT NULL
  • category_name (Field)

order (Untitled4)

  • order_id (Key) — Primary key — NOT NULL
  • user_id (Field)
  • order_date (Field2)
  • total_price (Field3)
  • order_state (Field4)

orderdetail (Untitled3)

  • orderdetail_id (Key) — Primary key — NOT NULL
  • product__id (Key2) — Foreign key → product.product__id — NOT NULL
  • oredr_id (Field)
  • product_name (Field2)
  • count (Field3)
  • orderdetail_price (Field4)

product (Untitled)

  • product__id (Key) — Primary key — NOT NULL
  • product_name (Field)
  • product_price (Field2)
  • img_path (Field3)
  • category (Field4)

user (CopyOfUntitled)

  • user_id (Key) — Primary key — NOT NULL
  • order_id (Key2) — Foreign key → order.order_id — NOT NULL
  • user_password (Field)
  • user_name (Field2)
  • address (Field3)
  • phone (Field4)
  • telephone (Field5)