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 — 상점 시작 날짜