Tag Coll Table Schema (tag_coll)


Description

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

Close relationships within degrees of separation