ddd
Tables (9)
MENU_ITEM
- idx — INT — Primary key — NOT NULL
- menu_idx — INT — NOT NULL
- product_idx — INT — Foreign key → PRODUCT.idx — NOT NULL
- quantity — INT — NOT NULL
ORDER
- idx — INT — Primary key — NOT NULL
- store_idx — INT — Foreign key → STORE.idx — NOT NULL
- order_type — ENUM('AUTO', 'MANUAL') — NOT NULL
- status — ENUM('REJECT', 'WAITING', 'APPROVE') — NOT NULL
- created_at — DATETIME — NOT NULL
ORDER_ITEM
- idx — INT — Primary key — NOT NULL
- order_idx — INT — Foreign key → ORDER.idx — NOT NULL
- product_idx — INT — Foreign key → PRODUCT.idx — NOT NULL
- count — INT — NOT NULL
POS_ORDER_ITEM
- idx — INT — Primary key — NOT NULL
- pos_pay_idx — INT — Foreign key → POS_PAY.idx — NOT NULL
- menu_idx — INT — NOT NULL
- quantity — INT — NOT NULL
POS_PAY
- idx — INT — Primary key — NOT NULL
- store_idx — INT — Foreign key → STORE.idx — NOT NULL
- created_at — DATETIME — NOT NULL
POS_STORE_INVENTORY
- idx — INT — Primary key — NOT NULL
- store_idx — INT — Foreign key → STORE.idx — NOT NULL
- product_idx — INT — Foreign key → PRODUCT.idx — NOT NULL
- manufactured_date — DATE — NOT NULL
- count — INT — NOT NULL
PRODUCT
- idx — INT — Primary key — NOT NULL
- product_name — VARCHAR(255) — NOT NULL
- min_stock — INT — NOT NULL
STORE
- idx — INT — Primary key — NOT NULL
- store_name — VARCHAR(255) — NOT NULL
STORE_INVENTORY
- idx — INT — Primary key — NOT NULL
- store_idx — INT — Foreign key → STORE.idx — NOT NULL
- product_idx — INT — Foreign key → PRODUCT.idx — NOT NULL
- manufactured_date — DATE — NOT NULL
- count — INT — NOT NULL