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() |
|
|
|||
| trigger_sent_date | date | 13 | √ | null |
|
|
||
| company_id | text | 2147483647 | √ | null |
|
|
||
| company | text | 2147483647 | √ | null |
|
|
||
| sales_account | text | 2147483647 | √ | null |
|
|
||
| manager_email | text | 2147483647 | √ | null |
|
|
||
| latest_job_id | text | 2147483647 | √ | null |
|
|
||
| latest_job_created_at | timestamptz | 35,6 | √ | null |
|
|
||
| latest_package | text | 2147483647 | √ | null |
|
|
||
| latest_package_expiry | date | 13 | √ | null |
|
|
||
| phone_whatsapp_link | text | 2147483647 | √ | null |
|
|
||
| original_sales_account | text | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| churned_companies_pkey | Primary key | Asc | row_key |
| idx_wb_churned_companies_1 | Performance | Asc | company_id |
| idx_wb_churned_companies_2 | Performance | ||
| idx_wb_churned_companies_3 | Performance | Asc | sales_account |
| idx_wb_churned_companies_4 | Performance | Asc | manager_email |
| idx_wb_churned_companies_5 | Performance | Desc | latest_job_created_at |
| idx_wb_churned_companies_6 | Performance | Asc | trigger_sent_date |
| idx_wb_churned_companies_7 | Performance | Desc | activity_at |
Relationships
Close relationships within degrees of separation
