Person (table: people)

Note that this table contains data about agents as well as users.

Field Name Data Type
can_admin boolean
can_agent boolean
can_billing boolean
can_reports boolean
creation_system string
date_created datetime
date_last_login datetime
date_picture_check datetime
disable_autoresponses boolean
first_name string
gravatar_url string
id number
importance number
is_agent boolean
is_agent_confirmed boolean
is_confirmed boolean
is_contact boolean
is_deleted boolean
is_disabled boolean
is_user boolean
is_vacation_mode boolean
language_id number
last_name string
name string
organization_id number
organization_manager boolean
organization_position string
override_display_name string
picture_blob_id number
primary_email_id number
summary string
timezone string
title_prefix string
was_agent boolean
contact_data Person Contact Data
custom_data Custom Data Person
custom_data[#] Custom Data Person(data for person field with ID #)
emails Person Email
labels Label Person
language Language
organization Organization
picture_blob Blob
preferences Person Pref
primary_email Person Email
usersource_assoc Person Usersource Assoc

Person Usersource Assoc (table: person_usersource_assoc)

Field Name Data Type
data string
date_created datetime
id number
identity string
identity_friendly string
person_id number
usersource_id number
person Person
usersource Usersource

Person Email Validating (table: person_emails_validating)

Field Name Data Type
auth string
date_created datetime
email string
id number
person_id number
validating_content string
person Person

Person Contact Data

Field Name Data Type
comment string
contact_type string
field_1 string
field_2 string
field_3 string
field_4 string
field_5 string
field_6 string
field_7 string
field_8 string
field_9 string
field_10 string
id number
person_id number
person Person

Person Email (people_emails)

Field Name Data Type
comment string
date_created datetime
date_validated datetime
email string
email_domain string
id number
is_validated boolean
person_id number
person Person

Person Pref (table: people_prefs)

Field Name Data Type
date_expire datetime
name string
person_id number
value_array string
value_str string
person Person

Published: 16/03/2017

Last updated: 16/03/2017