C. TrkAttributes Table
Column | Data Type | Length | Description | Allow Nulls | |||
P | fItems | bigint | 8 | Foreign Key to Item; Item is found in the Items table. | |||
P | name | varchar | 32 | Attribute name. | |||
P | class | int | 4 | Attribute class. | |||
0 | Extended | ||||||
1 | Standard | ||||||
2 | Hold | ||||||
[value] | sql_variant | Attribute value. | |||||
pos | tinyint | 1 | Attribute's position in the Standard Attribute array. | ||||
1-20 | Standard Attributes | ||||||
0 | Extended and Holds | ||||||
[$timeStamp] | datetime | 8 | Date and time of last modification (Internal) |
P = Primary key