spq

Tables (3)

order (Untitled2)

  • id (Key) — UUID — Primary key — NOT NULL
  • name (Field) — VARCHAR(100)
  • address (Field2) — VARCHAR(200)
  • phone_no (Field3) — VARCHAR(20)
  • deleted_at (Field4) — TIMESTAMP

order_line (Untitled3)

  • id (Key) — UUID — Primary key — NOT NULL
  • product_id (Key2) — UUID — Foreign key → product.id — NOT NULL
  • order_id (Key3) — UUID — Foreign key → order.id — NOT NULL
  • qty (Field2) — INT
  • unit_price (Field3) — INT
  • deleted_at (Field) — TIMESTAMP

product (Untitled)

  • id (Key) — UUID — Primary key — NOT NULL
  • name (Field) — VARCHAR(100)
  • unit (Field2) — VARCHAR(20)
  • unit_price (Field3) — INT
  • stock_qty (Field4) — INT
  • deleted_at (Field5) — TIMESTAMP