self_serve_renewals


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
manager_email text 2147483647 √ null
sales_team_member_email text 2147483647 √ null
company text 2147483647 √ null
premium_package_status text 2147483647 √ null
latest_self_serve_purchase text 2147483647 √ null
latest_expiry_date date 13 √ null
current_open_job int8 19 √ null
ct_self_serve_vip int8 19 √ null
subtotal_self_serve_vip float8 17,17 √ null
ct_self_serve_subsplan int8 19 √ null
subtotal_self_serve_subsplan float8 17,17 √ null
whatsapp_link text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
self_serve_renewals_pkey Primary key Asc row_key
idx_wb_self_serve_renewals_1 Performance Asc company_id
idx_wb_self_serve_renewals_2 Performance
idx_wb_self_serve_renewals_3 Performance Asc sales_team_member_email
idx_wb_self_serve_renewals_4 Performance Asc latest_expiry_date
idx_wb_self_serve_renewals_5 Performance Desc current_open_job
idx_wb_self_serve_renewals_6 Performance Desc activity_at
idx_wb_selfserve_company_trgm Performance
idx_wb_selfserve_mgr_email_trgm Performance
idx_wb_selfserve_package_status Performance Asc premium_package_status

Relationships

Close relationships within degrees of separation