agency_sources


Description

A row in this table represents associates an agency with its source tag.

Columns

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

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

source varchar 2147483647 null

Source tag applied to candidates submitted via this agency

created_at timestamp 29,6 null

Date the object referred to in this entity was created.

source_id varchar 2147483647 null
sources.source_id agency_sources_source_id_fkeyN

ID of the source tag applied to candidates submitted via this agency

agency_id varchar 2147483647 null
agencies.agency_id agency_sources_agency_id_fkeyN

ID of the agency record

source_rank numeric 131089 null

Order of the source on the agency, starting with 0.

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)
agency_sources_pkey Primary key Asc agency_source_id
agency_sources_account_id_index Performance Asc account_id
agency_sources_agency_id_index Performance Asc agency_id

Relationships