KioskAdmin0.2
Tables (11)
Advertisement
- Index — INT
- Name — NVARCHAR(255) — NOT NULL
- StartDate — DATETIME — NOT NULL
- EndDate — DATETIME — NOT NULL
Club
- Index — INT
- Name — NVARCHAR(255) — NOT NULL
Company
- Index — INT
- CompanyName — NVARCHAR(255) — NOT NULL
- Country — NVARCHAR(100) — NOT NULL
CreditCard
- Index — INT
- Amount — INT — NOT NULL
- AuthSeqNum — NVARCHAR(255)
- ApprovalNumber — NVARCHAR(255)
- PaymentType — NVARCHAR(255)
- Date — DATETIME
- IsRefunded — BIT
- MachineIndex — INT — NOT NULL
Machine
- Index — INT
- MachineName — NVARCHAR(255) — NOT NULL
- Location — NVARCHAR(255) — NOT NULL
MachineAdMapper
- MachineIndex — INT — NOT NULL
- AdIndex — INT — NOT NULL
Manager
- Index — INT
- ManagerName — NVARCHAR(255) — NOT NULL
Payco
- Index — INT
- RegistrationNumber — NVARCHAR(255) — NOT NULL
- VanPosTid — NVARCHAR(255) — NOT NULL
- PosTid — NVARCHAR(255) — NOT NULL
- PinCode — NVARCHAR(100) — NOT NULL
- PosReferenceKey — NVARCHAR(255)
- TotalAmount — DECIMAL(18,2) — NOT NULL
- TradeNo — NVARCHAR(255)
- TradeDateTime — DATETIME — NOT NULL
- ApprovalNo — NVARCHAR(255)
- TradeRequestNo — NVARCHAR(255)
- ApprovalDateTime — DATETIME — NOT NULL
- IsRefunded — BIT
- APIKey — NVARCHAR(255) — NOT NULL
PurchaseHistory
- Index — INT
- CreditCardIndex — INT
- PaycoIndex — INT
RefreshToken
- Index — INT
- Token — NVARCHAR(255) — NOT NULL
- ExpiryDate — DATETIME — NOT NULL
Sports
- Index — INT
- SportName — NVARCHAR(255) — NOT NULL