Columns
| Column | Type | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|
| membership_community_skey | text |
|
|
The unique identifier of the membership and community combo. E.g. “ea54c06c1e1c06ba9f1aa39d98dc5bc1”. |
|||
| membership_id | int8 |
|
|
The unique membership ID. E.g. 57. |
|||
| community_id | int8 |
|
|
The unique community ID of the Membership. E.g. 123. |
|||
| community_name | text |
|
|
The name of the community the Membership is a part of. E.g. “Adelaide West”. |
|||
| company_id | int8 |
|
|
The company ID. E.g. 345 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_membership_communities_pkey | Primary key | Asc | membership_community_skey |
| fct_membership_communities_community_id_idx | Performance | Asc | community_id |
| fct_membership_communities_company_id_idx | Performance | Asc | company_id |
| fct_membership_communities_membership_id_idx | Performance | Asc | membership_id |