Tag Correlation Table Schema (tag_correlation)


The rationale for the 'tag_correlation' table is performance. It works as a cache for a potentially heavy load query done at the 'tag_instance' table. So, the 'tag_correlation' table stores redundant information derived from the 'tag_instance' table

tag_correlation table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
tagid BIGINT 19 null
tag.id tagcorr_tag2_fk R
correlatedtags LONGTEXT 2147483647 null

Table contained -1 rows

tag_correlation table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
tagcorr_tag_ix Performance Asc tagid

tag_correlation table relationships