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