opportunity_referrals


Description

A row in this table represents a connection between an opportunity and its referrer.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
account_id varchar 2147483647 null

ID of the account the record belongs to.

opportunity_id varchar 2147483647 null
opportunities.opportunity_id opportunity_referrals_opportunity_id_fkeyC

ID of the opportunity connected to this entity.

opportunity_form_id varchar 2147483647 null
opportunity_forms.opportunity_form_id opportunity_referrals_opportunity_form_id_fkeyC

ID of the opportunity_form connected to this entity.

posting_id varchar 2147483647 null
postings.posting_id opportunity_referrals_posting_id_fkeyN

ID of the posting connected to this entity.

user_id varchar 2147483647 null
users.user_id opportunity_referrals_user_id_fkeyN

ID of the user.

is_social_referral bool 1 null

TRUE if this is a social referral.

social_referral_code varchar 2147483647 null

The code used to generate this referral through social media.

referred_at timestamp 29,6 null

Date and time of when the referral was created.

row_updated_at timestamp 29,6 CURRENT_TIMESTAMP

Date this entity was updated in the database. Useful to setup incremental refreshes of the data in your periodic ETL job.

contact_id varchar 2147483647 null
contacts.contact_id opportunity_referrals_contact_id_fkeyN

Indexes

Constraint Name Type Sort Column(s)
opportunity_referrals_pkey Primary key Asc/Asc/Asc opportunity_id + opportunity_form_id + social_referral_code
opportunity_referrals_account_id_idx Performance Asc account_id
opportunity_referrals_contact_id_index Performance Asc contact_id
opportunity_referrals_opportunity_form_id_idx Performance Asc opportunity_form_id
opportunity_referrals_opportunity_id_idx Performance Asc opportunity_id
opportunity_referrals_posting_id_idx Performance Asc posting_id
opportunity_referrals_user_id_idx Performance Asc user_id

Relationships