WebSphere Commerce database table: TAGDPLYREL

WebSphere Commerce database table: TAGDPLYREL

Stores the relationship between the TAGCLASS and TAGDISPLAY tables.

Column Descriptions
Column Name Column Type Description

TAGNAME VARCHAR(40) NOT NULL The name of the tag, reference key to the TAGCLASS table.

DISPLAYNAME VARCHAR(40) NOT NULL The display type defined for the related tag, reference key to the table TAGDISPLAY.

OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type

SQL060903235257880 TAGNAME+DISPLAYNAME Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type

F_1212 TAGNAME TAGCLASS TAGNAME Cascade

F_1213 DISPLAYNAME TAGDISPLAY DISPLAYNAME Cascade

Column Name	Column Type	Description
TAGNAME	VARCHAR(40) NOT NULL	The name of the tag, reference key to the TAGCLASS table.
DISPLAYNAME	VARCHAR(40) NOT NULL	The display type defined for the related tag, reference key to the table TAGDISPLAY.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1212	TAGNAME	TAGCLASS	TAGNAME	Cascade
F_1213	DISPLAYNAME	TAGDISPLAY	DISPLAYNAME	Cascade