| id |
INT UNSIGNED |
10 |
|
√ |
null |
|
|
primary key |
| group_id |
INT UNSIGNED |
10 |
|
|
null |
|
|
FK to civicrm_group |
| contact_id |
INT UNSIGNED |
10 |
|
|
null |
|
|
FK to civicrm_contact |
| status |
VARCHAR |
8 |
√ |
|
null |
|
|
status of contact relative to membership in group |
| location_id |
INT UNSIGNED |
10 |
√ |
|
null |
|
|
Optional location to associate with this membership |
| email_id |
INT UNSIGNED |
10 |
√ |
|
null |
|
|
Optional email to associate with this membership |
