job_locations


Description

A row in this table represents a location in the company advertised along with job postings.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
job_location_id varchar 2147483647 null
offer_events.job_location_id offer_events_job_location_id_fkeyN
offer_revisions.job_location_id offer_revisions_job_location_id_fkeyN
opportunity_feedback_events.job_location_id opportunities_feedback_events_job_location_id_fkeyN
opportunity_form_events.job_location_id opportunities_form_events_job_location_id_fkeyN
opportunity_progress_events.job_location_id opportunities_progress_events_job_location_id_fkeyN
posting_events.job_location_id posting_events_job_location_id_fkeyN
posting_locations.job_location_id posting_locations_job_location_id_fkeyR
postings.job_location_id postings_job_location_id_fkeyN
requisition_events.job_location_id requisition_events_job_location_id_fkeyN
requisitions.job_location_id requisitions_job_location_id_fkeyN

Primary key.
account_id varchar 2147483647 √ null

ID of the account the record belongs to.
name varchar 2147483647 √ null

The name of the job location
country_code varchar 2147483647 √ null

2-letter country code of where the contact resides
created_at timestamp 29,6 √ null

Date the object referred to in this entity was created.
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.
is_deleted bool 1 false

Indexes

Constraint Name Type Sort Column(s)
job_locations_pkey Primary key Asc job_location_id
job_locations_account_id_index Performance Asc account_id
job_locations_account_id_name_key Must be unique Asc/Asc account_id + name

Relationships

Close relationships within degrees of separation