upsell_company_purchase_credits


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()
cpo_id text 2147483647 √ null
company_id text 2147483647 √ null
company_name text 2147483647 √ null
buyer_email text 2147483647 √ null
phone text 2147483647 √ null
phone_whatsapp_link text 2147483647 √ null
address text 2147483647 √ null
size text 2147483647 √ null
size_segmentation text 2147483647 √ null
industry text 2147483647 √ null
company_region text 2147483647 √ null
order_status text 2147483647 √ null
product_type text 2147483647 √ null
product_quantity int4 10 √ null
int4 10 √ null
free_credits int4 10 √ null
total_credits int8 19 √ null
f_free_credit_from_product int8 19 √ null
payment_method text 2147483647 √ null
payment_service text 2147483647 √ null
xendit_invoice_or_qr_id text 2147483647 √ null
order_requested_at timestamptz 35,6 √ null
order_updated_at timestamptz 35,6 √ null
order_paid_at timestamptz 35,6 √ null
order_paid_day date 13 √ null
purchase_type text 2147483647 √ null
sales_team_member_email text 2147483647 √ null
manager_email text 2147483647 √ null
amtm_email text 2147483647 √ null
sales_team_location text 2147483647 √ null
sales_position text 2147483647 √ null
sub_team text 2147483647 √ null
order_id_finance_report text 2147483647 √ null
invoice_number text 2147483647 √ null
method text 2147483647 √ null
post_job_weekend_inthelast_4mo text 2147483647 √ null
current_open_job int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
upsell_company_purchase_credits_pkey Primary key Asc row_key
idx_wb_ucpc_company_name_trgm Performance
idx_wb_ucpc_mgr_email_trgm Performance
idx_wb_ucpc_order_paid_at Performance Asc order_paid_at
idx_wb_upsell_company_purchase_credits_1 Performance Asc company_id
idx_wb_upsell_company_purchase_credits_2 Performance
idx_wb_upsell_company_purchase_credits_3 Performance Asc sales_team_member_email
idx_wb_upsell_company_purchase_credits_4 Performance Asc order_status
idx_wb_upsell_company_purchase_credits_5 Performance Asc product_type
idx_wb_upsell_company_purchase_credits_6 Performance Asc order_paid_day
idx_wb_upsell_company_purchase_credits_7 Performance Desc activity_at

Relationships

Close relationships within degrees of separation