Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| shipNumber | VARCHAR | 35 | √ | null |
|
|
|||||
| shipid | INT | 10 | √ | 0 |
|
|
|||||
| sonum | VARCHAR | 25 | null |
|
|
||||||
| soid | INT | 10 | 0 |
|
|
||||||
| customerName | VARCHAR | 41 | √ | null |
|
|
|||||
| shiptoname | VARCHAR | 60 | √ | null |
|
|
|||||
| shiptoaddress1 | VARCHAR | 90 | √ | null |
|
|
|||||
| shiptoaddress2 | VARCHAR | 90 | √ | null |
|
|
|||||
| shiptoaddress3 | VARCHAR | 90 | √ | null |
|
|
|||||
| shiptocity | VARCHAR | 30 | √ | null |
|
|
|||||
| shiptozip | VARCHAR | 10 | √ | null |
|
|
|||||
| statecode | VARCHAR | 21 | √ | null |
|
|
|||||
| countryabbr | VARCHAR | 10 | √ | null |
|
|
|||||
| ResidentialFlag | BIT | 1 | null |
|
|
||||||
| VARCHAR | 256 | √ | null |
|
|
||||||
| phone | VARCHAR | 256 | √ | null |
|
|
|||||
| customerpo | VARCHAR | 25 | √ | null |
|
|
|||||
| carrierservice | VARCHAR | 255 | √ | null |
|
|
|||||
| cartonID | INT | 10 | √ | 0 |
|
|
|||||
| length | DECIMAL | 28,9 | √ | null |
|
|
|||||
| width | DECIMAL | 28,9 | √ | null |
|
|
|||||
| height | DECIMAL | 28,9 | √ | null |
|
|
|||||
| cartonweight | DECIMAL | 28,9 | √ | null |
|
|