Tag Coll Table Schema (tag_coll)


Defines different set of tags

tag_coll table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
tag.tagcollid tag_tag2_fk R
tag_area.tagcollid tagarea_tag2_fk R
name VARCHAR 255 null
isdefault TINYINT 3 0
component VARCHAR 100 null
sortorder MEDIUMINT 7 0
searchable TINYINT 3 1

Whether the tag collection is searchable

customurl VARCHAR 255 null

Custom URL for the tag page instead of /tag/index.php

Table contained -1 rows

tag_coll table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

tag_coll table relationships