Pos_cooking

pos order cooking noti

Tables (7)

Equipment (equipment)

  • Key (idx) — int — Primary key — NOT NULL — auto increment index
  • Field (rtm) — timestamp(3) — NOT NULL — kiosk 주문 기기 생성 날짜

Event_order (event_order)

  • Key (idx) — int — Primary key — NOT NULL — auto increment index
  • Key (date) — Date — Foreign key → Order.Key — NOT NULL — 날짜
  • Field (ono) — int — Foreign key → Order.Field — NOT NULL — order no
  • Field (sts) — varchar(100) — NOT NULL — order status
  • Field (tm) — timestamp(3) — NOT NULL — event time

Event_transaction (event_transaction)

  • Key (idx) — int — Primary key — NOT NULL — auto incremental index
  • Key (eidx) — int — Foreign key → Equipment.Key — NOT NULL — kiosk idx
  • Field (tm) — timestamp(3) — NOT NULL — event time / index
  • Field (price) — int — credit price
  • Field (cno) — int — 승인번호
  • Field (ctm) — Date — 승인날짜
  • Field (cpn) — varchar(100) — 카드회사
  • Field (ttype) — varchar(100) — transaction type ; credit, cancel, fail
  • Field (cmt) — text — comments

Order (order)

  • Key (date) — Date — Primary key — NOT NULL — 날짜
  • Field (ono) — int — Primary key — NOT NULL — order no
  • Key (eidx) — int — Foreign key → Equipment.Key — NOT NULL — kiosk idx
  • Field (tprc) — int — NOT NULL — total price

Order_detail (order_detail)

  • Key (idx) — int — Primary key — NOT NULL — auto incremental index
  • Key (date) — Date — Foreign key → Order.Key — NOT NULL — 날짜
  • Field (ono) — int — Foreign key → Order.Field — NOT NULL — order no
  • Key (eidx) — int — Foreign key → Order.Key — NOT NULL — kiosk idx
  • idx (pidx) — int — Foreign key → Product.idx — NOT NULL — product idx
  • Field (cnt) — int — NOT NULL — product count

Product (product)

  • idx — int — Primary key — NOT NULL — auto incremental index(id)
  • Field (name) — varchar(100) — NOT NULL — unique
  • Field2 (price) — int — NOT NULL
  • Field3 (rtm) — timestamp(3) — registration time
  • Field (mtm) — timestamp(3) — modification time
  • Field (ctg) — varchar(100) — NOT NULL — 품목 카테고리 / 외래키 category.ctg
  • Field (sold) — bool — NOT NULL — default : true / 품절 유무

Untitled (category)

  • Key (idx) — int — Primary key — NOT NULL — auto incremental index
  • Field (ctg) — varchar(100)