outbound_jobs_zero_processed_p30d


Columns

Column Type Size Nulls Auto Default Children Parents Comments
row_key text 2147483647 null
activity_at timestamptz 35,6 √ null
source_updated_at timestamptz 35,6 √ null
row_hash text 2147483647 null
synced_at timestamptz 35,6 now()
jel_id text 2147483647 √ null
job_id text 2147483647 √ null
action_type text 2147483647 √ null
job_link text 2147483647 √ null
job_created_date date 13 √ null
job_closed_date date 13 √ null
job_title text 2147483647 √ null
job_status text 2147483647 √ null
company_id text 2147483647 √ null
company text 2147483647 √ null
company_created_at timestamptz 35,6 √ null
company_pic_phone_number text 2147483647 √ null
job_type text 2147483647 √ null
acquired_by text 2147483647 √ null
manager_email text 2147483647 √ null
amtm_email text 2147483647 √ null
sales_team_location text 2147483647 √ null
acquisition_method text 2147483647 √ null
self_serve_history text 2147483647 √ null
subs_plan_history text 2147483647 √ null
end_of_vip_subsplan timestamptz 35,6 √ null
number_of_applications int8 19 √ null
number_of_processed_applications int8 19 √ null
company_new_or_existing text 2147483647 √ null
max_rn int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
outbound_jobs_zero_processed_p30d_pkey Primary key Asc row_key
idx_wb_outbound_jobs_zero_processed_p30d_1 Performance Asc company_id
idx_wb_outbound_jobs_zero_processed_p30d_2 Performance
idx_wb_outbound_jobs_zero_processed_p30d_3 Performance Asc job_id
idx_wb_outbound_jobs_zero_processed_p30d_4 Performance Asc manager_email
idx_wb_outbound_jobs_zero_processed_p30d_5 Performance Desc activity_at

Relationships

Close relationships within degrees of separation