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