Tag Instance Table Schema (tag_instance)


Description

tag_instance table holds the information of associations between tags and other items

tag_instance table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
tagid BIGINT 19 null
tag.id taginst_tag2_fk R
component VARCHAR 100

Defines the Moodle component which the tag was added to
itemtype VARCHAR 100
itemid BIGINT 19 null
contextid BIGINT 19 √ null
context.id taginst_con2_fk R

The context id of the item that was tagged
tiuserid BIGINT 19 0
ordering BIGINT 19 √ null

Maintains the order of the tag instances of an item
timecreated BIGINT 19 0
timemodified BIGINT 19 0

timemodified

Table contained -1 rows

tag_instance table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
taginst_comiteitecontiutag_uix Must be unique Asc/Asc/Asc/Asc/Asc/Asc component + itemtype + itemid + contextid + tiuserid + tagid
taginst_con_ix Performance Asc contextid
taginst_itecomtagcon_ix Performance Asc/Asc/Asc/Asc itemtype + component + tagid + contextid
taginst_tag_ix Performance Asc tagid

tag_instance table relationships

Close relationships within degrees of separation