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 = 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 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:
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
Related reference
Access logging data model
Calculation code data model
Calculation code - direct attachment data model
Calculation code - indirect attachment data model
Calculation method data model
Calculation rule data model
Calculation rule - discount data model
Calculation rule - shipping data model
Calculation rule - tax data model
Calculation scale data model
Calculation usage data model
Catalog data model
Catalog entry data model
Catalog group data model
Command data model
Collateral and promotions data model
Contract data model
Currency data model
Folder data model
Fulfillment data model
Interest item data model
Jurisdiction data model
Language data model
Member data model
Messaging data model
Order data model
Order adjustment data model
Order management adjustment and tax data model
Order management - receipt and disposition 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 trading agreement data model
Order tax data model
Procurement data model
Quantity unit data model
Shipping data model
Store data model
Tax type and category data model
Vendor data model