This table identifies all the store relationship
types defined in HCL Commerce.
Column Descriptions:
Name | 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
-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 |
OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | STRELTYP_ID | Primary Key |
I0000267 | NAME | Unique Index |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
F_918 | STRELTYP_ID | STRELTYPDS | STRELTYP_ID | Cascade |
F_919 | STRELTYP_ID | STOREREL | STRELTYP_ID | Cascade |