civicrm_group_contact


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_id C

FK to civicrm_group

contact_id INT UNSIGNED 10 null
civicrm_contact.id 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
civicrm_loc_block.id FK_civicrm_group_contact_location_id N

Optional location to associate with this membership

email_id INT UNSIGNED 10 null
civicrm_email.id FK_civicrm_group_contact_email_id R

Optional email to associate with this membership

Table contained 0 rows

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