Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| membership_cohort_id | int8 |
|
|
The unique ID of the membership cohort, e.g. 823. |
| membership_id | int8 |
|
|
The membership ID, e.g.: 57. |
| cohort_id | int8 |
|
|
The cohort ID, e.g.: 57. |
| cohort_name | text |
|
|
The name of the cohort, e.g. “Lives Alone” |
| is_active | bool |
|
|
Whether the cohort is active, e.g. true. |
| entered_at | timestamp |
|
|
The date and time that the member entered the cohort (in UTC), e.g.: 2021-03-02 00:12:59.996101. |
| exited_at | timestamp |
|
|
The date and time that the member exited the cohort (in UTC), e.g.: 2021-07-05 00:11:58.732145. |
| community_names | text |
|
|
|
| company_id | int8 |
|
|
The company ID, e.g. 345. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_membership_cohorts_pkey | Primary key | Asc | membership_cohort_id |
| fct_membership_cohorts_company_id_idx | Performance | Asc | company_id |
| fct_membership_cohorts_membership_id_idx | Performance | Asc | membership_id |