Snap_cashier
Tables (7)
equipment
- idx — int — Primary key — NOT NULL — auto increment index
- sidx — int — Foreign key → store.idx — NOT NULL — store index / foreign key
- rtm — timestamp(3) — NOT NULL — 기기 설치 날짜
event_registration
- idx — int — Primary key — NOT NULL — auto increament index
- eidx — int — Foreign key → equipment.idx — NOT NULL — eq index / foreing key(equipment.idx)
- sidx — int — Foreign key → equipment.sidx — NOT NULL — store index / foreign key(equipment.sidx)
- pid — varchar(100) — Foreign key → product.pid — NOT NULL — product id / foreign key(product.pid)
- tm — timestamp(3) — NOT NULL — event 발생시간/ index
- type — varchar(100) — NOT NULL — event type / create, update, delete
- cts — text — contents
event_transaction
- idx — int — Primary key — NOT NULL — auto increament index
- eidx — int — Foreign key → equipment.idx — NOT NULL — eq index / foreign key
- sidx — int — Foreign key → equipment.sidx — NOT NULL — store index / foreign key
- tm — timestamp(3) — NOT NULL — event 발생시간/ index
- tcnt — int — tray count
- price — int — credit price
- cno — int — 승인 번호/카드 번호 연결 정보
- type — varchar(100) — credit type / 승인요청, 승인, 승인거절, 에러등
- items — text — item list text
- cmt — text — comments
log_transaction
- idx — int — Primary key — NOT NULL — auto increament index
- tidx — int — NOT NULL — event_transaction index
- tm — timestamp(3) — NOT NULL — event 발생시간/ index
- cts — text — contents
price
- idx — int — Primary key — NOT NULL — auto increment index
- pid — varchar(100) — Foreign key → product.pid — NOT NULL — product id(code) / foreign key(product.pid)
- sidx (sdix) — int — Foreign key → store.idx — NOT NULL — store index / foreign key(store.idx)
- price — int — NOT NULL
- rtm — timestamp(3) — NOT NULL — registration_time
- mtm — timestamp(3) — NOT NULL — modification_time
product
- pid — varchar(100) — Primary key — NOT NULL — product id / unique pk
- aid — varchar(100) — alias id
- name — varchar(100) — NOT NULL — product name
- wt — double — weight
- img — longblob — NOT NULL — 대표 이미지
store
- idx — int — Primary key — NOT NULL — auto increment index
- post — int — NOT NULL — index
- cpn — varchar(100) — NOT NULL — company
- name — varchar(100) — NOT NULL — store name
- ctr — varchar(100) — NOT NULL — country
- state — varchar(100) — NOT NULL — state
- city — varchar(100) — NOT NULL — city
- town — varchar(100) — NOT NULL — town
- loca — varchar(100) — NOT NULL — 나머지 주소
- rtm — timestamp(3) — NOT NULL — 상점 시작 날짜