nexus
Tables (10)
MENU
- idx — INT — Primary key — NOT NULL
- menu_name — VARCHAR(255) — NOT NULL
- price — VARCHAR(255) — NOT NULL
- img_path — VARCHAR(255) — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
MENU_ITEM
- idx — INT — Primary key — NOT NULL
- quantity — INT — NOT NULL
- menu_unit — VARCHAR(5) — NOT NULL
- menu_idx — INT — Foreign key → MENU.idx — NOT NULL
- product_idx — INT — Foreign key → PRODUCT.idx — NOT NULL
ORDER
- idx — INT — Primary key — NOT NULL
- price — INT — NOT NULL
- order_type — ENUM('AUTO', 'MANUAL') — NOT NULL
- status — ENUM('REJECT', 'WAITING', 'APPROVE') — NOT NULL
- is_danger — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- store_idx — INT — Foreign key → STORE.idx — NOT NULL
ORDER_ITEM
- idx — INT — Primary key — NOT NULL
- count — INT — NOT NULL
- product_idx — INT — Foreign key → PRODUCT.idx — NOT NULL
- order_idx — INT — Foreign key → ORDER.idx — NOT NULL
POS_ORDER_ITEM
- idx — INT — Primary key — NOT NULL
- quantity — INT — NOT NULL
- menu_idx — INT — Foreign key → MENU.idx — NOT NULL
- pos_pay_idx — INT — Foreign key → POS_PAY.idx — NOT NULL
POS_PAY
- idx — INT — Primary key — NOT NULL
- method — ENUM('CARD', 'CASH') — NOT NULL
- created_at — DATETIME — NOT NULL
- store_idx — INT — Foreign key → STORE.idx — NOT NULL
POS_STORE_INVENTORY
- idx — INT — Primary key — NOT NULL
- count — INT — NOT NULL
- status — ENUM('NORMAL', 'CRITICAL', 'LOW') — NOT NULL
- manufactured_date — DATE — NOT NULL
- store_idx — INT — Foreign key → STORE.idx — NOT NULL
- product_idx — INT — Foreign key → PRODUCT.idx — NOT NULL
PRODUCT
- idx — INT — Primary key — NOT NULL
- product_name — VARCHAR(255) — NOT NULL
- product_unit — VARCHAR(10) — NOT NULL
- max_stock — INT — NOT NULL
- min_stock — INT — NOT NULL
- unit_price — INT — NOT NULL
- danger_days — INT — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
STORE
- idx — INT — Primary key — NOT NULL
- store_name — VARCHAR(255) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(255) — NOT NULL
- business — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- closed_at — DATE
- is_deleted — BOOLEAN — NOT NULL
STORE_INVENTORY
- idx — INT — Primary key — NOT NULL
- count — INT — NOT NULL
- status — ENUM('NORMAL', 'CRITICAL', 'LOW') — NOT NULL
- manufactured_date — DATE — NOT NULL
- store_idx — INT — Foreign key → STORE.idx — NOT NULL
- product_idx — INT — Foreign key → PRODUCT.idx — NOT NULL