144 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| contacts_deceased_reminder_id_foreign |
|
|
Null on delete | ||
| contacts_account_id_foreign |
|
|
Cascade on delete | ||
| contacts_first_met_reminder_id_foreign |
|
|
Null on delete | ||
| contacts_first_met_special_date_id_foreign |
|
|
Null on delete | ||
| contacts_avatar_photo_id_foreign |
|
|
Null on delete | ||
| contacts_address_book_id_foreign |
|
|
Cascade on delete | ||
| contacts_birthday_special_date_id_foreign |
|
|
Null on delete | ||
| contacts_deceased_special_date_id_foreign |
|
|
Null on delete | ||
| contacts_birthday_reminder_id_foreign |
|
|
Null on delete | ||
| life_event_types_account_id_foreign |
|
|
Cascade on delete | ||
| life_event_types_life_event_category_id_foreign |
|
|
Cascade on delete | ||
| reminder_rules_account_id_foreign |
|
|
Cascade on delete | ||
| import_jobs_account_id_foreign |
|
|
Cascade on delete | ||
| import_jobs_user_id_foreign |
|
|
Cascade on delete | ||
| pets_account_id_foreign |
|
|
Cascade on delete | ||
| pets_pet_category_id_foreign |
|
|
Cascade on delete | ||
| pets_contact_id_foreign |
|
|
Cascade on delete | ||
| relationship_type_groups_account_id_foreign |
|
|
Cascade on delete | ||
| term_user_account_id_foreign |
|
|
Cascade on delete | ||
| term_user_term_id_foreign |
|
|
Cascade on delete | ||
| term_user_user_id_foreign |
|
|
Cascade on delete | ||
| modules_account_id_foreign |
|
|
Cascade on delete | ||
| import_job_reports_import_job_id_foreign |
|
|
Cascade on delete | ||
| import_job_reports_user_id_foreign |
|
|
Cascade on delete | ||
| import_job_reports_account_id_foreign |
|
|
Cascade on delete | ||
| default_life_event_types_default_life_event_category_id_foreign |
|
|
Cascade on delete | ||
| emotion_call_emotion_id_foreign |
|
|
Cascade on delete | ||
| emotion_call_call_id_foreign |
|
|
Cascade on delete | ||
| emotion_call_contact_id_foreign |
|
|
Cascade on delete | ||
| emotion_call_account_id_foreign |
|
|
Cascade on delete | ||
| places_account_id_foreign |
|
|
Cascade on delete | ||
| entries_account_id_foreign |
|
|
Cascade on delete | ||
| photos_account_id_foreign |
|
|
Cascade on delete | ||
| addressbook_subscriptions_account_id_foreign |
|
|
Cascade on delete | ||
| addressbook_subscriptions_address_book_id_foreign |
|
|
Cascade on delete | ||
| addressbook_subscriptions_user_id_foreign |
|
|
Cascade on delete | ||
| journal_entries_account_id_foreign |
|
|
Cascade on delete | ||
| emotion_activity_activity_id_foreign |
|
|
Cascade on delete | ||
| emotion_activity_emotion_id_foreign |
|
|
Cascade on delete | ||
| emotion_activity_account_id_foreign |
|
|
Cascade on delete | ||
| activity_contact_activity_id_foreign |
|
|
Cascade on delete | ||
| activity_contact_account_id_foreign |
|
|
Cascade on delete | ||
| activity_contact_contact_id_foreign |
|
|
Cascade on delete | ||
| u2f_key_user_id_foreign |
|
|
Cascade on delete | ||
| accounts_default_gender_id_foreign |
|
|
Null on delete | ||
| synctoken_account_id_foreign |
|
|
Cascade on delete | ||
| synctoken_user_id_foreign |
|
|
Cascade on delete | ||
| gifts_contact_id_foreign |
|
|
Cascade on delete | ||
| gifts_currency_id_foreign |
|
|
Null on delete | ||
| gifts_account_id_foreign |
|
|
Cascade on delete | ||
| gifts_is_for_foreign |
|
|
Null on delete | ||
| emotions_secondary_emotion_primary_id_foreign |
|
|
Cascade on delete | ||
| addressbooks_account_id_foreign |
|
|
Cascade on delete | ||
| addressbooks_user_id_foreign |
|
|
Cascade on delete | ||
| genders_account_id_foreign |
|
|
Cascade on delete | ||
| activity_types_activity_type_category_id_foreign |
|
|
Cascade on delete | ||
| activity_types_account_id_foreign |
|
|
Cascade on delete | ||
| export_jobs_user_id_foreign |
|
|
Cascade on delete | ||
| export_jobs_account_id_foreign |
|
|
Cascade on delete | ||
| audit_logs_account_id_foreign |
|
|
Cascade on delete | ||
| audit_logs_author_id_foreign |
|
|
Null on delete | ||
| audit_logs_about_contact_id_foreign |
|
|
Null on delete | ||
| addresses_place_id_foreign |
|
|
Cascade on delete | ||
| addresses_contact_id_foreign |
|
|
Cascade on delete | ||
| addresses_account_id_foreign |
|
|
Cascade on delete | ||
| users_currency_id_foreign |
|
|
Null on delete | ||
| users_invited_by_user_id_foreign |
|
|
Null on delete | ||
| users_me_contact_id_foreign |
|
|
Null on delete | ||
| users_account_id_foreign |
|
|
Cascade on delete | ||
| tags_account_id_foreign |
|
|
Cascade on delete | ||
| address_contact_field_label_address_id_foreign |
|
|
Cascade on delete | ||
| address_contact_field_label_contact_field_label_id_foreign |
|
|
Cascade on delete | ||
| address_contact_field_label_account_id_foreign |
|
|
Cascade on delete | ||
| contact_fields_account_id_foreign |
|
|
Cascade on delete | ||
| contact_fields_contact_field_type_id_foreign |
|
|
Cascade on delete | ||
| contact_fields_contact_id_foreign |
|
|
Cascade on delete | ||
| days_account_id_foreign |
|
|
Cascade on delete | ||
| activity_statistics_contact_id_foreign |
|
|
Cascade on delete | ||
| activity_statistics_account_id_foreign |
|
|
Cascade on delete | ||
| contact_field_types_account_id_foreign |
|
|
Cascade on delete | ||
| documents_account_id_foreign |
|
|
Cascade on delete | ||
| documents_contact_id_foreign |
|
|
Cascade on delete | ||
| activity_type_categories_account_id_foreign |
|
|
Cascade on delete | ||
| tasks_account_id_foreign |
|
|
Cascade on delete | ||
| tasks_contact_id_foreign |
|
|
Cascade on delete | ||
| notes_contact_id_foreign |
|
|
Cascade on delete | ||
| notes_account_id_foreign |
|
|
Cascade on delete | ||
| relationship_types_relationship_type_group_id_foreign |
|
|
Cascade on delete | ||
| relationship_types_account_id_foreign |
|
|
Cascade on delete | ||
| messages_conversation_id_foreign |
|
|
Cascade on delete | ||
| messages_contact_id_foreign |
|
|
Cascade on delete | ||
| messages_account_id_foreign |
|
|
Cascade on delete | ||
| invitations_account_id_foreign |
|
|
Cascade on delete | ||
| invitations_invited_by_user_id_foreign |
|
|
Cascade on delete | ||
| companies_account_id_foreign |
|
|
Cascade on delete | ||
| reminder_outbox_reminder_id_foreign |
|
|
Cascade on delete | ||
| reminder_outbox_user_id_foreign |
|
|
Cascade on delete | ||
| reminder_outbox_account_id_foreign |
|
|
Cascade on delete | ||
| contact_field_contact_field_label_account_id_foreign |
|
|
Cascade on delete | ||
| contact_field_contact_field_label_contact_field_label_id_foreign |
|
|
Cascade on delete | ||
| contact_field_contact_field_label_contact_field_id_foreign |
|
|
Cascade on delete | ||
| special_dates_contact_id_foreign |
|
|
Cascade on delete | ||
| special_dates_account_id_foreign |
|
|
Cascade on delete | ||
| weather_place_id_foreign |
|
|
Cascade on delete | ||
| weather_account_id_foreign |
|
|
Cascade on delete | ||
| gift_photo_photo_id_foreign |
|
|
Cascade on delete | ||
| gift_photo_gift_id_foreign |
|
|
Cascade on delete | ||
| contact_field_labels_account_id_foreign |
|
|
Cascade on delete | ||
| activities_activity_type_id_foreign |
|
|
Null on delete | ||
| activities_account_id_foreign |
|
|
Cascade on delete | ||
| conversations_contact_id_foreign |
|
|
Cascade on delete | ||
| conversations_account_id_foreign |
|
|
Cascade on delete | ||
| conversations_contact_field_type_id_foreign |
|
|
Cascade on delete | ||
| contact_tag_tag_id_foreign |
|
|
Cascade on delete | ||
| contact_tag_account_id_foreign |
|
|
Cascade on delete | ||
| contact_tag_contact_id_foreign |
|
|
Cascade on delete | ||
| life_event_categories_account_id_foreign |
|
|
Cascade on delete | ||
| occupations_account_id_foreign |
|
|
Cascade on delete | ||
| occupations_company_id_foreign |
|
|
Cascade on delete | ||
| occupations_contact_id_foreign |
|
|
Cascade on delete | ||
| metadata_love_relationships_account_id_foreign |
|
|
Cascade on delete | ||
| metadata_love_relationships_relationship_id_foreign |
|
|
Cascade on delete | ||
| relationships_of_contact_foreign |
|
|
Cascade on delete | ||
| relationships_contact_is_foreign |
|
|
Cascade on delete | ||
| relationships_account_id_foreign |
|
|
Cascade on delete | ||
| relationships_relationship_type_id_foreign |
|
|
Cascade on delete | ||
| life_events_contact_id_foreign |
|
|
Cascade on delete | ||
| life_events_life_event_type_id_foreign |
|
|
Cascade on delete | ||
| life_events_reminder_id_foreign |
|
|
Null on delete | ||
| life_events_account_id_foreign |
|
|
Cascade on delete | ||
| contact_photo_contact_id_foreign |
|
|
Cascade on delete | ||
| contact_photo_photo_id_foreign |
|
|
Cascade on delete | ||
| reminders_account_id_foreign |
|
|
Cascade on delete | ||
| reminders_contact_id_foreign |
|
|
Cascade on delete | ||
| emotions_emotion_secondary_id_foreign |
|
|
Cascade on delete | ||
| emotions_emotion_primary_id_foreign |
|
|
Cascade on delete | ||
| webauthn_keys_user_id_foreign |
|
|
Cascade on delete | ||
| calls_account_id_foreign |
|
|
Cascade on delete | ||
| calls_contact_id_foreign |
|
|
Cascade on delete | ||
| recovery_codes_user_id_foreign |
|
|
Cascade on delete | ||
| recovery_codes_account_id_foreign |
|
|
Cascade on delete | ||
| debts_contact_id_foreign |
|
|
Cascade on delete | ||
| debts_account_id_foreign |
|
|
Cascade on delete | ||
| debts_currency_id_foreign |
|
|
Null on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|