Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| membership_role_id | int4 |
|
|
The ID of the membership role, e.g. 159. |
| membership_id | int4 |
|
|
The ID of the associated membership, e.g. 1205. |
| profile_id | int4 |
|
|
The ID of the associated profile, e.g. 904. |
| role | varchar |
|
|
The role of the profile in the membership. One of |
| is_primary_contact | bool |
|
|
Whether the profile is the primary contact for the membership. One of True, False. |
| company_id | int8 |
|
|
The company ID, e.g.: 345. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_membership_roles_pkey | Primary key | Asc | membership_role_id |
| fct_membership_roles_company_id_idx | Performance | Asc | company_id |
| fct_membership_roles_membership_id_idx | Performance | Asc | membership_id |