KIOSK ADMIN v0.1
Tables (10)
Advertisement
- Index — int — Primary key — NOT NULL
- Title — NVARCHAR(50)
- Content — BLOB
Club (Team)
- Index — int — Primary key — NOT NULL
- SymbolName (Symbol) — NVARCHAR(20)
- Name — NVARCHAR(20) — NOT NULL
- Location — NVARCHAR(50)
- SportIndex — int — Foreign key → Sports.Index — NOT NULL
Company
- Index — int — Primary key — NOT NULL
- Name — NVARCHAR(20)
- Location — NVARCHAR(50)
CreditCard
- Index — int — Primary key — NOT NULL
- Amount — int — NOT NULL
- AuthSeqNum — NVARCHAR(20)
- ApprovalNumber — NVARCHAR(20) — NOT NULL
- PaymentType — NVARCHAR(20) — NOT NULL
- Date — DATE
- MachineIndex (KioskIndex) — int — Foreign key → Machine.Index — NOT NULL
Machine (Kiosk)
- Index — int — Primary key — NOT NULL
- CompanyIndex — int — Foreign key → Company.Index — NOT NULL
- ClubIndex (TeamIndex) — int — Foreign key → Club.Index — NOT NULL
- MachineName — NVARCHAR(20)
- SalesPrice — NUMERIC
- Location — NVARCHAR(50)
MachineAdMapper (KioskAdMapper)
- Index — int — Primary key — NOT NULL
- MachineIndex — int — Foreign key → Machine.Index — NOT NULL
- AdvertisementIndex — int — Foreign key → Advertisement.Index — NOT NULL
Manager
- Index — int — Primary key — NOT NULL
- CompanyIndex — int — Primary key — NOT NULL
- Name — NVARCHAR(20)
- Email — NVARCHAR(20)
- PhoneNumber — NVARCHAR(20)
Payco
- Index — int — Primary key — NOT NULL
- RegistrationNumber — NVARCHAR(50) — NOT NULL
- VanPosTid — NVARCHAR(50) — NOT NULL
- PosTid — NVARCHAR(50) — NOT NULL
- PinCode — NVARCHAR(50) — NOT NULL
- PosReferenceKey — NVARCHAR(50) — NOT NULL
- TotalAmount — NVARCHAR(50) — NOT NULL
- TradeNo — NVARCHAR(50) — NOT NULL
- TradeDateTime — NVARCHAR(50) — NOT NULL
- ApprovalNo — NVARCHAR(50) — NOT NULL
- TradeRequestNo — NVARCHAR(50) — NOT NULL
- ApprovalDateTime — NVARCHAR(50) — NOT NULL
- APIKey — NVARCHAR(100) — NOT NULL
- MachineIndex (KioskIndex) — int — Foreign key → Machine.Index — NOT NULL
PurchaseHistory
- Index — int — Primary key — NOT NULL
- MachineIndex — int — Foreign key → Machine.Index — NOT NULL
- ManagerIndex — int — Foreign key → Manager.Index — NOT NULL
- CompanyIndex — int — Foreign key → Manager.CompanyIndex — NOT NULL
- CreditCardIndex — int — Foreign key → CreditCard.Index
- PaycoIndex — int — Foreign key → Payco.Index
- Amount — int
- PhotoAuthNumber — NVARCHAR(20)
- PurchaseAuthNumber — int
- TradeNumber — int
- UniqueNumber — int
- TradeDateTime — DATE
- RefundDateTime — DATE
- IsRefunded — TINYINT(1)
Sports
- Index — int — Primary key — NOT NULL
- CategoryName — NVARCHAR(20)