This table identifies all the store relationship types defined in WebSphere Commerce.
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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000267 | NAME | Unique Index |
SQL050212031316530 | STRELTYP_ID | Primary Key |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_919 | STRELTYP_ID | STOREREL | STRELTYP_ID | Cascade |
F_918 | STRELTYP_ID | STRELTYPDS | STRELTYP_ID | Cascade |