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 Descriptions:

Name	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 as follows: G = StoreGroup S = Store
SETCCURR	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	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>	STOREENT_ID	Primary Key
I0000240	IDENTIFIER+MEMBER_ID	Unique Index
I0000787	MEMBER_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_789	SETCCURR	SETCURR	SETCCURR	Cascade
F_790	MEMBER_ID	MEMBER	MEMBER_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_1015	STOREENT_ID	MSGARCHIVE	STOREENT_ID	Cascade
F_1025	STOREENT_ID	MSGSTORE	STOREENT_ID	Cascade
F_1036	STOREENT_ID	EMLBOUNCED	STOREENT_ID	Cascade
F_1039	STOREENT_ID	EMLSTRPLCY	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_1053	STOREENT_ID	PX_COUPON	STOREENT_ID	Cascade
F_1056	STOREENT_ID	PX_USAGE	STOREENT_ID	Cascade
F_1081	STOREENT_ID	PX_TEMPLATE	STOREENT_ID	Cascade
F_1088	STOREENT_ID	ORDRELEASE	STOREENT_ID	Cascade
F_1102	STOREENT_ID	ATCHTGT	STOREENT_ID	Cascade
F_1107	STOREENT_ID	ATCHAST	STOREENT_ID	Cascade
F_1232	STOREENT_ID	PRCORSN	STOREENT_ID	Cascade
F_128	STOREENT_ID	BROADCAST	STOREENT_ID	Cascade
F_1500	STOREENT_ID	EXPERIMENT	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_313	STOREENT_ID	EMSPOT	STOREENT_ID	Cascade
F_325	STOREENT_ID	FLOWADMIN	STOREENT_ID	Cascade
F_3504	STOREENT_ID	ATTRDICT	STOREENT_ID	Cascade
F_3511	STOREENT_ID	ATTRDICTGRP	STOREENT_ID	Cascade
F_3553	STOREENT_ID	ATTR	STOREENT_ID	Cascade
F_3555	STOREENT_ID	ATTRVAL	STOREENT_ID	Cascade
F_3614	STOREENT_ID	WALLET	STOREENT_ID	Cascade
F_3618	STOREENT_ID	INSRULE	STOREENT_ID	Cascade
F_3630	STOREENT_ID	PRICERULE	STOREENT_ID	Cascade
F_3632	STOREENT_ID	PRELETEMPLATE	STOREENT_ID	Cascade
F_3636	STOREENT_ID	PREQUATION	STOREENT_ID	Cascade
F_3637	STOREENT_ID	PRCONSTANT	STOREENT_ID	Cascade
F_3642	STOREENT_ID	STORETPC	STOREENT_ID	Cascade
F_3650	STOREENT_ID	SUBSCRIPTION	STOREENT_ID	Cascade
F_3654	STOREENT_ID	SUBSCRTEMPLATE	STOREENT_ID	Cascade
F_3663	STOREENT_ID	CATFILTER	STOREENT_ID	Cascade
F_3678	STOREENT_ID	CMFEEDLOG	STOREENT_ID	Cascade
F_3686	STOREENT_ID	SRCHTERMASSOC	STOREENT_ID	Cascade
F_3697	STOREENT_ID	SEOPAGEDEF	STOREENT_ID	Cascade
F_3703	STOREENT_ID	SEOPAGEDEFSUBPARAM	STOREENT_ID	Cascade
F_3705	STOREENT_ID	SEOURLKEYWORD	STOREENT_ID	Cascade
F_3711	STOREENT_ID	SEOTOKENUSGTYPE	STOREENT_ID	Cascade
F_3715	STOREENT_ID	STOREDEFCAT	STOREENT_ID	Cascade
F_3716	STOREENT_ID	STORECONF	STOREENT_ID	Cascade
F_3718	STOREENT_ID	STOREPLTYPES	STOREENT_ID	Cascade
F_3720	STOREENT_ID	PAGELAYOUT	STOREENT_ID	Cascade
F_3724	STOREENT_ID	CATOVRGRP	STOREENT_ID	Cascade
F_3725	STOREENT_ID	STORECATOVRGRP	STOREENT_ID	Cascade
F_3727	STOREENT_ID	FOLDER	STOREENT_ID	No Action
F_3728	STOREENT_ID	FOLDERITEM	STOREENT_ID	Cascade
F_3730	STOREENT_ID	GEONODE	STOREENT_ID	Cascade
F_3731	STOREENT_ID	STLOC	STOREENT_ID	Cascade
F_3734	STOREENT_ID	FACETCATGRP	STOREENT_ID	Cascade
F_3746	STOREENT_ID	PLWIDGETDEF	STOREENT_ID	Cascade
F_3750	STOREENT_ID	PLSTOREWIDGET	STOREENT_ID	Cascade
F_3759	STOREENT_ID	PLPAGE	STOREENT_ID	Cascade
F_3763	STOREENT_ID	SRCHPROPRELV	STOREENT_ID	Cascade
F_3765	STOREENT_ID	PREVIEWTOKEN	STOREENT_ID	Cascade
F_3776	STOREENT_ID	CEDISPCTX	STOREENT_ID	Cascade
F_3780	STOREENT_ID	CEDYNDISPCTX	STOREENT_ID	Cascade
F_381	STOREENT_ID	IITEM	STOREENT_ID	Cascade
F_385	STOREENT_ID	INITIATIVE	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_478	STOREENT_ID	ONLOG	STOREENT_ID	Cascade
F_480	STOREENT_ID	ONQUEUE	STOREENT_ID	Cascade
F_507	STOREENT_ID	ORDERITEMS	STOREENT_ID	Cascade
F_517	STOREENT_ID	ORDERS	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_636	STOREENT_ID	PVCMDLSPEC	STOREENT_ID	Cascade
F_645	STOREENT_ID	QTYFORMAT	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
F_775	STOREENT_ID	STORE	STORE_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	STOREENT_ID	STOREGRP	STOREGRP_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
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_926	STOREENT_ID	REPDLVRY	STOREENT_ID	Cascade
F_956	STOREENT_ID	INTVSCHED	STOREENT_ID	Cascade
F_958	STOREENT_ID	EMLPROMO	STOREENT_ID	Cascade
F_965	STOREENT_ID	EMLCFG	STOREENT_ID	Cascade
F_967	STOREENT_ID	EMLUSRRECV	STOREENT_ID	Cascade
F_973	STOREENT_ID	EMLMSG	STOREENT_ID	Cascade
R_3447	STOREENT_ID	STQOTCFG	STOREENT_ID	Cascade
R_3448	STOREENT_ID	STORBLKRSN	STOREENT_ID	Cascade
R_3450	STOREENT_ID	ORDCHGRSN	STOREENT_ID	Cascade