ㅇㅇ
Tables (11)
external_data
- data_id — UUID
- store_id — UUID — Foreign key → stores.store_id — NOT NULL
- date — DATE — NOT NULL
- weather — VARCHAR(100)
- temperature — FLOAT
- is_holiday — BOOLEAN — NOT NULL
- event_name — VARCHAR(100)
ingredients
- ingredient_id — UUID
- store_id — UUID — Foreign key → stores.store_id — NOT NULL
- ingredient_name — VARCHAR(100) — NOT NULL
- current_stock — FLOAT — NOT NULL
- unit — VARCHAR(20)
- min_stock — FLOAT — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
menus
- menu_id — UUID
- store_id — UUID — Foreign key → stores.store_id — NOT NULL
- menu_name — VARCHAR(100) — NOT NULL
- category — VARCHAR(100)
- price — INTEGER — NOT NULL
- channel — VARCHAR(50)
- is_active — BOOLEAN — NOT NULL
order_items
- item_id — UUID
- order_id — UUID — Foreign key → orders.order_id — NOT NULL
- menu_id — UUID — Foreign key → menus.menu_id — NOT NULL
- quantity — INTEGER — NOT NULL
- price — INTEGER — NOT NULL
orders
- order_id — UUID
- store_id — UUID — Foreign key → stores.store_id — NOT NULL
- channel — VARCHAR(50)
- order_date — TIMESTAMP — NOT NULL
- total_amount — INTEGER — NOT NULL
- status — VARCHAR(50) — NOT NULL
pos_connections
- connection_id — UUID
- store_id — UUID — Foreign key → stores.store_id — NOT NULL
- pos_type — VARCHAR(50)
- access_token — VARCHAR(255)
- last_synced_at — TIMESTAMP
- is_active — BOOLEAN — NOT NULL
predictions
- prediction_id — UUID
- store_id — UUID — Foreign key → stores.store_id — NOT NULL
- target_date — DATE — NOT NULL
- menu_id — UUID — Foreign key → menus.menu_id — NOT NULL
- predicted_qty — INTEGER — NOT NULL
- confidence — FLOAT
- model_version — VARCHAR(50)
- created_at — TIMESTAMP — NOT NULL
purchase_orders
- po_id — UUID
- store_id — UUID — Foreign key → stores.store_id — NOT NULL
- ingredient_id — UUID — Foreign key → ingredients.ingredient_id — NOT NULL
- recommended_qty — FLOAT — NOT NULL
- adjusted_qty — FLOAT
- status — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
recipes
- recipe_id — UUID
- menu_id — UUID — Foreign key → menus.menu_id — NOT NULL
- ingredient_id — UUID — Foreign key → ingredients.ingredient_id — NOT NULL
- quantity — FLOAT — NOT NULL
- unit — VARCHAR(20)
stores
- store_id — UUID
- user_id — UUID — Foreign key → users.user_id — NOT NULL
- store_name — VARCHAR(100) — NOT NULL
- business_number — VARCHAR(50)
- address — VARCHAR(255)
- pos_type — VARCHAR(50)
- toss_merchant_id — VARCHAR(100)
- toss_access_token — VARCHAR(255)
- is_verified — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
users
- user_id — UUID
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- role — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP — NOT NULL