Tag Table Schema (tag)


Description

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

Close relationships within degrees of separation