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

More information

2. TADB SQL table structure overview.