Reference > Database > WebSphere Commerce database tables > S

WebSphere Commerce database table: STRELTYP

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... -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
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
I0000267	NAME	Unique Index
SQL100520030435620	STRELTYP_ID	Primary Key

Referenced By

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

• Store data model

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search