tttt
Tables (3)
order_items
- seq — BIGINT — Primary key — NOT NULL
- order_id — BINARY(16) — Foreign key → orders.order_id — NOT NULL
- product_id — BINARY(16) — Foreign key → products.product_id
- category — VARCHAR(50) — NOT NULL
- price — BIGINT — NOT NULL
- quantity — INT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
- INDEX — (order_id)
orders
- order_id — BINARY(16) — Primary key
- email — VARCHAR(50) — NOT NULL
- address — VARCHAR(200) — NOT NULL
- postcode — VARCHAR(200) — NOT NULL
- order_status — VARCHAR(50) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
products
- product_id — BINARY(16) — Primary key
- product_name — VARCHAR(20) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- price — BIGINT — NOT NULL
- description — VARCHAR(500)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)