accounts


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
activities.account_id activities_account_id_foreign C
activity_contact.account_id activity_contact_account_id_foreign C
activity_statistics.account_id activity_statistics_account_id_foreign C
activity_type_categories.account_id activity_type_categories_account_id_foreign C
activity_types.account_id activity_types_account_id_foreign C
address_contact_field_label.account_id address_contact_field_label_account_id_foreign C
addressbook_subscriptions.account_id addressbook_subscriptions_account_id_foreign C
addressbooks.account_id addressbooks_account_id_foreign C
addresses.account_id addresses_account_id_foreign C
audit_logs.account_id audit_logs_account_id_foreign C
calls.account_id calls_account_id_foreign C
companies.account_id companies_account_id_foreign C
contact_field_contact_field_label.account_id contact_field_contact_field_label_account_id_foreign C
contact_field_labels.account_id contact_field_labels_account_id_foreign C
contact_field_types.account_id contact_field_types_account_id_foreign C
contact_fields.account_id contact_fields_account_id_foreign C
contact_tag.account_id contact_tag_account_id_foreign C
contacts.account_id contacts_account_id_foreign C
conversations.account_id conversations_account_id_foreign C
days.account_id days_account_id_foreign C
debts.account_id debts_account_id_foreign C
documents.account_id documents_account_id_foreign C
emotion_activity.account_id emotion_activity_account_id_foreign C
emotion_call.account_id emotion_call_account_id_foreign C
entries.account_id entries_account_id_foreign C
export_jobs.account_id export_jobs_account_id_foreign C
genders.account_id genders_account_id_foreign C
gifts.account_id gifts_account_id_foreign C
import_job_reports.account_id import_job_reports_account_id_foreign C
import_jobs.account_id import_jobs_account_id_foreign C
invitations.account_id invitations_account_id_foreign C
journal_entries.account_id journal_entries_account_id_foreign C
life_event_categories.account_id life_event_categories_account_id_foreign C
life_event_types.account_id life_event_types_account_id_foreign C
life_events.account_id life_events_account_id_foreign C
messages.account_id messages_account_id_foreign C
metadata_love_relationships.account_id metadata_love_relationships_account_id_foreign C
modules.account_id modules_account_id_foreign C
notes.account_id notes_account_id_foreign C
occupations.account_id occupations_account_id_foreign C
pets.account_id pets_account_id_foreign C
photos.account_id photos_account_id_foreign C
places.account_id places_account_id_foreign C
recovery_codes.account_id recovery_codes_account_id_foreign C
relationship_type_groups.account_id relationship_type_groups_account_id_foreign C
relationship_types.account_id relationship_types_account_id_foreign C
relationships.account_id relationships_account_id_foreign C
reminder_outbox.account_id reminder_outbox_account_id_foreign C
reminder_rules.account_id reminder_rules_account_id_foreign C
reminders.account_id reminders_account_id_foreign C
special_dates.account_id special_dates_account_id_foreign C
synctoken.account_id synctoken_account_id_foreign C
tags.account_id tags_account_id_foreign C
tasks.account_id tasks_account_id_foreign C
term_user.account_id term_user_account_id_foreign C
users.account_id users_account_id_foreign C
weather.account_id weather_account_id_foreign C
uuid CHAR 36 √ null
has_access_to_paid_version_for_free BIT 1 0
api_key VARCHAR 255 null
number_of_invitations_sent INT 10 √ null
default_time_reminder_is_sent VARCHAR 255 12:00
default_gender_id INT UNSIGNED 10 √ null
genders.id accounts_default_gender_id_foreign N
stripe_id VARCHAR 255 √ null
job_batches.id Implied Constraint R
pm_type VARCHAR 255 √ null
pm_last_four VARCHAR 4 √ null
trial_ends_at TIMESTAMP 19 √ null
legacy_free_plan_unlimited_contacts BIT 1 0
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
accounts_default_gender_id_foreign Performance Asc default_gender_id
accounts_stripe_id_index Performance Asc stripe_id
accounts_uuid_index Performance Asc uuid

Relationships

Close relationships within degrees of separation