Table d47civi_0z3xa.civicrm_prevnext_cache 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  √ 
entity_table varchar 64  √  null physical tablename for entity being joined to discount, e.g. civicrm_event
entity_id1 int unsigned 10 FK to entity table specified in entity_table column.
entity_id2 int unsigned 10 FK to entity table specified in entity_table column.
cacheKey varchar 255  √  null Unique path name for cache element of the searched item
data longtext 2147483647  √  null cached snapshot of the serialized data
is_selected tinyint 3  √  0

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
cacheKey + entity_id1 + entity_id2 + entity_table + is_selected Performance Asc/Asc/Asc/Asc/Asc index_all