Tag Area Table Schema (tag_area)


Description

Defines various tag areas, one area is identified by component and itemtype

tag_area table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
component VARCHAR 100
itemtype VARCHAR 100
enabled BIT 1 1
tagcollid BIGINT 19 null
tag_coll.id tagarea_tag2_fk R
callback VARCHAR 100 √ null
callbackfile VARCHAR 100 √ null
showstandard BIT 1 0

Table contained -1 rows

tag_area table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
tagarea_comite_uix Must be unique Asc/Asc component + itemtype
tagarea_tag_ix Performance Asc tagcollid

tag_area table relationships

Close relationships within degrees of separation