A row in this table represents an assignment of a job posting to an agency.


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

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

added_at timestamp 29,6 null

Date the job posting was added to the agency.

posting_id varchar 2147483647 null
postings.posting_id agency_jobs_posting_id_fkeyN

ID of the posting connected to this entity.

created_at timestamp 29,6 null

Date the object referred to in this entity was created.

agency_id varchar 2147483647 null
agencies.agency_id agency_jobs_agency_id_fkeyN

ID of the agency record

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.


Constraint Name Type Sort Column(s)
agency_jobs_pkey Primary key Asc agency_job_id
agency_jobs_account_id_index Performance Asc account_id