company_limits_daily_shortlisting


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_name text 2147483647 √ null
company_created_at timestamptz 35,6 √ null
company_status text 2147483647 √ null
company_region text 2147483647 √ null
active_job_count int8 19 √ null
yesterday_count int4 10 √ null
today_count int4 10 √ null
text 2147483647 √ null
package_start_time timestamptz 35,6 √ null
package_end_time timestamptz 35,6 √ null
sales_acquisition text 2147483647 √ null
sales_account text 2147483647 √ null
daily_shortlist_quota int4 10 √ null
daily_quota_left int8 19 √ null
concurrent_job_slots int4 10 √ null
pic_phone_number text 2147483647 √ null
type text 2147483647 √ null
avg_30_days float8 17,17 √ null

Indexes

Constraint Name Type Sort Column(s)
company_limits_daily_shortlisting_pkey Primary key Asc row_key
idx_wb_company_limits_daily_shortlisting_1 Performance Asc company_id
idx_wb_company_limits_daily_shortlisting_2 Performance
idx_wb_company_limits_daily_shortlisting_3 Performance Asc sales_account
idx_wb_company_limits_daily_shortlisting_4 Performance Desc activity_at

Relationships

Close relationships within degrees of separation