Home > Technical > Table Definitions > TRADSTOR
All locations recorded in TRADUNIT (except competition stores) have stores associated with them. A store group will have multiple stores, whereas a single store will have only one, itself. This table contains the stores within a trading unit.
Column |
Type |
Description |
VARCHAR(10) |
The trading unit this store is for. |
|
STRTRADEUNIT |
VARCHAR(10) |
The store which belongs in strTradeGroup. |
VARCHAR(15) |
This can be used to indicate that the group/unit is of a certain
type, for example a Region or a State. This can be used to group
statistics by the statistics type instead of specific stores. |
Primary Key: STRTRADEGROUP + STRTRADEUNIT
Example:
The location QLD has two stores BRIS and GOLDC. These would be set up as :
strTradeGroup |
strTradeUnit |
QLD |
BRIS |
QLD |
GOLDC |
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |