|
id
|
char(36)
|
|
|
|
|
name
|
varchar(150)
|
|
|
|
|
date_entered
|
datetime
|
|
|
|
|
date_modified
|
datetime
|
|
|
|
|
modified_user_id
|
char(36)
|
|
|
|
|
created_by
|
char(36)
|
|
|
|
|
description
|
text
|
|
|
|
|
deleted
|
tinyint(1)
|
|
|
0
|
|
assigned_user_id
|
char(36)
|
|
|
|
|
account_type
|
varchar(50)
|
|
|
|
|
industry
|
varchar(50)
|
|
|
|
|
annual_revenue
|
varchar(100)
|
|
|
|
|
phone_fax
|
varchar(100)
|
|
|
|
|
billing_address_street
|
varchar(150)
|
|
|
|
|
billing_address_city
|
varchar(100)
|
|
|
|
|
billing_address_state
|
varchar(100)
|
|
|
|
|
billing_address_postalcode
|
varchar(20)
|
|
|
|
|
billing_address_country
|
varchar(255)
|
|
|
|
|
rating
|
varchar(100)
|
|
|
|
|
phone_office
|
varchar(100)
|
|
|
|
|
phone_alternate
|
varchar(100)
|
|
|
|
|
website
|
varchar(255)
|
|
|
|
|
ownership
|
varchar(100)
|
|
|
|
|
employees
|
varchar(10)
|
|
|
|
|
ticker_symbol
|
varchar(10)
|
|
|
|
|
shipping_address_street
|
varchar(150)
|
|
|
|
|
shipping_address_city
|
varchar(100)
|
|
|
|
|
shipping_address_state
|
varchar(100)
|
|
|
|
|
shipping_address_postalcode
|
varchar(20)
|
|
|
|
|
shipping_address_country
|
varchar(255)
|
|
|
|
|
parent_id
|
char(36)
|
|
|
|
|
sic_code
|
varchar(10)
|
|
|
|
|
campaign_id
|
char(36)
|
|
|
|