id |
char |
36 |
|
|
|
|
|
name |
varchar |
150 |
√ |
|
null |
|
|
date_entered |
datetime |
19 |
√ |
|
null |
|
|
date_modified |
datetime |
19 |
√ |
|
null |
|
|
modified_user_id |
char |
36 |
√ |
|
null |
|
users.id
|
Defined in XML R |
|
created_by |
char |
36 |
√ |
|
null |
|
users.id
|
Defined in XML R |
|
description |
text |
65535 |
√ |
|
null |
|
|
deleted |
bit |
1 |
√ |
|
0 |
|
|
facebook |
varchar |
100 |
√ |
|
null |
|
|
twitter |
varchar |
100 |
√ |
|
null |
|
|
googleplus |
varchar |
100 |
√ |
|
null |
|
|
account_type |
varchar |
50 |
√ |
|
null |
|
|
industry |
varchar |
50 |
√ |
|
null |
|
|
annual_revenue |
varchar |
100 |
√ |
|
null |
|
|
phone_fax |
varchar |
100 |
√ |
|
null |
|
|
billing_address_street |
varchar |
150 |
√ |
|
null |
|
|
billing_address_city |
varchar |
100 |
√ |
|
null |
|
|
billing_address_state |
varchar |
100 |
√ |
|
null |
|
|
billing_address_postalcode |
varchar |
20 |
√ |
|
null |
|
|
billing_address_country |
varchar |
255 |
√ |
|
null |
|
|
rating |
varchar |
100 |
√ |
|
null |
|
|
phone_office |
varchar |
100 |
√ |
|
null |
|
|
phone_alternate |
varchar |
100 |
√ |
|
null |
|
|
website |
varchar |
255 |
√ |
|
null |
|
|
ownership |
varchar |
100 |
√ |
|
null |
|
|
employees |
varchar |
10 |
√ |
|
null |
|
|
ticker_symbol |
varchar |
10 |
√ |
|
null |
|
|
shipping_address_street |
varchar |
150 |
√ |
|
null |
|
|
shipping_address_city |
varchar |
100 |
√ |
|
null |
|
|
shipping_address_state |
varchar |
100 |
√ |
|
null |
|
|
shipping_address_postalcode |
varchar |
20 |
√ |
|
null |
|
|
shipping_address_country |
varchar |
255 |
√ |
|
null |
|
|
parent_id |
char |
36 |
√ |
|
null |
|
|
sic_code |
varchar |
10 |
√ |
|
null |
|
|
duns_num |
varchar |
15 |
√ |
|
null |
|
|
campaign_id |
char |
36 |
√ |
|
null |
|
|
assigned_user_id |
char |
36 |
√ |
|
null |
|
users.id
|
Defined in XML R |
|
team_id |
char |
36 |
√ |
|
null |
|
teams.id
|
Defined in XML R |
|
team_set_id |
char |
36 |
√ |
|
null |
|
|
acl_team_set_id |
char |
36 |
√ |
|
null |
|
|