opportunity_sources


Description

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

Columns

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

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

opportunity_id varchar 2147483647 null
opportunities.opportunity_id opportunity_sources_opportunity_id_fkeyC

ID of the opportunity connected to this entity.

source_id varchar 2147483647 null
sources.source_id opportunity_sources_source_id_fkeyN

ID of the source associated with this entity.

source varchar 2147483647 null

Raw string value of the source.

source_rank numeric 131089 null

The relative order of the source on the opportunity, starting with application sources. Sources on the opportunity begin at with rank 1000 for consistent ordering.

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.

opportunity_source_type_id varchar 2147483647 null
opportunity_source_type_enum.opportunity_source_type_id opportunity_sources_opportunity_source_type_id_fkeyN
application_rank numeric 131089 null

The numeric order of the source on the application, or null if source is not on the application.

opportunity_rank numeric 131089 null

The numeric order of the source on the opportunity, or null if source is not on the opportunity.

Indexes

Constraint Name Type Sort Column(s)
opportunity_sources_pkey Primary key Asc opportunity_source_id
opportunity_sources_account_id_index Performance Asc account_id
opportunity_sources_opportunity_id_index Performance Asc opportunity_id
opportunity_sources_source_id_index Performance Asc source_id
opportunity_sources_source_type_id_idx Performance Asc opportunity_source_type_id

Relationships