outbound_inbound_job_listings


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
job_link text 2147483647 √ null
action_type text 2147483647 √ null
job_created_at timestamptz 35,6 √ null
job_closed_at timestamptz 35,6 √ null
open_days int4 10 √ null
company_id text 2147483647 √ null
job_status text 2147483647 √ null
job_type_1 text 2147483647 √ null
job_title text 2147483647 √ null
job_city text 2147483647 √ null
job_region text 2147483647 √ null
company text 2147483647 √ null
company_size text 2147483647 √ null
industry text 2147483647 √ null
company_city text 2147483647 √ null
company_region text 2147483647 √ null
company_created_at timestamptz 35,6 √ null
company_status text 2147483647 √ null
internal_status text 2147483647 √ null
sales_team_member_email text 2147483647 √ null
sales_team_location text 2147483647 √ null
method text 2147483647 √ null
manager_email text 2147483647 √ null
amtm_email text 2147483647 √ null
swallowed_at timestamptz 35,6 √ null
end_date timestamptz 35,6 √ null
number_of_applications int8 19 √ null
number_of_processed_applications int8 19 √ null
first_processed timestamptz 35,6 √ null
company_new_or_existing text 2147483647 √ null
priority_leads text 2147483647 √ null
job_level_fpal_balance_left text 2147483647 √ null
initial_fpal_quota int4 10 √ null
vip_status text 2147483647 √ null
hot_job_status text 2147483647 √ null
pic_email text 2147483647 √ null
phone_whatsapp_link text 2147483647 √ null
job_creator text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
outbound_inbound_job_listings_pkey Primary key Asc row_key
idx_wb_outbound_inbound_job_listings_1 Performance Asc company_id
idx_wb_outbound_inbound_job_listings_2 Performance
idx_wb_outbound_inbound_job_listings_3 Performance Asc job_id
idx_wb_outbound_inbound_job_listings_4 Performance Asc sales_team_member_email
idx_wb_outbound_inbound_job_listings_5 Performance Asc manager_email
idx_wb_outbound_inbound_job_listings_6 Performance Desc activity_at

Relationships

Close relationships within degrees of separation