| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| ID |
integer |
10 |
|
|
|
|
|
| DESCRIPTION |
varchar |
256 |
|
|
|
|
|
| BOMID |
integer |
10 |
|
|
|
|
|
| TYPEID |
integer |
10 |
|
|
|
|
|
| PARTID |
integer |
10 |
√ |
|
null |
|
|
| QUANTITY |
double precision |
15 |
|
|
1 |
|
|
| UOMID |
integer |
10 |
√ |
|
null |
|
|
| PRICEADJUSTMENT |
double precision |
15 |
√ |
|
0 |
|
|
| ONETIMEITEM |
smallint |
5 |
√ |
|
0 |
|
|
| STAGE |
smallint |
5 |
√ |
|
0 |
|
|
| STAGEBOMID |
integer |
10 |
√ |
|
null |
|
|
| ADDTOSERVICE |
smallint |
5 |
√ |
|
0 |
|
|
| PRODUCTID |
integer |
10 |
√ |
|
null |
|
|
| SORTIDCONFIG |
integer |
10 |
|
|
1 |
|
|
| INSTRUCTIONURL |
varchar |
256 |
|
|
|
|
|
| INSTRUCTIONNOTE |
blob sub_type 1 |
0 |
√ |
|
null |
|
|
| SORTIDINSTRUCT |
integer |
10 |
|
|
1 |
|
|
| VARIABLEQTY |
smallint |
5 |
√ |
|
0 |
|
|
| MINQTY |
double precision |
15 |
√ |
|
null |
|
|
| MAXQTY |
double precision |
15 |
√ |
|
null |
|
|
| GROUPDEFAULT |
smallint |
5 |
√ |
|
1 |
|
|
| BOMITEMGROUPID |
integer |
10 |
√ |
|
null |
|
|
| USEITEMLOCATION |
smallint |
5 |
√ |
|
0 |
|
|
Analyzed at Mon Jul 01 09:44 PDT 2013
|
