0 rows


tag_instance table holds the information of associations bet


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
tagid BIGINT 19 null
tag.id taginst_tag2_fkR
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_fkR

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



Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
taginst_comiteitecontiuta2_uix Must be unique Asc/Asc/Asc/Asc/Asc/Asc component + itemtype + itemid + contextid + tiuserid + tagid
taginst_con4_ix Performance Asc contextid
taginst_itecomtagcon2_ix Performance Asc/Asc/Asc/Asc itemtype + component + tagid + contextid
taginst_tag4_ix Performance Asc tagid