Tag Table Schema (tag)


Tag table - this generic table will replace the old "tags" table.

tag table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
tag_correlation.tagid tagcorr_tag2_fk R
tag_instance.tagid taginst_tag2_fk R
userid BIGINT 19 null
user.id tag_use2_fk R
tagcollid BIGINT 19 null
tag_coll.id tag_tag2_fk R
name VARCHAR 255
rawname VARCHAR 255

The raw, unnormalised name for the tag as entered by users

isstandard BIT 1 0

Whether this tag is standard

description LONGTEXT 2147483647 null
descriptionformat TINYINT 3 0
flag SMALLINT 5 0

a tag can be 'flagged' as inappropriate

timemodified BIGINT 19 null

Table contained -1 rows

tag table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
tag_tag_ix Performance Asc tagcollid
tag_tagiss_ix Performance Asc/Asc tagcollid + isstandard
tag_tagnam_uix Must be unique Asc/Asc tagcollid + name
tag_use_ix Performance Asc userid

tag table relationships