Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: STOREDEF
Each row of this table contains default information for a Store.
Column Name Column Type Description STORE_ID INTEGER NOT NULL The Store. CONTRACT_ID BIGINT The default Contract for the Store. SHIPMODE_ID INTEGER The default ShippingMode for the Store. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030433690 STORE_ID Primary Key I0000785 CONTRACT_ID Non-Unique Index I0000786 SHIPMODE_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_788 CONTRACT_ID CONTRACT CONTRACT_ID Cascade F_787 SHIPMODE_ID SHIPMODE SHIPMODE_ID Cascade F_786 STORE_ID STORE STORE_ID Cascade
Related reference
_vcc_freeselect_bottom_