t_site_contract_holder


Columns

Column Type Size Nulls Auto Default Children Parents Comments
legal_entity_name VARCHAR 150 √ null
dba_name VARCHAR 150 √ null
address_line1 VARCHAR 150 √ null
city VARCHAR 50 √ null
state CHAR 2 √ null
zipcode_plus_4 VARCHAR 10 √ null
phone CHAR 25 √ null
fax CHAR 25 √ null
communicate_email VARCHAR 50 √ null
contract_holder_status VARCHAR 50 √ null
contract_type VARCHAR 50 √ null
contract_holder_id VARCHAR 50 √ NULL
t_dma.ID Implied Constraint R
tin INT 10 √ null
sales_code INT 10 √ null
samson_mkt_cd CHAR 10 √ null
watson_code VARCHAR 50 √ null
high_level_channel VARCHAR 50 √ null
division VARCHAR 50 √ null
region VARCHAR 50 √ null
home_market VARCHAR 50 √ null
contact_fst_name VARCHAR 50 √ null
contact_last_name VARCHAR 50 √ null
confidential_email VARCHAR 50 √ NULL
created_on VARCHAR 50 √ NULL

Indexes

Constraint Name Type Sort Column(s)
legal_entity_name Performance Asc legal_entity_name

Relationships

Close relationships within degrees of separation