WebSphere Commerce database table: STRELTYP

This table identifies all the store relationship types defined in WebSphere Commerce.


Column Description(s):
Column NameColumn TypeDescription
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(es):
Index NameIndexed Column NamesIndex Type
I0000267 NAME Unique Index
SQL050212031316530 STRELTYP_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_919 STRELTYP_ID STOREREL STRELTYP_ID Cascade
F_918 STRELTYP_ID STRELTYPDS STRELTYP_ID Cascade

Feedback