job_department_teams


Description

A row in this table represents a team that belongs to a department advertised along with job postings.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
job_department_team_id varchar 2147483647 null
offer_events.job_department_team_id offer_events_job_department_team_id_fkeyN
offer_revisions.job_department_team_id offer_revisions_job_department_team_id_fkeyN
opportunity_feedback_events.job_department_team_id opportunities_feedback_events_job_department_team_id_fkeyN
opportunity_form_events.job_department_team_id opportunities_form_events_job_department_team_id_fkeyN
opportunity_progress_events.job_department_team_id opportunities_progress_events_job_department_team_id_fkeyN
posting_events.job_department_team_id posting_events_job_department_team_id_fkeyN
postings.job_department_team_id postings_job_department_team_id_fkeyN
requisition_events.job_department_team_id requisition_events_job_department_team_id_fkeyN
requisitions.job_department_team_id requisitions_job_department_team_id_fkeyN

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

job_department_id varchar 2147483647 null
job_departments.job_department_id job_department_teams_department_id_fkeyN

ID of the department associated with this record.

name varchar 2147483647 null

The name of the team

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.

Indexes

Constraint Name Type Sort Column(s)
job_department_teams_pkey Primary key Asc job_department_team_id
job_department_teams_account_id_department_id_name_key Must be unique Asc/Asc/Asc account_id + job_department_id + name
job_department_teams_account_id_index Performance Asc account_id

Relationships