app_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’ ta

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_tag_correlation_id_seq'::regclass)
tagid int8 19 null
app_tag.id Defined in XMLR
correlatedtags text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
app_tagcorr_id_pk Primary key Asc id
app_tagcorr_tag_ix Performance Asc tagid

Relationships