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