civicrm_group_contact

0 rows


Columns

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

primary key
group_id INT UNSIGNED 10 null
civicrm_group.id FK_civicrm_group_contact_group_idC

FK to civicrm_group
contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_group_contact_contact_idC

FK to civicrm_contact
status VARCHAR 8 √ null

status of contact relative to membership in group
location_id INT UNSIGNED 10 √ null
civicrm_loc_block.id FK_civicrm_group_contact_location_idN

Optional location to associate with this membership
email_id INT UNSIGNED 10 √ null
civicrm_email.id FK_civicrm_group_contact_email_idR

Optional email to associate with this membership

Indexes

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

Relationships

Close relationships within degrees of separation