tag_correlation

0 rows


Description

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

Columns

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

Indexes

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

Relationships

Close relationships within degrees of separation