| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| ID |
integer |
10 |
√ |
|
null |
|
|
| ORDERNUM |
varchar |
25 |
√ |
|
null |
|
|
| PONUM |
varchar |
25 |
√ |
|
null |
|
|
| COMPANYNAME |
varchar |
60 |
√ |
|
null |
|
|
| CONTACTNAME |
varchar |
30 |
√ |
|
null |
|
|
| SHIPTOADDRESS |
varchar |
90 |
√ |
|
null |
|
|
| SHIPTOCITY |
varchar |
30 |
√ |
|
null |
|
|
| SHIPTOSTATE |
varchar |
21 |
√ |
|
null |
|
|
| SHIPTOZIP |
varchar |
10 |
√ |
|
null |
|
|
| SHIPTOCOUNTRY |
varchar |
10 |
√ |
|
null |
|
|
| SERVICETYPE |
varchar |
60 |
√ |
|
null |
|
|
| WEIGHT |
double precision |
15 |
√ |
|
null |
|
|
| CARTONID |
integer |
10 |
√ |
|
null |
|
|
| CARTONCOUNT |
integer |
10 |
√ |
|
null |
|
|
| PHONE |
varchar |
64 |
√ |
|
null |
|
|
Analyzed at Mon Jul 01 09:44 PDT 2013
|