civicrm_group_contact_cache


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

FK to civicrm_group

contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_group_contact_cache_contact_id C

FK to civicrm_contact

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_group_contact_cache_group_id Performance Asc group_id
UI_contact_group Must be unique Asc/Asc contact_id + group_id

Relationships