crm_rep

1494 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id varchar 8 null
crm_companies.owner_id crm_companies_owner_id_fkey R
crm_deals.owner_id crm_deals_owner_id_fkey R
deal_collaborators_association.rep_id deal_collaborators_association_rep_id_fkey R
rep_id varchar 64 √ null
crm_meeting.id Implied Constraint R
company_id varchar 8 √ null
crm_companies.id crm_rep_company_id_fkey R
customer_id varchar 8 null
customer.id crm_rep_customer_id_fkey R
email varchar 128 √ null
name varchar 2048 √ null
crm_created_at timestamptz 35,6 √ now()
crm_updated_at timestamptz 35,6 √ now()
integration_type customer_level_integrated_app 2147483647 null
created_at timestamptz 35,6 √ now()
updated_at timestamptz 35,6 √ now()

Indexes

Constraint Name Type Sort Column(s)
crm_rep_pkey Primary key Asc id
crm_rep_email_customer_id_uniq Must be unique Asc/Asc email + customer_id
crm_rep_id_idx Performance Asc id
crm_rep_rep_id_idx Performance Asc rep_id

Relationships

Close relationships within degrees of separation