Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| monthly_reporting_id | text |
|
|
The unique identifier (uuid) of the reporting period. E.g.: fa84c36c1e1c06ba9f1aa39d98dc5bc1. |
| start_of_month | timestamp |
|
|
The start of the month. E.g. |
| end_of_month | timestamp |
|
|
The end of the month. E.g. |
| new_memberships | int8 |
|
|
The number of memberships that signed up during the month. E.g. 23. |
| churned_memberships | int8 |
|
|
The number of memberships that were archived during the month. E.g. 8. |
| active_memberships | int8 |
|
|
The number of memberships that were signed up and not archived during the month. E.g. 120. |
| total_archived_memberships | int8 |
|
|
The total number of archived memberships until the month. E.g. 94. |
| total_memberships_created | int8 |
|
|
The total number of memberships that have signed up until the month. E.g. 230. |
| company_id | int8 |
|
|
The company ID. E.g.: 345. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_monthly_membership_reporting_pkey | Primary key | Asc | monthly_reporting_id |
| fct_monthly_membership_reporting_company_id_idx | Performance | Asc | company_id |