Table d45civi_b72v5.civicrm_entity_tag Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √  primary key
entity_table varchar 64  √  null physical tablename for entity being joined to file, e.g. civicrm_contact
entity_id int unsigned 10 FK to entity table specified in entity_table column.
tag_id int unsigned 10 FK_civicrm_entity_tag_tag_id C
FK to civicrm_tag

Table contained 120 rows at Wed Nov 11 17:12 EST 2015

Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
tag_id Performance Asc FK_civicrm_entity_tag_tag_id
entity_id + entity_table + tag_id Must be unique Asc/Asc/Asc UI_entity_id_entity_table_tag_id

Close relationships  within of separation: