opportunity_tags


Description

A row in this table represents a connection between an opportunity and the tags associated with it.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
opportunity_tag_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_tags_opportunity_id_fkeyC

ID of the opportunity connected to this entity.

tag_id varchar 2147483647 null
tags.tag_id opportunity_tags_tag_id_fkeyN

ID of the tag record

tag varchar 2147483647 null

Raw string value of the tag.

tag_rank numeric 131089 null

Numeric order of the tag as it appears on the opportunity.

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.

Indexes

Constraint Name Type Sort Column(s)
opportunity_tags_pkey Primary key Asc opportunity_tag_id
opportunity_tags_account_id_index Performance Asc account_id
opportunity_tags_opportunity_id_index Performance Asc opportunity_id
opportunity_tags_tag_id_index Performance Asc tag_id

Relationships