Reference > Database > WebSphere Commerce database tables > C


WebSphere Commerce database table: COLLTYPE

This table defines all possible types of Collateral. Examples of Collateral types are image, flash and text.

Column Name Column Type Description
COLLTYPE_ID INTEGER NOT NULL The internal reference number of the Collateral Type.
NAME VARCHAR(254) The name of the Collateral Type.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030319020 COLLTYPE_ID Primary Key

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_248 COLLTYPE_ID COLLATERAL COLLTYPE_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search