tags


Description

A row in this table represents a tag.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
tag_id varchar 2147483647 null
api_credential_tags.tag_id api_credentials_tags_tag_id_fkeyN
opportunity_tags.tag_id opportunity_tags_tag_id_fkeyN
posting_tags.tag_id posting_tags_tag_id_fkeyN

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

tag varchar 2147483647 null

Custom name for the tag

row_updated_at timestamp 29,6 null

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

Indexes

Constraint Name Type Sort Column(s)
tags_pkey Primary key Asc tag_id
tags_account_id_index Performance Asc account_id

Relationships