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