ecomerce

Tables (6)

Coupon (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • count (Field2)
  • expiration_date (Field3)
  • sale_rate (Field4)

Coupon_Issue (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.id — NOT NULL
  • coupon_id (Key3) — Foreign key → Coupon.id — NOT NULL
  • order_id (Key4) — Foreign key → Order.id — NOT NULL
  • status (Field)

Order (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.id — NOT NULL
  • total_price (Field)
  • order_status (Field2)

Order_Product (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • order_id (Key2) — Foreign key → Order.id — NOT NULL
  • product_id (Key3) — Foreign key → Product.id — NOT NULL

Product (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • price (Field2)
  • quantity (Field3)

User (Untitled)

  • id (Key) — Primary key — NOT NULL