custom_fields

-1 rows


Description

Таблица кастомных полей аккаунта

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
companies_custom_fields_values_chained_list.custom_field_id companies_custom_fields_values_chained_lis_custom_field_id_fkey R
companies_custom_fields_values_checkbox.custom_field_id companies_custom_fields_values_checkbox_custom_field_id_fkey R
companies_custom_fields_values_date.custom_field_id companies_custom_fields_values_date_custom_field_id_fkey R
companies_custom_fields_values_file.custom_field_id companies_custom_fields_values_file_custom_field_id_fkey R
companies_custom_fields_values_legal_entity.custom_field_id companies_custom_fields_values_legal_entit_custom_field_id_fkey R
companies_custom_fields_values_multitext.custom_field_id companies_custom_fields_values_multitext_custom_field_id_fkey R
companies_custom_fields_values_numeric.custom_field_id companies_custom_fields_values_numeric_custom_field_id_fkey R
companies_custom_fields_values_select.custom_field_id companies_custom_fields_values_select_custom_field_id_fkey R
companies_custom_fields_values_smart_address.custom_field_id companies_custom_fields_values_smart_addre_custom_field_id_fkey R
companies_custom_fields_values_text.custom_field_id companies_custom_fields_values_text_custom_field_id_fkey R
contacts_custom_fields_values_chained_list.custom_field_id contacts_custom_fields_values_chained_list_custom_field_id_fkey R
contacts_custom_fields_values_checkbox.custom_field_id contacts_custom_fields_values_checkbox_custom_field_id_fkey R
contacts_custom_fields_values_date.custom_field_id contacts_custom_fields_values_date_custom_field_id_fkey R
contacts_custom_fields_values_file.custom_field_id contacts_custom_fields_values_file_custom_field_id_fkey R
contacts_custom_fields_values_legal_entity.custom_field_id contacts_custom_fields_values_legal_entity_custom_field_id_fkey R
contacts_custom_fields_values_multitext.custom_field_id contacts_custom_fields_values_multitext_custom_field_id_fkey R
contacts_custom_fields_values_numeric.custom_field_id contacts_custom_fields_values_numeric_custom_field_id_fkey R
contacts_custom_fields_values_select.custom_field_id contacts_custom_fields_values_select_custom_field_id_fkey R
contacts_custom_fields_values_smart_address.custom_field_id contacts_custom_fields_values_smart_addres_custom_field_id_fkey R
contacts_custom_fields_values_text.custom_field_id contacts_custom_fields_values_text_custom_field_id_fkey R
customers_custom_fields_values_chained_list.custom_field_id customers_custom_fields_values_chained_lis_custom_field_id_fkey R
customers_custom_fields_values_checkbox.custom_field_id customers_custom_fields_values_checkbox_custom_field_id_fkey R
customers_custom_fields_values_date.custom_field_id customers_custom_fields_values_date_custom_field_id_fkey R
customers_custom_fields_values_file.custom_field_id customers_custom_fields_values_file_custom_field_id_fkey R
customers_custom_fields_values_numeric.custom_field_id customers_custom_fields_values_numeric_custom_field_id_fkey R
customers_custom_fields_values_select.custom_field_id customers_custom_fields_values_select_custom_field_id_fkey R
customers_custom_fields_values_text.custom_field_id customers_custom_fields_values_text_custom_field_id_fkey R
leads_custom_fields_values_chained_list.custom_field_id leads_custom_fields_values_chained_list_custom_field_id_fkey R
leads_custom_fields_values_checkbox.custom_field_id leads_custom_fields_values_checkbox_custom_field_id_fkey R
leads_custom_fields_values_date.custom_field_id leads_custom_fields_values_date_custom_field_id_fkey R
leads_custom_fields_values_file.custom_field_id leads_custom_fields_values_file_custom_field_id_fkey R
leads_custom_fields_values_legal_entity.custom_field_id leads_custom_fields_values_legal_entity_custom_field_id_fkey R
leads_custom_fields_values_numeric.custom_field_id leads_custom_fields_values_numeric_custom_field_id_fkey R
leads_custom_fields_values_select.custom_field_id leads_custom_fields_values_select_custom_field_id_fkey R
leads_custom_fields_values_smart_address.custom_field_id leads_custom_fields_values_smart_address_custom_field_id_fkey R
leads_custom_fields_values_text.custom_field_id leads_custom_fields_values_text_custom_field_id_fkey R

id кастомного поля
name text 2147483647 null

Название кастомного поля
code text 2147483647 √ null

Код кастомного поля
type_id int2 5 null
custom_fields_types.id custom_fields_type_id_fkey R

Id типа кастомного поля (см. custom_fields_types)
is_deleted bool 1 false

Удалено ли кастомное поле

Indexes

Constraint Name Type Sort Column(s)
custom_fields_pkey Primary key Asc id
custom_fields_code_key Must be unique Asc code

Check Constraints

Constraint Name Constraint
custom_fields_id_check ((id > 0))

Relationships

Close relationships within degrees of separation