crm_deals

1449 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
deal_id varchar 64 √ null
crm_meeting.id Implied Constraint R
customer_id varchar 8 null
customer.id crm_deals_customer_id_fkey R
close_date timestamptz 35,6 √ now()
integration_type customer_level_integrated_app 2147483647 null
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()
id varchar 8 null
crm_email_engagements.deal_id crm_email_engagements_deal_id_fkey R
crm_meeting.deal_id crm_meeting_deal_id_fkey R
crm_note_engagements.deal_id crm_note_engagements_deal_id_fkey R
deal_collaborators_association.deal_id deal_collaborators_association_deal_id_fkey R
deal_company_association.deal_id deal_company_association_deal_id_fkey R
deal_contact_association.deal_id deal_contact_association_deal_id_fkey R
owner_id varchar 8 √ null
crm_rep.id crm_deals_owner_id_fkey R
name varchar 2048 √ null
stage varchar 128 √ null
deal_created_date timestamptz 35,6 √ null
deal_updated_at timestamptz 35,6 √ null
type varchar 128 √ null
description text 2147483647 √ null
amount varchar 64 √ null
is_deal_archived bool 1 √ null
crm_owner_id varchar 64 √ null
crm_meeting.id Implied Constraint R
sentiment varchar 32 √ null

Indexes

Constraint Name Type Sort Column(s)
crm_deals_pkey Primary key Asc id
crm_deals_customer_id_deal_id_uniq Must be unique Asc/Asc customer_id + deal_id
crm_deals_customer_id_idx Performance Asc customer_id
crm_deals_deal_id_idx Performance Asc deal_id
crm_deals_id_idx Performance Asc id

Relationships

Close relationships within degrees of separation