Reference > Database > WebSphere Commerce database tables > P


WebSphere Commerce database table: PX_TEMPLATE

Reserved for IBM internal use.

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
SQL100520030418830 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

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

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search