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)