GSR Backend
Tables (3)
order_detail (Untitled2)
- order_detail_id (Key) — Integer — Primary key — NOT NULL
- order_id (Key2) — Integer — Foreign key → user_order.order_id — NOT NULL
- product_id — Integer — Foreign key → product.product_id — NOT NULL
- quantity (Field) — Integer
- price (Field2) — quantity
product (Untitled3)
- product_id — Integer — Primary key — NOT NULL
- name (Field) — string
- price (Field2) — Integer
- status (Field3) — ENUM
- image_link (Field4) — string
- product_link (Field5) — string
- stock_qty (Field12) — Integer
- purchase_qty (Field13) — Integer
- brand (Field6) — string
- category (Field7) — ENUM
- description (Field8) — string
- rating (Field9) — Integer
- created_at (Field10) — DATE
- updated_at (Field11) — DATE
user_order (Untitled)
- order_id (Key) — Integer — Primary key — NOT NULL
- customerId (Field5) — String
- quantity (Field2) — Integer
- price (Field3) — Integer
- created_at (Field) — DATE
- updated_at (Field4) — DATE