WebSphere Commerce database table: COLLTYPE
This table defines all possible types of Collateral. Examples of Collateral types are image, flash and text.
Column Descriptions
| 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 |
| SQL060903235145280
| COLLTYPE_ID
| Primary Key
|
| Constraint Name
| Referenced Column Name
| Foreign Table Name
| Foreign Column Names
| Constraint Type |
| F_248
| COLLTYPE_ID
| COLLATERAL
| COLLTYPE_ID
| Cascade
|
Related reference