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