Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
ext_org_id | varchar | 11 | √ | null |
|
|
||
org_location | float8 | 17,17 | √ | null |
|
|
||
effdt | timestamp | 22 | √ | null |
|
|
||
eff_status | varchar | 1 | √ | null |
|
|
||
descr | varchar | 30 | √ | null |
|
|
||
descrshort | varchar | 10 | √ | 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 |
|
|
||
county | varchar | 30 | √ | null |
|
|
||
state | varchar | 6 | √ | null |
|
|
||
postal | varchar | 12 | √ | null |
|
|
||
emailid | varchar | 70 | √ | null |
|
|
Table contained 0 rows