|
Data |
|
Description |
Allow |
|||
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
2. TADB SQL table structure overview. |