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)