T-pay

Tables (9)

category (Untitled6)

  • categoryId (Key) — Primary key — NOT NULL
  • name (Field)

customer (Untitled4)

  • customerId (Key) — Primary key — NOT NULL
  • cusPassNo (Field)
  • cusNm (Field2)
  • cusNatn (Field3)

franchisee (Untitled3)

  • franchiseeId (Key) — Primary key — NOT NULL
  • memNm (Field)
  • memNo (Field2) — M
  • bizno (Field3)
  • storeNm (Field4)
  • storeAddr (Field5)
  • selNm (Field6)
  • storeTel (Field7)
  • categoryName (Field8)
  • balance (Field9)

point (Untitled5)

  • pointId (Key) — Primary key — NOT NULL
  • status (Field)
  • balance (Field2)
  • change (Field3)
  • type (Field4)
  • franchiseeId (Key2) — Foreign key → franchisee.franchiseeId — NOT NULL

product (Untitled2)

  • productId (Key) — Primary key — NOT NULL
  • prdNm (Field)
  • lenNo (Field2) — M
  • prdCode (Field3) — M
  • indPrice (Field5)

product_category (Untitled9)

  • product_categoryId (Key) — Primary key — NOT NULL
  • categoryId (Key2) — Foreign key → category.categoryId — NOT NULL
  • productId (Key3) — Foreign key → product.productId — NOT NULL

refund (Untitled)

  • refundId (Key) — Primary key — NOT NULL
  • tkOutConfNo (Field3) — R
  • totRefund (Field5)
  • refundStatus (Field16)
  • saleId (Key2) — Foreign key → sale.saleId — NOT NULL

sale (Untitled8)

  • saleId (Key) — Primary key — NOT NULL
  • saleDate (Field2)
  • totVat (Field3)
  • totAmt (Field)
  • totQty (Field4)
  • purchsSn (Field5) — M
  • customerId (Key2) — Foreign key → customer.customerId — NOT NULL
  • franchiseeId (Key3) — Foreign key → franchisee.franchiseeId — NOT NULL

saleLine (Untitled7)

  • saleLineId (Key) — Primary key — NOT NULL
  • indQty (Field)
  • salePrice (Field2)
  • indVat (Field3)
  • productId (Key2) — Foreign key → product.productId — NOT NULL
  • saleId (Key3) — Foreign key → sale.saleId — NOT NULL