Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| emplid | varchar | 11 | √ | null |
|
|
||
| genl_matl_group | varchar | 8 | √ | null |
|
|
||
| genl_matl_type | varchar | 3 | √ | null |
|
|
||
| genl_matl_nbr | float8 | 17,17 | √ | null |
|
|
||
| name | varchar | 50 | √ | null |
|
|
||
| title | varchar | 35 | √ | null |
|
|
||
| descr_ext_org | varchar | 30 | √ | null |
|
|
||
| country | varchar | 3 | √ | null |
|
|
||
| address1 | varchar | 55 | √ | null |
|
|
||
| address2 | varchar | 55 | √ | null |
|
|
||
| address3 | varchar | 55 | √ | null |
|
|
||
| address4 | varchar | 55 | √ | null |
|
|
||
| city | varchar | 30 | √ | null |
|
|
||
| state | varchar | 6 | √ | null |
|
|
||
| postal | varchar | 12 | √ | null |
|
|
||
| country_code | varchar | 3 | √ | null |
|
|
||
| phone | varchar | 24 | √ | null |
|
|
||
| descrlong | text | 2147483647 | √ | null |
|
|
Table contained 0 rows