WebSphere Commerce database table: PX_TEMPLATE

Reserved for IBM internal use.

Column Descriptions

Column Name	Column Type	Description
PX_TEMPLATE_ID	INTEGER NOT NULL	Reserved for IBM internal use.
STOREENT_ID	INTEGER NOT NULL	Reserved for IBM internal use.
NAME	VARCHAR(64) NOT NULL	Reserved for IBM internal use.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
I0000420	STOREENT_ID+NAME	Unique Index
SQL060903235239540	PX_TEMPLATE_ID	Primary Key

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1081	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Constraint Name	Referenced Column Name	Foreign Table Name	Foreign Column Names	Constraint Type
F_1082	PX_TEMPLATE_ID	PX_TPLTGRP	PX_TEMPLATE_ID	Cascade