erd
Tables (4)
orders
- id — BIGINT — Primary key — NOT NULL
- store_id — BIGINT — Foreign key → users.id — NOT NULL
- product_id — BIGINT — Foreign key → products.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
products
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- category — VARCHAR(50) — NOT NULL
- supply_price — DECIMAL(10,2) — NOT NULL
- headquarters_id — BIGINT — Foreign key → users.id — NOT NULL
- order_unit — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
store_inventories
- id — BIGINT — Primary key — NOT NULL
- store_id — BIGINT — Foreign key → users.id — NOT NULL
- product_id — BIGINT — Foreign key → products.id — NOT NULL
- quantity — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- last_order_id — VARCHAR(255)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- role — VARCHAR(30) — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)