crm_email_engagements

34786 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
customer_id varchar 8 null
customer.id crm_email_engagements_customer_id_fkey R
hubspot_owner_id varchar 256 √ null
email_direction email_direction 2147483647 √ null
email_from_email _varchar 2147483647 √ null
email_from_name text 2147483647 √ null
email_to_email _varchar 2147483647 √ null
email_to_name text 2147483647 √ null
email_status varchar 64 √ null
email_text text 2147483647 √ null
integration_type customer_level_integrated_app 2147483647 null
contact_association_ids _varchar 2147483647 √ null
company_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()
id varchar 8 null
email_id varchar 64 null
crm_meeting.id Implied Constraint R
deal_id varchar 8 √ null
crm_deals.id crm_email_engagements_deal_id_fkey R
company_id varchar 8 √ null
crm_companies.id crm_email_engagements_company_id_fkey R
contact_id varchar 8 √ null
crm_contacts.id crm_email_engagements_contact_id_fkey R
subject text 2147483647 √ null
deal_association_ids _varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
crm_email_engagements_pkey Primary key Asc id
crm_email_engagements_customer_id_email_id_uniq Must be unique Asc/Asc customer_id + email_id

Relationships

Close relationships within degrees of separation