ecommerce-modular-app
Tables (6)
Category (Untitled3)
- category_id (Key) — Primary key — NOT NULL
- name (Field)
Member (Untitled)
- member_id (Key) — Long — Primary key — NOT NULL
- email (Field) — String
Order (Untitled4)
- order_id (Key) — Primary key — NOT NULL
- member_id (Key2) — Long — Foreign key → Member.member_id — NOT NULL
- total_price (Field)
- status (Field2)
OrderITem (Untitled5)
- order_item_id (Key) — Primary key — NOT NULL
- order_id (Key2) — Foreign key → Order.order_id — NOT NULL
- quantity (Field) — int
- product_id (Key3) — Foreign key → Product.product_id — NOT NULL
Product (Untitled2)
- product_id (Key) — Primary key — NOT NULL
- name (Field)
- price (Field2)
- category_id (Key2) — Foreign key → Category.category_id — NOT NULL
Review (Untitled6)
- review_id (Key) — Primary key — NOT NULL
- content (Field)
- rateing (Field2) — int
- member_id (Key2) — Long — Foreign key → Member.member_id — NOT NULL
- product_id (Key3) — Foreign key → Product.product_id — NOT NULL