companies

-1 rows


Description

Таблица компаний

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
companies_custom_fields_values_chained_list.entity_id companies_custom_fields_values_chained_list_entity_id_fkey R
companies_custom_fields_values_checkbox.entity_id companies_custom_fields_values_checkbox_entity_id_fkey R
companies_custom_fields_values_date.entity_id companies_custom_fields_values_date_entity_id_fkey R
companies_custom_fields_values_file.entity_id companies_custom_fields_values_file_entity_id_fkey R
companies_custom_fields_values_legal_entity.entity_id companies_custom_fields_values_legal_entity_entity_id_fkey R
companies_custom_fields_values_multitext.entity_id companies_custom_fields_values_multitext_entity_id_fkey R
companies_custom_fields_values_numeric.entity_id companies_custom_fields_values_numeric_entity_id_fkey R
companies_custom_fields_values_select.entity_id companies_custom_fields_values_select_entity_id_fkey R
companies_custom_fields_values_smart_address.entity_id companies_custom_fields_values_smart_address_entity_id_fkey R
companies_custom_fields_values_text.entity_id companies_custom_fields_values_text_entity_id_fkey R
companies_to_tags.entity_id companies_to_tags_entity_id_fkey R
company_to_contacts.company_id company_to_contacts_company_id_fkey R
company_to_customers.company_id company_to_customers_company_id_fkey R
company_to_leads.company_id company_to_leads_company_id_fkey R

id компании
name text 2147483647 null

Название компании
responsible_user_id int4 10 √ null
users.id companies_responsible_user_id_fkey R

id пользователя, ответственного за компанию
created_by int4 10 null

id пользователя, который создал контакт
updated_by int4 10 null

id пользователя, который обновил контакт
created_at timestamp 29,6 null

Дата создания компании
updated_at timestamp 29,6 null

Дата обновления компании
is_deleted bool 1 null

Удалена ли компания
closest_task_at timestamp 29,6 √ null

Дата ближайшей задачи к выполнению

Indexes

Constraint Name Type Sort Column(s)
companies_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
companies_id_check ((id > 0))
companies_updated_by_check ((updated_by >= 0))
companies_created_by_check ((created_by >= 0))

Relationships

Close relationships within degrees of separation