ShowCase

Tables (6)

TB_BUY_LIST_INFO

  • ID — Primary key
  • barcode — TEXT
  • cnt — TEXT
  • amount — TEXT

TB_CUR_PROD_INFO

  • barcode (Key) — TEXT — Primary key — NOT NULL
  • cnt (Field) — TEXT

TB_EVENT_LIST_INFO

  • Key — Primary key — NOT NULL

TB_PAYMENT_LIST_INFO_NEW (Untitled)

  • ID (Key) — INTEGER — Primary key — NOT NULL
  • DT (Field) — datetime
  • amt_card (Field2) — TEXT
  • card_no (Field3) — TEXT
  • card_name (Field4) — TEXT
  • merchant_no (Field5) — TEXT
  • accept_name (Field6) — TEXT
  • card_auth_no (Field7) — TEXT
  • card_auth_date (Field8) — TEXT
  • van_key (Field9) — TEXT
  • is_send_pay (Field10) — TEXT
  • is_send_cancle (Field11) — TEXT

TB_PROD_INFO (Untitled2)

  • barcode (Key) — TEXT — Primary key — NOT NULL
  • name (Field) — TEXT
  • amount (Field2) — TEXT
  • baseinputprice (Field3) — TEXT
  • baseoutputprice (Field4) — TEXT
  • type (Field5) — TEXT

TB_PROD_INOUT_LIST_INFO (Untitled3)

  • DT (Key) — dateTime — Primary key — NOT NULL
  • barcode (Field) — TEXT
  • input (Field2) — TEXT
  • output (Field3) — TEXT
  • inventory (Field4) — TEXT
  • Field5