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 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> | STOREENT_ID | Primary Key |
I0000240 | IDENTIFIER+MEMBER_ID | Unique Index |
I0000787 | MEMBER_ID | Non-Unique Index |
Constrained By Parent Tables:
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 |