contact_field_labels


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
address_contact_field_label.contact_field_label_id address_contact_field_label_contact_field_label_id_foreign C
contact_field_contact_field_label.contact_field_label_id contact_field_contact_field_label_contact_field_label_id_foreign C
account_id INT UNSIGNED 10 null
accounts.id contact_field_labels_account_id_foreign C
label_i18n VARCHAR 20 √ null
label VARCHAR 500 √ null
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
contact_field_labels_account_id_foreign Performance Asc account_id
contact_field_labels_label_account_id_index Performance Asc/Asc label + account_id
contact_field_labels_label_i18n_account_id_index Performance Asc/Asc label_i18n + account_id

Relationships

Close relationships within degrees of separation