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
1st_cpo_id 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
purchase_type text 2147483647 √ null
method text 2147483647 √ null
company_name text 2147483647 √ null
buyer_email text 2147483647 √ null
phone text 2147483647 √ null
address text 2147483647 √ null
industry text 2147483647 √ null
company_region text 2147483647 √ null
size text 2147483647 √ null
size_segmentation 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_price_of_products int4 10 √ null
subtotal_invoicing float8 17,17 √ null
subtotal_after_tax float8 17,17 √ 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_paid_at timestamptz 35,6 √ null
order_paid_day date 13 √ null
is_paid int2 5 √ null
active_date timestamptz 35,6 √ null
expired_date2 date 13 √ null
purchase_type_subs text 2147483647 √ null
order_id_finance_report text 2147483647 √ null
invoice_number text 2147483647 √ null
npwp_number text 2147483647 √ null
period_type text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
company_purchase_credits_pkey Primary key Asc row_key
idx_wb_company_purchase_credits_1 Performance Asc company_id
idx_wb_company_purchase_credits_2 Performance
idx_wb_company_purchase_credits_3 Performance Asc sales_team_member_email
idx_wb_company_purchase_credits_4 Performance Asc order_status
idx_wb_company_purchase_credits_5 Performance Asc product_type
idx_wb_company_purchase_credits_6 Performance Asc order_paid_day
idx_wb_company_purchase_credits_7 Performance Desc activity_at
idx_wb_cpc_company_name_trgm Performance
idx_wb_cpc_mgr_email_trgm Performance
idx_wb_cpc_order_paid_at Performance Asc order_paid_at

Relationships

Close relationships within degrees of separation