test
Tables (4)
category
- id — BIGINT
- parent_id — BIGINT — Foreign key → category.id
- name — VARCHAR(100) — NOT NULL
- depth — INT — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
order_item
- id — BIGINT
- order_id — BIGINT — Foreign key → orders.id — NOT NULL
- product_id — BIGINT — Foreign key → product.id
- product_name — VARCHAR(255) — NOT NULL
- product_price — DECIMAL(10,2) — NOT NULL
- quantity — INT — NOT NULL
- subtotal — DECIMAL(10,2) — NOT NULL
orders
- id — BIGINT
- idempotency_key — VARCHAR(36)
- status — VARCHAR(20) — NOT NULL
- total_price — DECIMAL(10,2) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
product
- id — BIGINT
- category_id — BIGINT — Foreign key → category.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
- stock — INT — NOT NULL
- reserved_stock — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL