Table d47civi_0z3xa.civicrm_entity_tag Generated by
SchemaSpy
Legend: SourceForge.net
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
civicrm_tag.id FK_civicrm_entity_tag_tag_id C
FK to civicrm_tag

Table contained 119 rows at mer. avr. 13 16:52 EDT 2016

Indexes:
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: