STRELTYP

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

Column Descriptions:

NameTypeDescription
NAMECHAR (60)The name of the store relationship type. See the STRELTYP_ID column.
STRELTYP_IDINTEGER NOT NULLThe identifier of the store relationship type. The default relationship types are as follows: -1=com.ibm.commerce.businessPolicy -2=com.ibm.commerce.tax -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 -24=com.ibm.commerce.shipping.shipmode -25=com.ibm.commerce.shipping.shipjurisdiction -26=com.ibm.commerce.shipping.calculation -27=com.ibm.commerce.calculation -28=com.ibm.commerce.blockReasonCode -29=com.ibm.commerce.content -30=com.ibm.commerce.installment -31=com.ibm.commerce.pricerule -32=com.ibm.commerce.catalogfilter
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>STRELTYP_IDPrimary Key
I0000267NAMEUnique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_918STRELTYP_IDSTRELTYPDSSTRELTYP_IDCascade
F_919STRELTYP_IDSTORERELSTRELTYP_IDCascade