Home > Technical > Table Definitions > REWARD
Lists the various rewards available to members.
Column | Type | Description |
INT(4) |
A unique number assigned by the system. |
|
STRDESCRIPTION |
VARCHAR(50) |
A description about the reward. |
STRPRIZE |
VARCHAR(30) |
A description about the prize. |
DTMPROBABILITY |
DECIMAL9(19,4) |
For prizes which are to be assigned randomly, this is the probability that a member has won a reward. |
LINTPOINTS |
INT(4) |
The number of points given to the user as part of this reward. |
LINTMEDIACLIP |
INT(4) |
A media clip can be assigned to a reward. If the reward is won when the user card swipes a boothplayer, the media clip will be played.
|
YSNBIRTHDAY |
VARCHAR(1) |
‘T’ if the reward is to be won when it is a member’s birthday. |
YSNENTRY |
VARCHAR(1) |
‘T’ if a reward is to be won when the user card swipes a boothplayer. |
INTPRIORITY |
INT(4) |
When a reward is to be ‘won’, the system looks through the list of available rewards. The priority allows you to control the order in which rewards will be checked. |
LINTITEMNUMBER |
INT(4) |
The item won as part of the reward. If no item is used for the price, this will be zero. |
YSNNEW |
VARCHAR(1) |
‘T’ if a new reward. |
YSNCHANGED |
VARCHAR(1) |
‘T’ if a changed reward. |
INTREDEEMPOINTS |
INT(4) |
The number of points to be redeemed to win this prize. |
DTMVALIDFROM |
DATETIME(8) |
The reward can only be given after this date (inclusive). |
DTMVALIDTO |
DATETIME(8) |
The reward can only be given before this date (inclusive). |
DTMVALIDFROMTIME |
DATETIME(8) |
The reward can only be given after this time. |
DTMVALIDTOTIME |
DATETIME(8) |
The reward can only be given before this time. |
YSNSUNDAY |
VARCHAR(1) |
If 'T' then the extra points can be given on a Sunday, 'F' otherwise. |
YSNMONDAY |
VARCHAR(1) |
If 'T' then the extra points can be given on a Monday, 'F' otherwise. |
YSNTUESDAY |
VARCHAR(1) |
If 'T' then the extra points can be given on a Tuesday, 'F' otherwise. |
YSNWEDNESDAY |
VARCHAR(1) |
If 'T' then the extra points can be given on a Wednesday, 'F' otherwise. |
YSNTHURSDAY |
VARCHAR(1) |
If 'T' then the extra points can be given on a Thursday, 'F' otherwise. |
YSNFRIDAY |
VARCHAR(1) |
If 'T' then the extra points can be given on a Friday, 'F' otherwise. |
YSNSATURDAY |
VARCHAR(1) |
If 'T' then the extra points can be given on a Saturday, 'F' otherwise. |
YSNMULTIPLESALLOWED |
VARCHAR(1) |
'T' indicates the reward can only be won once by each customer, otherwise 'F'. |
YSNPRINTREWARD |
VARCHAR(1) |
'T' indicates the reward should be printed. This will produce a text file which can be used by DynaPOSPrinter.exe. |
DBLINCREASEPROB |
DECIMAL9(19,4) |
Not currently used. Set to 0. |
INTINCREASEPROBDAYS |
INT(4) |
Not currently used. Set to 0. |
STRCATEGORY1 |
VARCHAR(10) |
Only customers with this category will get this reward. If empty then no check is done. |
STRCATEGORY2 |
VARCHAR(10) |
Only customers with this category will get this reward. If empty then no check is done. |
STRCATEGORY3 |
VARCHAR(10) |
Only customers with this category will get this reward. If empty then no check is done. |
STRCATEGORY4 |
VARCHAR(10) |
Only customers with this category will get this reward. If empty then no check is done. |
STRCATEGORY5 |
VARCHAR(10) |
Only customers with this category will get this reward. If empty then no check is done. |
Primary Key: LINTCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |