sdb_company_checker_realtime_ops


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
brand_name text 2147483647 √ null
company_created_at timestamptz 35,6 √ null
company_verified_at timestamptz 35,6 √ null
company_status text 2147483647 √ null
internal_status text 2147483647 √ null
activity_status text 2147483647 √ null
sales_team_member_email_acquisition text 2147483647 √ null
manager_email_acquisition text 2147483647 √ null
manager_manager_email_acquisition text 2147483647 √ null
job_position_title_acquisition text 2147483647 √ null
swallowed_at_acquisition timestamptz 35,6 √ null
method_acquisition text 2147483647 √ null
sales_acquisition_location text 2147483647 √ null
sales_team_member_email_account text 2147483647 √ null
manager_email_account text 2147483647 √ null
manager_manager_email_account text 2147483647 √ null
job_position_title_account text 2147483647 √ null
swallowed_at_account timestamptz 35,6 √ null
method_account text 2147483647 √ null
size text 2147483647 √ null
company_city text 2147483647 √ null
company_region text 2147483647 √ null
size_segmentation text 2147483647 √ null
industry text 2147483647 √ null
client_classifications text 2147483647 √ null
pic_email text 2147483647 √ null
pic_phone_number text 2147483647 √ null
last_seen timestamptz 35,6 √ null
company_group text 2147483647 √ null
verification_method text 2147483647 √ null
rn_acquisition int4 10 √ null
rn_account int4 10 √ null
end_date_acquisition timestamptz 35,6 √ null
end_date_account timestamptz 35,6 √ null
duplicate_allowed text 2147483647 √ null
verification_flow text 2147483647 √ null
latest_closed_job timestamptz 35,6 √ null
days_after_closed_job int4 10 √ null
payment_status text 2147483647 √ null
frequenchy_purchase int8 19 √ null
aov float8 17,17 √ null
is_counted_claim_verif text 2147483647 √ null
is_active text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
sdb_company_checker_realtime_ops_pkey Primary key Asc row_key
idx_wb_sdb_client_classifications Performance Asc client_classifications
idx_wb_sdb_company_checker_realtime_ops_1 Performance Asc company_id
idx_wb_sdb_company_checker_realtime_ops_10 Performance Asc duplicate_allowed
idx_wb_sdb_company_checker_realtime_ops_11 Performance Asc verification_method
idx_wb_sdb_company_checker_realtime_ops_12 Performance Desc activity_at
idx_wb_sdb_company_checker_realtime_ops_2 Performance
idx_wb_sdb_company_checker_realtime_ops_3 Performance Asc sales_team_member_email_acquisition
idx_wb_sdb_company_checker_realtime_ops_4 Performance Asc manager_email_acquisition
idx_wb_sdb_company_checker_realtime_ops_5 Performance Asc sales_acquisition_location
idx_wb_sdb_company_checker_realtime_ops_6 Performance Asc sales_team_member_email_account
idx_wb_sdb_company_checker_realtime_ops_7 Performance Asc manager_email_account
idx_wb_sdb_company_checker_realtime_ops_8 Performance Asc company_status
idx_wb_sdb_company_checker_realtime_ops_9 Performance Asc activity_status
idx_wb_sdb_company_created_at Performance Asc company_created_at
idx_wb_sdb_company_group_trgm Performance
idx_wb_sdb_company_trgm Performance
idx_wb_sdb_company_verified_at Performance Asc company_verified_at
idx_wb_sdb_mgr_acct_email_trgm Performance
idx_wb_sdb_mgr_acq_email_trgm Performance
idx_wb_sdb_sales_acct_email_trgm Performance
idx_wb_sdb_sales_acq_email_trgm Performance
idx_wb_sdb_sales_loc_trgm Performance

Relationships

Close relationships within degrees of separation