Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| legal_entity_name | VARCHAR | 50 | √ | null |
|
|
||
| dba_name | VARCHAR | 50 | √ | null |
|
|
||
| address_line1 | VARCHAR | 50 | √ | null |
|
|
||
| city | VARCHAR | 30 | √ | null |
|
|
||
| state | CHAR | 2 | √ | null |
|
|
||
| zipcode_plus_4 | VARCHAR | 10 | √ | null |
|
|
||
| phone | CHAR | 10 | √ | null |
|
|
||
| fax | CHAR | 10 | √ | null |
|
|
||
| communicate_email | VARCHAR | 50 | √ | null |
|
|
||
| contract_holder_status | VARCHAR | 20 | √ | null |
|
|
||
| contract_type | VARCHAR | 20 | √ | null |
|
|
||
| contract_holder_id | VARCHAR | 20 | √ | null |
|
|
||
| tin | INT | 10 | √ | null |
|
|
||
| sales_code | INT | 10 | √ | null |
|
|
||
| samson_mkt_cd | CHAR | 3 | √ | null |
|
|
||
| watson_code | VARCHAR | 20 | √ | null |
|
|
||
| high_level_channel | VARCHAR | 20 | √ | null |
|
|
||
| division | VARCHAR | 50 | √ | null |
|
|
||
| region | VARCHAR | 50 | √ | null |
|
|
||
| home_market | VARCHAR | 50 | √ | null |
|
|
||
| contact_fst_name | VARCHAR | 20 | √ | null |
|
|
||
| contact_last_name | VARCHAR | 20 | √ | null |
|
|
||
| confidential_email | VARCHAR | 50 | √ | null |
|
|
||
| created_on | DATETIME | 19 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
