Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null

primary key

group_id INT UNSIGNED 10 null FK_civicrm_group_contact_group_id C

FK to civicrm_group

contact_id INT UNSIGNED 10 null FK_civicrm_group_contact_contact_id C

FK to civicrm_contact

status VARCHAR 8 null

status of contact relative to membership in group

location_id INT UNSIGNED 10 null FK_civicrm_group_contact_location_id N

Optional location to associate with this membership

email_id INT UNSIGNED 10 null FK_civicrm_group_contact_email_id R

Optional email to associate with this membership

Table contained 0 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_group_contact_email_id Performance Asc email_id
FK_civicrm_group_contact_group_id Performance Asc group_id
FK_civicrm_group_contact_location_id Performance Asc location_id
UI_contact_group Must be unique Asc/Asc contact_id + group_id