platform_company_checker


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_verified_at_csl timestamptz 35,6 √ null
company_status text 2147483647 √ null
internal_status text 2147483647 √ null
activity_status text 2147483647 √ null
sales_acquisition text 2147483647 √ null
manager_acquisition text 2147483647 √ null
amtm_acquisition text 2147483647 √ null
acquisition_title text 2147483647 √ null
method_acquisition text 2147483647 √ null
swallowed_at_acquisition timestamptz 35,6 √ null
sales_account text 2147483647 √ null
manager_account text 2147483647 √ null
amtm_account text 2147483647 √ null
account_title text 2147483647 √ null
method_account text 2147483647 √ null
swallowed_at_account timestamptz 35,6 √ null
company_size text 2147483647 √ null
company_city text 2147483647 √ null
company_region text 2147483647 √ null
size_segmentation text 2147483647 √ null
client_classifications text 2147483647 √ null
verification_flow text 2147483647 √ null
pic_email text 2147483647 √ null
pic_phone_number text 2147483647 √ null
last_seen timestamptz 35,6 √ null
concurrent_job_slots int4 10 √ null
ct_jp_monthdate int8 19 √ null
industry text 2147483647 √ null
company_group text 2147483647 √ null
priority_leads text 2147483647 √ null
duplicate_allowed text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
platform_company_checker_pkey Primary key Asc row_key
idx_wb_platform_company_checker_1 Performance Asc company_id
idx_wb_platform_company_checker_2 Performance
idx_wb_platform_company_checker_3 Performance Asc sales_account
idx_wb_platform_company_checker_4 Performance Asc sales_acquisition
idx_wb_platform_company_checker_5 Performance Asc company_status
idx_wb_platform_company_checker_6 Performance Desc activity_at
idx_wb_platform_company_trgm Performance

Relationships

Close relationships within degrees of separation