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