m2_company_list_with_open_job_count


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()
company_id text 2147483647 √ null
company text 2147483647 √ null
company_created_at timestamptz 35,6 √ null
company_verified_at timestamptz 35,6 √ null
company_last_seen timestamptz 35,6 √ null
company_status text 2147483647 √ null
sales_account text 2147483647 √ null
manager_account text 2147483647 √ null
amtm_account text 2147483647 √ null
sales_acquisition text 2147483647 √ null
manager_acquisition text 2147483647 √ null
amtm_acquisition text 2147483647 √ null
swallowed_at_account timestamptz 35,6 √ null
size text 2147483647 √ null
size_segmentation text 2147483647 √ null
company_region text 2147483647 √ null
industry text 2147483647 √ null
subs_plan_history text 2147483647 √ null
self_serve_history text 2147483647 √ null
self_serve_total_trx int8 19 √ null
self_serve_subtotal float8 17,17 √ null
vip_status text 2147483647 √ null
vip_latest_expired_date date 13 √ null
vip_latest_product_type text 2147483647 √ null
subs_plan_latest_expiry_date_time date 13 √ null
current_subs_plan text 2147483647 √ null
total_jobs int8 19 √ null
total_job_created_last90d int8 19 √ null
total_job_created_last60d int8 19 √ null
total_job_created_last30d int8 19 √ null
current_open_job int8 19 √ null
external_jobs_30d int8 19 √ null
ct_applicants_openjob int8 19 √ null
ct_shortlisted_openjob int8 19 √ null
applications_last_90D int8 19 √ null
PctProcessedApplLast90Ds float8 17,17 √ null
PctShrtlstdApplLast90Ds float8 17,17 √ null
shortlisted_per_job_90dhistory float8 17,17 √ null
company_segment text 2147483647 √ null
phone_whatsapp_link text 2147483647 √ null
phone_whatsapp_link_2 text 2147483647 √ null
phone_whatsapp_link_3 text 2147483647 √ null
phone_whatsapp_link_4 text 2147483647 √ null
priority_acquisition text 2147483647 √ null
report_date date 13 √ null
link_destination text 2147483647 √ null
link_destination2 text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
m2_company_list_with_open_job_count_pkey Primary key Asc row_key
idx_wb_m2_company_last_seen Performance Asc company_last_seen
idx_wb_m2_company_list_with_open_job_count_1 Performance Asc company_id
idx_wb_m2_company_list_with_open_job_count_2 Performance
idx_wb_m2_company_list_with_open_job_count_3 Performance Asc sales_account
idx_wb_m2_company_list_with_open_job_count_4 Performance Desc current_open_job
idx_wb_m2_company_list_with_open_job_count_5 Performance Desc activity_at
idx_wb_m2_company_status Performance Asc company_status
idx_wb_m2_company_trgm Performance
idx_wb_m2_manager_account_trgm Performance
idx_wb_m2_vip_status Performance Asc vip_status

Relationships

Close relationships within degrees of separation