Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| PARTTRACKINGID | INT | 10 | √ | 0 |
|
|
|||||
| NAME | VARCHAR | 41 | √ | null |
|
|
|||||
| ABBR | VARCHAR | 10 | √ | null |
|
|
|||||
| DESCRIPTION | VARCHAR | 256 | √ | null |
|
|
|||||
| SORTORDER | INT | 10 | √ | null |
|
|
|||||
| TYPEID | INT | 10 | √ | null |
|
|
|||||
| TAGID | BIGINT | 19 | 0 |
|
|
||||||
| PARTID | INT | 10 | √ | null |
|
|
|||||
| INFO | VARCHAR | 256 | √ | null |
|
|
|||||
| INFOFORMATTED | VARCHAR | 256 | √ | null |
|
|
|||||
| ACTIVEFLAG | BIT | 1 | √ | null |
|
|