| id |
char(36)
|
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
|
|
|
| salutation |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| first_name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| last_name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| title |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| photo |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| department |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| do_not_call |
tinyint(1)
|
|
|
|
| phone_home |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| phone_mobile |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| phone_work |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| phone_other |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| phone_fax |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| lawful_basis |
text
|
utf8mb4_general_ci
|
|
|
| date_reviewed |
date
|
|
|
|
| lawful_basis_source |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| primary_address_street |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| primary_address_city |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| primary_address_state |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| primary_address_postalcode |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| primary_address_country |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| alt_address_street |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| alt_address_city |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| alt_address_state |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| alt_address_postalcode |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| alt_address_country |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| assistant |
varchar(75)
|
utf8mb4_general_ci
|
|
|
| assistant_phone |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| lead_source |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| reports_to_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| birthdate |
date
|
|
|
|
| campaign_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| joomla_account_id |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| portal_account_disabled |
tinyint(1)
|
|
|
|
| portal_user_type |
varchar(100)
|
utf8mb4_general_ci
|
|
|
