contacts


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
activity_contact.contact_id activity_contact_contact_id_foreign C
activity_statistics.contact_id activity_statistics_contact_id_foreign C
addresses.contact_id addresses_contact_id_foreign C
audit_logs.about_contact_id audit_logs_about_contact_id_foreign N
calls.contact_id calls_contact_id_foreign C
contact_fields.contact_id contact_fields_contact_id_foreign C
contact_photo.contact_id contact_photo_contact_id_foreign C
contact_tag.contact_id contact_tag_contact_id_foreign C
conversations.contact_id conversations_contact_id_foreign C
debts.contact_id debts_contact_id_foreign C
documents.contact_id documents_contact_id_foreign C
emotion_call.contact_id emotion_call_contact_id_foreign C
gifts.contact_id gifts_contact_id_foreign C
gifts.is_for gifts_is_for_foreign N
life_events.contact_id life_events_contact_id_foreign C
messages.contact_id messages_contact_id_foreign C
notes.contact_id notes_contact_id_foreign C
occupations.contact_id occupations_contact_id_foreign C
pets.contact_id pets_contact_id_foreign C
relationships.contact_is relationships_contact_is_foreign C
relationships.of_contact relationships_of_contact_foreign C
reminders.contact_id reminders_contact_id_foreign C
special_dates.contact_id special_dates_contact_id_foreign C
tasks.contact_id tasks_contact_id_foreign C
users.me_contact_id users_me_contact_id_foreign N
account_id INT UNSIGNED 10 null
accounts.id contacts_account_id_foreign C
address_book_id BIGINT UNSIGNED 20 √ null
addressbooks.id contacts_address_book_id_foreign C
first_name VARCHAR 255 null
middle_name VARCHAR 255 √ null
last_name VARCHAR 255 √ null
nickname VARCHAR 255 √ null
gender_id INT 10 √ null
description VARCHAR 255 √ null
uuid CHAR 36 √ null
is_starred BIT 1 0
is_partial BIT 1 0
is_active BIT 1 1
is_dead BIT 1 0
deceased_special_date_id INT UNSIGNED 10 √ null
special_dates.id contacts_deceased_special_date_id_foreign N
deceased_reminder_id INT UNSIGNED 10 √ null
reminders.id contacts_deceased_reminder_id_foreign N
last_talked_to DATE 10 √ null
stay_in_touch_frequency INT 10 √ null
stay_in_touch_trigger_date DATETIME 19 √ null
birthday_special_date_id INT UNSIGNED 10 √ null
special_dates.id contacts_birthday_special_date_id_foreign N
birthday_reminder_id INT UNSIGNED 10 √ null
reminders.id contacts_birthday_reminder_id_foreign N
first_met_through_contact_id INT 10 √ null
first_met_special_date_id INT UNSIGNED 10 √ null
special_dates.id contacts_first_met_special_date_id_foreign N
first_met_reminder_id INT UNSIGNED 10 √ null
reminders.id contacts_first_met_reminder_id_foreign N
first_met_where VARCHAR 255 √ null
first_met_additional_info LONGTEXT 2147483647 √ null
job VARCHAR 255 √ null
company VARCHAR 255 √ null
food_preferences LONGTEXT 2147483647 √ null
avatar_source VARCHAR 255 default
avatar_gravatar_url VARCHAR 250 √ null
avatar_adorable_uuid CHAR 36 √ null
avatar_adorable_url VARCHAR 250 √ null
avatar_default_url VARCHAR 250 √ null
avatar_photo_id INT UNSIGNED 10 √ null
photos.id contacts_avatar_photo_id_foreign N
has_avatar BIT 1 0
avatar_external_url VARCHAR 400 √ null
avatar_file_name VARCHAR 255 √ null
avatar_location VARCHAR 255 local
gravatar_url VARCHAR 255 √ null
vcard MEDIUMTEXT 16777215 √ null
distant_etag VARCHAR 256 √ null
last_consulted_at TIMESTAMP 19 √ null
number_of_views INT 10 0
deleted_at TIMESTAMP 19 √ null
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null
default_avatar_color VARCHAR 255 null
has_avatar_bool BIT 1 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
contacts_account_id_uuid_index Performance Asc/Asc account_id + uuid
contacts_address_book_id_foreign Performance Asc address_book_id
contacts_avatar_photo_id_foreign Performance Asc avatar_photo_id
contacts_birthday_reminder_id_foreign Performance Asc birthday_reminder_id
contacts_birthday_special_date_id_foreign Performance Asc birthday_special_date_id
contacts_deceased_reminder_id_foreign Performance Asc deceased_reminder_id
contacts_deceased_special_date_id_foreign Performance Asc deceased_special_date_id
contacts_first_met_reminder_id_foreign Performance Asc first_met_reminder_id
contacts_first_met_special_date_id_foreign Performance Asc first_met_special_date_id

Relationships

Close relationships within degrees of separation