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