Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: STOREENT
Each row of this table represents a StoreEntity. A StoreEntity is an abstract superclass that can represent either a Store or a StoreGroup.
Column Name Column Type Description STOREENT_ID INTEGER NOT NULL Generated unique key. MEMBER_ID BIGINT NOT NULL The owner of the StoreEntity. TYPE CHAR(1) NOT NULL The kind of StoreEntity this row represents. Valid values are...
G = StoreGroup
S = StoreSETCCURR CHAR(3) The default currency for a StoreEntity that will be used by a customer who has not specified a preferred currency. This is a currency code as per ISO 4217 standards. If the currency code is NULL for a Store, the default currency is obtained from its StoreGroup. See also the STORELANG table. IDENTIFIER VARCHAR(254) NOT NULL A string that, together with MEMBER_ID, uniquely identifies the StoreEntity. MARKFORDELETE INTEGER NOT NULL DEFAULT 0 Indicates if the StoreEntity has been marked for deletion:
0 = No,
1 = Yes.OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000240 IDENTIFIER+MEMBER_ID Unique Index SQL100520030433830 STOREENT_ID Primary Key I0000787 MEMBER_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_790 MEMBER_ID MEMBER MEMBER_ID Cascade F_789 SETCCURR SETCURR SETCCURR Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_1107 STOREENT_ID ATCHAST STOREENT_ID Cascade F_1102 STOREENT_ID ATCHTGT STOREENT_ID Cascade F_3553 STOREENT_ID ATTR STOREENT_ID Cascade F_3504 STOREENT_ID ATTRDICT STOREENT_ID Cascade F_3511 STOREENT_ID ATTRDICTGRP STOREENT_ID Cascade F_3555 STOREENT_ID ATTRVAL STOREENT_ID Cascade F_128 STOREENT_ID BROADCAST STOREENT_ID Cascade F_152 STOREENT_ID CALCODE STOREENT_ID Cascade F_164 STOREENT_ID CALMETHOD STOREENT_ID Cascade F_177 STOREENT_ID CALSCALE STOREENT_ID Cascade F_182 STOREENT_ID CAMPAIGN STOREENT_ID Cascade F_233 STOREENT_ID CHARGETYPE STOREENT_ID Cascade F_236 STOREENT_ID CHKCMD STOREENT_ID Cascade F_243 STOREENT_ID CMDREG STOREENT_ID Cascade F_249 STOREENT_ID COLLATERAL STOREENT_ID Cascade F_265 STOREENT_ID CPPMN STOREENT_ID Cascade F_286 STOREENT_ID CURCONVERT STOREENT_ID Cascade F_289 STOREENT_ID CURCVLIST STOREENT_ID Cascade F_293 STOREENT_ID CURFORMAT STOREENT_ID Cascade F_296 STOREENT_ID CURLIST STOREENT_ID Cascade F_299 STOREENT_ID DISPCGPREL STOREENT_ID Cascade F_304 STOREENT_ID DISPENTREL STOREENT_ID Cascade F_1036 STOREENT_ID EMLBOUNCED STOREENT_ID Cascade F_965 STOREENT_ID EMLCFG STOREENT_ID Cascade F_973 STOREENT_ID EMLMSG STOREENT_ID Cascade F_958 STOREENT_ID EMLPROMO STOREENT_ID Cascade F_1039 STOREENT_ID EMLSTRPLCY STOREENT_ID Cascade F_967 STOREENT_ID EMLUSRRECV STOREENT_ID Cascade F_313 STOREENT_ID EMSPOT STOREENT_ID Cascade F_1500 STOREENT_ID EXPERIMENT STOREENT_ID Cascade F_325 STOREENT_ID FLOWADMIN STOREENT_ID Cascade F_381 STOREENT_ID IITEM STOREENT_ID Cascade F_385 STOREENT_ID INITIATIVE STOREENT_ID Cascade F_3618 STOREENT_ID INSRULE STOREENT_ID Cascade F_956 STOREENT_ID INTVSCHED STOREENT_ID Cascade F_388 STOREENT_ID INVADJCODE STOREENT_ID Cascade F_409 STOREENT_ID JURST STOREENT_ID Cascade F_412 STOREENT_ID JURSTGROUP STOREENT_ID Cascade F_415 STOREENT_ID LANGPAIR STOREENT_ID Cascade F_420 STOREENT_ID LMEVENTMAP STOREENT_ID Cascade F_421 STOREENT_ID LMSERVER STOREENT_ID Cascade F_439 STOREENT_ID MBRATTRVAL STOREENT_ID Cascade F_1015 STOREENT_ID MSGARCHIVE STOREENT_ID Cascade F_1025 STOREENT_ID MSGSTORE STOREENT_ID Cascade F_478 STOREENT_ID ONLOG STOREENT_ID Cascade F_480 STOREENT_ID ONQUEUE STOREENT_ID Cascade R_3450 STOREENT_ID ORDCHGRSN STOREENT_ID Cascade F_507 STOREENT_ID ORDERITEMS STOREENT_ID Cascade F_517 STOREENT_ID ORDERS STOREENT_ID Cascade F_1088 STOREENT_ID ORDRELEASE STOREENT_ID Cascade F_577 STOREENT_ID PAYMTHDSUP STOREENT_ID Cascade F_581 STOREENT_ID PAYSUMMARY STOREENT_ID Cascade F_608 STOREENT_ID POLICY STOREENT_ID Cascade F_1232 STOREENT_ID PRCORSN STOREENT_ID Cascade F_636 STOREENT_ID PVCMDLSPEC STOREENT_ID Cascade F_1053 STOREENT_ID PX_COUPON STOREENT_ID Cascade F_1042 STOREENT_ID PX_GROUP STOREENT_ID Cascade F_1043 STOREENT_ID PX_POLICY STOREENT_ID Cascade F_1048 STOREENT_ID PX_PROMOTION STOREENT_ID Cascade F_1081 STOREENT_ID PX_TEMPLATE STOREENT_ID Cascade F_1056 STOREENT_ID PX_USAGE STOREENT_ID Cascade F_645 STOREENT_ID QTYFORMAT STOREENT_ID Cascade F_926 STOREENT_ID REPDLVRY STOREENT_ID Cascade F_721 STOREENT_ID RTNDNYRSN STOREENT_ID Cascade F_722 STOREENT_ID RTNDSPCODE STOREENT_ID Cascade F_728 STOREENT_ID RTNREASON STOREENT_ID Cascade F_736 STOREENT_ID SCHCMD STOREENT_ID Cascade F_737 STOREENT_ID SCHCONFIG STOREENT_ID Cascade F_745 STOREENT_ID SHIPMODE STOREENT_ID Cascade F_765 STOREENT_ID STENCALUSG STOREENT_ID Cascade R_3448 STOREENT_ID STORBLKRSN STOREENT_ID Cascade F_775 STORE_ID STORE STOREENT_ID Cascade F_779 STOREENT_ID STORECAT STOREENT_ID Cascade F_780 STOREENT_ID STORECENT STOREENT_ID Cascade F_782 STOREENT_ID STORECGRP STOREENT_ID Cascade F_794 STOREENT_ID STOREENTDS STOREENT_ID Cascade F_795 STOREGRP_ID STOREGRP STOREENT_ID Cascade F_796 STOREENT_ID STOREITEM STOREENT_ID Cascade F_799 STOREENT_ID STORELANG STOREENT_ID Cascade F_805 STOREENT_ID STORITMFFC STOREENT_ID Cascade R_3447 STOREENT_ID STQOTCFG STOREENT_ID Cascade F_816 STOREENT_ID TAXCGRY STOREENT_ID Cascade F_885 STOREENT_ID TXCDCLASS STOREENT_ID Cascade F_901 STOREENT_ID VENDOR STOREENT_ID Cascade F_3614 STOREENT_ID WALLET STOREENT_ID Cascade
Related reference
- Ship data model
- Calculation usage data model
- Calculation scale data model
- Calculation rule - tax data model
- Calculation rule - shipping data model
- Calculation rule - discount data model
- Order trading agreement data model
- Payment summary data model
- LikeMinds data model
- Procurement data model
- Quantity unit data model
- Rule server configuration data model
- Store data model
- Tax type and category data model
- Vendor data model
- Order management - RMAitem data model
- Order item data model
- Order item - allocated data model
- Order item - backordered data model
- Order release data model
- Order tax data model
- Payment data model
- Interest item data model
- Jurisdiction data model
- Language data model
- Member data model
- Messaging data model
- Marketing layer data model
- Order data model
- Order adjustment data model
- Order management adjustment and tax data model
- Order management - receipt and disposition data model
- Calculation method data model
- Calculation rule data model
- Catalog data model
- Catalog entry data model
- Catalog group data model
- Command data model
- Collateral and promotions data model
- Currency data model
- E-coupon data model
- Fulfillment data model
- Access logging data model
- Calculation code data model
- Calculation code - direct attachment data model
- Calculation code - indirect attachment data model
- Contract data model
_vcc_freeselect_bottom_