crm_companies

85266 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
customer_id varchar 8 null
customer.id crm_companies_customer_id_fkey R
company_id varchar 64 null
crm_meeting.id Implied Constraint R
city varchar 256 √ null
name varchar 2048 √ null
phone varchar 64 √ null
website varchar 2048 √ null
domain varchar 200 √ null
integration_type customer_level_integrated_app 2147483647 null
contact_association_ids _varchar 2147483647 √ null
crm_created_at timestamptz 35,6 √ now()
crm_updated_at timestamptz 35,6 √ now()
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()
owner_id varchar 256 √ null
crm_rep.id crm_companies_owner_id_fkey R
id varchar 8 null
contact_company_association.company_id contact_company_association_company_id_fkey R
crm_email_engagements.company_id crm_email_engagements_company_id_fkey R
crm_meeting.company_id crm_meeting_company_id_fkey R
crm_note_engagements.company_id crm_note_engagements_company_id_fkey R
crm_rep.company_id crm_rep_company_id_fkey R
deal_company_association.company_id deal_company_association_company_id_fkey R
type varchar 256 √ null
about_us text 2147483647 √ null
annual_revenue varchar 64 √ null
country varchar 256 √ null
description text 2147483647 √ null
founded_year varchar 64 √ null
industry varchar 256 √ null
is_public varchar 16 √ null
lifecycle_stage varchar 256 √ null
linkedin_company_page varchar 2048 √ null
linkedin_bio varchar 2048 √ null
crm_owner_id varchar 64 √ null
crm_meeting.id Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
crm_companies_pkey Primary key Asc id
crm_companies_company_id_idx Performance Asc company_id
crm_companies_customer_id_company_id_uniq Must be unique Asc/Asc customer_id + company_id
crm_companies_customer_id_idx Performance Asc customer_id
crm_companies_id_idx Performance Asc id

Relationships

Close relationships within degrees of separation