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 or permission 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 |
| idx_fct_membership_roles_company_id | Performance | Asc | company_id |
| idx_fct_membership_roles_membership_id | Performance | Asc | membership_id |