WebSphere Commerce database table: STRELTYP
This table identifies all the store relationship types defined in WebSphere Commerce.
Column Descriptions
| Column Name
| Column Type
| Description |
| NAME
| CHAR(60)
| The name of the store relationship type. See the STRELTYP_ID column.
|
| STRELTYP_ID
| INTEGER NOT NULL
| The identifier of the store relationship type. The default relationship types are as follows:
-1=com.ibm.commerce.businessPolicy
-3=com.ibm.commerce.campaigns
-4=com.ibm.commerce.catalog
-5=com.ibm.commerce.command
-6=com.ibm.commerce.hostedStore
-7=com.ibm.commerce.price
-8=com.ibm.commerce.referral
-9=com.ibm.commerce.segmentation
-10=com.ibm.commerce.URL
-11=com.ibm.commerce.view
-13=com.ibm.commerce.inventory
-14=com.ibm.commerce.storeitem
-15=com.ibm.commerce.channelStore
-16=com.ibm.commerce.propertyFiles
-17=com.ibm.commerce.currency.conversion
-18=com.ibm.commerce.currency.format
-19=com.ibm.commerce.currency.supported
-20=com.ibm.commerce.currency.countervalue
-21=com.ibm.commerce.measurement.format
-22=com.ibm.commerce.contract
-23=com.ibm.commerce.promotion
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|
Indexes
| Index Name
| Indexed Column Names
| Index Type |
| I0000267
| NAME
| Unique Index
|
| SQL060903235256610
| STRELTYP_ID
| Primary Key
|
| Constraint Name
| Referenced Column Name
| Foreign Table Name
| Foreign Column Names
| Constraint Type |
| F_919
| STRELTYP_ID
| STOREREL
| STRELTYP_ID
| Cascade
|
| F_918
| STRELTYP_ID
| STRELTYPDS
| STRELTYP_ID
| Cascade
|
Related reference