Reference > Database > WebSphere Commerce database tables > Database schema changes


Database changes from v6 to v7

This topic describes the database schema changes between WebSphere Commerce v6 and WebSphere Commerce v7.0. The changes are grouped into the following sections:


Tables added since version 6


Tables removed since version 6

No tables were removed.


Deprecated tables

The following tables are deprecated:


Tables containing deprecated columns


Tables containing new columns


Tables containing changed columns


Indexes

Action Index Name Table Index Unique
Add I0001234 ACCCUSTEXC ACCCMDGRP_ID NON-UNIQUE
Add IPF00027 ACCOUNT UPPER(NAME) NON-UNIQUE
Add IPF00017 ATCHAST UPPER(ATCHASTPATH) NON-UNIQUE
Add I0001207 ATCHREL BIGINTOBJECT_ID Non-Unique
Add IPF00018 ATCHTGT UPPER(IDENTIFIER) NON-UNIQUE
Add I0001208 ATCHTGTDSC NAME Non-Unique
Add IPF00019 ATCHTGTDSC UPPER(NAME) NON-UNIQUE
Add I0001203 ATTR IDENTIFIER+ATTRDICT_ID Unique
Add I0001204 ATTR STOREENT_ID Non-Unique
Add I0001133 ATTRDICT STOREENT_ID UNIQUE
Add I0001134 ATTRDICTATTR IDENTIFIER+ATTRDICT_ID UNIQUE
Add I0001185 ATTRDICTATTR ATTRDICT_ID NON-UNIQUE
Add I0001186 ATTRDICTATTR STOREENT_ID NON-UNIQUE
Delete I0001186 ATTRDICTATTR STOREENT_ID Non-Unique
Delete I0001134 ATTRDICTATTR IDENTIFIER+ATTRDICT_ID Unique
Delete I0001185 ATTRDICTATTR ATTRDICT_ID Non-Unique
Add I0001138 ATTRDICTATTRDEF ATTRIBUTE_ID + LANGUAGE_ID UNIQUE
Delete I0001138 ATTRDICTATTRDEF ATTRIBUTE_ID+LANGUAGE_ID Unique
Add I0001135 ATTRDICTGRP IDENTIFIER+ATTRDICT_ID UNIQUE
Add I0001187 ATTRDICTGRP STOREENT_ID NON-UNIQUE
Add I0001188 ATTRDICTGRP ATTRDICT_ID NON-UNIQUE
Add I0001136 ATTRDICTGRPDESC NAME+LANGUAGE_ID NON-UNIQUE
Add I0001189 ATTRDICTGRPMBR ATTRDICTATTR_ID NON-UNIQUE
Delete I0001189 ATTRDICTGRPMBR ATTRDICTATTR_ID Non-Unique
Add I0001137 ATTRDICTGRPREL ATTRDICTGRP_CHILD UNIQUE
Add I0001183 ATTRIBUTESRC ATTRIBUTE_ID_SRC+LANGUAGE_ID_SRC+ATTRIBUTE_ID_TGT+LANGUAGE_ID_TGT UNIQUE
Add I0001191 ATTRIBUTESRC ATTRIBUTE_ID_TGT+LANGUAGE_ID_TGT NON-UNIQUE
Delete I0001183 ATTRIBUTESRC ATTRIBUTE_ID_SRC+LANGUAGE_ID_SRC+ATTRIBUTE_ID_TGT+LANGUAGE_IF_TGT Unque
Delete I0001191 ATTRIBUTESRC ATTRIBUTE_ID_TGT+LANGUAGE_ID_TGT Non-Unique
Add I0001190 ATTRTXNMY ATTRDICTATTR_ID NON-UNIQUE
Delete I0001190 ATTRTXNMY ATTRDICTATTR_ID Non-Unique
Add I0001205 ATTRVAL ATTR_ID+IDENTIFIER Unique
Add I0001206 ATTRVAL ATTR_ID_STOREENT_ID+VALUSAGE Non-Unique
Add I0001235 ATTRVALUE ATTACHMENT_ID NON-UNIQUE
Add I0001236 ATTRVALUE ATTRIBUTE_ID, LANGUAGE_ID NON-UNIQUE
Add I0001184 ATTRVALUESRC ATTRVALUE_ID_SRC+LANGUAGE_ID_SRC+ATTRVALUE_ID_TGT+LANGUAGE_ID_TGT UNIQUE
Add I0001192 ATTRVALUESRC ATTRVALUE_ID_TGT+LANGUAGE_ID_TGT NON-UNIQUE
Delete I0001184 ATTRVALUESRC ATTRVALUE_ID_SRC+LANGUAGE_ID_SRC+ATTRVALUE_ID_TGT+LANGUAGE_ID_TGT Unique
Delete I0001192 ATTRVALUESRC ATTRVALUE_ID_TGT+LANGUAGE_ID_TGT Non-Unique
Add I0001237 AUCTION AUCPAYINFO_ID NON-UNIQUE
Add I0001238 AUCTIONLOG AUCPAYINFO_ID NON-UNIQUE
Add I0001239 AUCTSTRREL AUCT_ID NON-UNIQUE
Add I0001240 AUTOBID AUCT_ID NON-UNIQUE
Add I0001241 AUTOBID AUCPAYINFO_ID NON-UNIQUE
Add I0001242 AUTOBIDLOG AUCPAYINFO_ID NON-UNIQUE
Add I0001243 BID AUCPAYINFO_ID NON-UNIQUE
Add I0001244 BID AUCT_ID NON-UNIQUE
Add I0001245 BIDLOG AUCPAYINFO_ID NON-UNIQUE
Add I0001246 BIDPAYMENT AUCPAYINFO_ID NON-UNIQUE
Add I0001104 BUSEVENT CHECKED  
Add I0001247 CALCODE TXCDCLASS_ID NON-UNIQUE
Add I0001196 CATENTDESC NAME+LANGUAGE_ID+PUBLISHED  
Add IPF00002 CATENTDESC UPPER(NAME) NON-UNIQUE
Add I0001248 CATENTDESC CATENTRY_ID NON-UNIQUE
Add IPF00003 CATENTRY UPPER(PARTNUMBER) NON-UNIQUE
Add IPF00020 CATENTRY UPPER(MFNAME) NON-UNIQUE
Add IPF00021 CATENTRY UPPER(MFPARTNUMBER) NON-UNIQUE
Add I0001202 CATENTRYATTR CATENTRY_ID+USAGE Non-Unique
Add IPF00001 CATGROUP UPPER(IDENTIFIER) NON-UNIQUE
Add IPF00022 CATGRPDESC UPPER(NAME) NON-UNIQUE
Add IPF00023 CATGRPDESC UPPER(SHORTDESCRIPTION) NON-UNIQUE
Add IPF00024 CMFILE UPPER(CMFILEPATH) NON-UNIQUE
Add IPF00008 COLLATERAL UPPER(NAME) NON-UNIQUE
Add I0001249 COLLDESC COLLATERAL_ID NON-UNIQUE
Add I0001250 CONTRLRULE CLASS_ID NON-UNIQUE
Add I0001251 CPPMN INITIATIVE_ID NON-UNIQUE
Add I0001252 CPPMNDISC CPPMN_ID NON-UNIQUE
Add I0001253 CSEDITATT PROFILE_ID NON-UNIQUE
Add I0001299 CTXMGMT LASTACCESSTIME NON-UNIQUE
Add I0001254 CURFMTDESC STOREENT_ID, SETCCURR, NUMBRUSG_ID NON-UNIQUE
Add I0001255 DKPDCCATENTREL CATENTRY_ID NON-UNIQUE
Add I0001256 DKPDCCOMPLIST CATENTRY_ID NON-UNIQUE
Add I0001141 DMACTIVITY NAME+STOREENT_ID UNIQUE
Add I0001142 DMACTIVITY STOREENT_ID NON-UNIQUE
Add I0001143 DMACTIVITY DMCAMPAIGN_ID NON-UNIQUE
Add I0001144 DMACTIVITY DMACTTYPE_ID NON-UNIQUE
Add I0001145 DMACTIVITY DMTEMPLATETYPE_ID NON-UNIQUE
Add I0001146 DMACTIVITY DMEXPTYPE_ID NON-UNIQUE
Add I0001193 DMACTIVITY STARTDATE NON-UNIQUE
Add IPF00012 DMACTIVITY UPPER(NAME) NON-UNIQUE
Add IPF00013 DMACTIVITY UPPER(DESCRIPTION) NON-UNIQUE
Add IPF00014 DMCAMPAIGH UPPER(NAME) NON-UNIQUE
Add I0001139 DMCAMPAIGN NAME+STOREENT_ID UNIQUE
Add I0001140 DMCAMPAIGN STOREENT_ID NON-UNIQUE
Add IPF00015 DMCAMPAIGN UPPER(DESCRIPTION) NON-UNIQUE
Add I0001149 DMELEMENT NAME+DMACTIVITY_ID UNIQUE
Add I0001150 DMELEMENT DMELETEMPLATE_ID+DMACTIVITY_ID NON-UNIQUE
Add I0001151 DMELEMENT DMACTIVITY_ID NON-UNIQUE
Add I0001194 DMELEMENTNVP NAME+VALUE NON-UNIQUE
Add I0001147 DMELETEMPLATE DMELEMENTTYPE_ID+NAME+STOREENT_ID UNIQUE
Add I0001148 DMELETEMPLATE STOREENT_ID NON-UNIQUE
Add I0001160 DMEMSPOTCMD CONTENTTYPE+STOREENT_ID+EMSPOT_ID UNIQUE
Add I0001161 DMEMSPOTCMD EMSPOT_ID NON-UNIQUE
Add I0001162 DMEMSPOTCMD DMEMSPOTORD_ID NON-UNIQUE
Add I0001163 DMEMSPOTDEF EMSPOT_ID+STOREENT_ID+CONTENTTYPE+CONTENT UNIQUE
Add I0001164 DMEMSPOTDEF STOREENT_ID NON-UNIQUE
Add I0001159 DMEMSPOTORD CONTENTTYPE+ORDERINGNAME UNIQUE
Add I0001158 DMEMSPOTPAGE DMPAGE_ID NON-UNIQUE
Add I0001155 DMEMSPOTSTATS EMSPOT_ID NON-UNIQUE
Add I0001200 DMEXPFAMILY FAMILY_ID Non-Unique
Add I0001198 DMEXPLOG STOREENT_ID+PERSONALIZATIONID+CREATED Non-Unique
Add I0001199 DMEXPLOG STOREENT_ID+EXPERIMENT_ID+TESTELEMENT_ID+CREATED Non-Unique
Add I0001233 DMMBRGRPPZN PERSONALIZATIONID NON-UNIQUE
Add I0001156 DMPAGE NAME+STOREENT_ID UNIQUE
Add I0001157 DMPAGE STOREENT_ID NON-UNIQUE
Add I0001152 DMTRIGLSTN NAME+STOREENT_ID NON-UNIQUE
Add I0001153 DMTRIGLSTN DMACTIVITY_ID NON-UNIQUE
Add I0001154 DMTRIGLSTN STOREENT_ID NON-UNIQUE
Add I0001195 DMTRIGSND TIMETOSEND NON-UNIQUE
Add IPF00004 EMLMSG UPPER(NAME) NON-UNIQUE
Add IPF00005 EMLMSG UPPER(DESCRIPTION) NON-UNIQUE
Add IPF00006 EMSPOT UPPER(NAME) NON-UNIQUE
Add IPF00007 EMSPOT UPPER(DESCRIPTION) NON-UNIQUE
Add I0001257 EXCHORDERS RMA_ID NON-UNIQUE
Add I0001258 FORUMMSG FORUM_ID NON-UNIQUE
Add I0001294 FORUMMSG PARENTMSG_ID NON-UNIQUE
Add I0001295 FORUMMSG ROOTMSG_ID NON-UNIQUE
Add I0001130 GEONDDS GEONODE_ID+LANGUAGE_ID  
Add I0001131 GEONDDS NAME  
Delete I0001130 GEONDDS GEONODE_ID+LANGUAGE_ID UNIQUE
Delete I0001131 GEONDDS NAME NON-UNIQUE
Add I0001216 GEONDDS GEONODE_ID+LANGUAGE_ID Unique
Add I0001129 GEONODE IDENTIFIER  
Delete I0001129 GEONODE IDENTIFIER UNIQUE
Add I0001215 GEONODE IDENTIFIER Unique
Add I0001132 GEOTREE CHILD_GEONODE_ID  
Delete I0001132 GEOTREE CHILD_GEONODE_ID UNIQUE
Add I0001217 GEOTREE CHILD_GEONODE_ID+PARENT_GEONODE_ID Unique
Add I0001218 GEOTREE PARENT_GEONODE_ID Non-Unique
Add IPF00028 GRADDR UPPER(FIRSTNAME) NON-UNIQUE
Add IPF00029 GRADDR UPPER(LASTNAME) NON-UNIQUE
Add I0001300 GRADDR SEARCHKEYLASTNAME NON-UNIQUE
Add I0001301 GRADDR SEARCHKEYFIRSTNAME NON-UNIQUE
Add I0001296 ICKNOWLEDG PARENTCONCEPTID NON-UNIQUE
Add I0001259 ICMETAFEAT METAPHORID NON-UNIQUE
Add I0001103 IDMDCACHE SCHEMANAME  
Delete I0001103 IDMDCACHE SCHEMANAME  
Add I0001223 INVAVL CATENTRY_ID, STORE_ID, STLOC_ID Unique
Add I0001224 INVAVL STORE_ID Non-Unique
Add I0001225 INVAVL STLOC_ID Non-Unique
Add I0001226 INVCNF IDENTIFIER Unique
Add I0001227 INVCNFREL CATENTRY_ID, STORE_ID, STLOC_ID Unique
Add I0001228 INVCNFREL STORE_ID Non-Unique
Add I0001229 INVCNFREL STLOC_ID Non-Unique
Add I0001260 INVRESERVE ITEMSPC_ID, STORE_ID, FFMCENTER_ID NON-UNIQUE
Add IPF00009 MBRGRP UPPER(MBRGRPNAME) NON-UNIQUE
Add I0001261 MBRVIEWPRF PREFERENCE NON-UNIQUE
Add I0001262 MERCHANT MEMBER_ID NON-UNIQUE
Add I0001230 MGPCONDELE NAME+MBRGRP_ID UNIQUE
Add I0001231 MGPCONDELE MBRGRP_ID NON-UNIQUE
Add I0001232 MGPCONDELENVP MGPCONDELE_ID NON-UNIQUE
Add I0001263 OICOMPLIST OICOMPREL_ID NON-UNIQUE
Add I0001264 ORCOMMENT ORDCHGRSN_ID NON-UNIQUE
Add I0001265 ORCOMMENT SERVICEREP_ID NON-UNIQUE
Add I0001266 ORDCHGRSN STOREENT_ID NON-UNIQUE
Drop I0001205 ORDERS MEMBER_ID+TYPE+STOREENT_ID  
Add I0001267 ORDERS BUYERPO_ID NON-UNIQUE
Add I0001268 ORDITEMCONF OICOMPLIST_ID NON-UNIQUE
Add I0001269 ORDITEMCONF MANIFEST_ID NON-UNIQUE
Add I0001270 PATTRVALUE ATTACHMENT_ID NON-UNIQUE
Add I0001271 PKGATTR ATTRIBUTE_ID, LANGUAGE_ID NON-UNIQUE
Add I0001272 PKGATTRVAL ATTRVALUE_ID, LANGUAGE_ID NON-UNIQUE
Add I0001273 POLICYTC POLICY_ID NON-UNIQUE
Add I0001107 PPCBATCH MERCHONF_ID  
Add I0001108 PPCBATCH STATE  
Add I0001103 PPCPAYTRAN PPCBATCH_ID  
Add I0001128 PSTLCDDS PSTLCODE_ID+LANGUAGE_ID  
Delete I0001128 PSTLCDDS PSTLCODE_ID+LANGUAGE_ID UNIQUE
Add I0001127 PSTLCODE POSTAL_ZIP_CODE  
Delete I0001127 PSTLCODE POSTAL_ZIP_CODE UNIQUE
Add I0001201 PX_ELEMENT PX_PROMOTION_ID+NAME Unique
Add I0001197 PX_ELEMENTNVP PX_ELEMENT_ID+NAME+VALUE Unique
Add I0001219 PX_PROMOAUTH ADMINSTVENAME Non-Unique
Add IPF00025 PX_PROMOAUTH ADMINSTVENAME NON-UNIQUE
Add I0001165 PX_PROMOCD PX_PROMOTION_ID+CODE Unique
Add I0001166 PX_PROMOCD CODE Non-Unique
Add IPF00016 PX_PROMOCD UPPER(CODE) NON-UNIQUE
Add I0001297 PX_RWDOPTION PX_PROMOTION_ID NON-UNIQUE
Add I0001298 PX_RWDOPTION ORDERS_ID NON-UNIQUE
Add I0001274 QTYFMTDESC STOREENT_ID, QTYUNIT_ID, NUMBRUSG_ID NON-UNIQUE
Add I0001275 RA VENDOR_ID NON-UNIQUE
Add I0001276 RECEIPT VENDOR_ID NON-UNIQUE
Add I0001277 RFQ TFTRADENG_ID NON-UNIQUE
Add I0001278 RFQPROD RFQCATEGRY_ID NON-UNIQUE
Add I0001279 RFQRSP TFTRADENG_ID NON-UNIQUE
Add I0001280 RMACHARGE CHARGETYPE_ID NON-UNIQUE
Add I0001281 RMAIDNYRSN RTNDNYRSN_ID NON-UNIQUE
Add I0001282 RMAITEM RTNREASON_ID NON-UNIQUE
Add I0001283 RMAITEMSERIAL RMAITEMCMP_ID NON-UNIQUE
Add I0001284 ROLEASNPRM ORGENTITY_ID NON-UNIQUE
Add I0001285 RTNRCPTDSP RTNDSPCODE_ID NON-UNIQUE
Add I0001286 RTNRCPTDSP RTNREASON_ID NON-UNIQUE
Add I0001121 SEBOOKING IDENTIFIER  
Add I0001122 SEBOOKING CUSTOMER_ID  
Delete I0001121 SEBOOKING IDENTIFIER UNIQUE
Delete I0001122 SEBOOKING CUSTOMER_ID NON-UNIQUE
Add I0001110 SECAT IDENTIFIER  
Add I0001111 SECAT CLASSIFICATION  
Delete I0001110 SECAT IDENTIFIER UNIQUE
Delete I0001111 SECAT CLASSIFICATION NON-UNIQUE
Add I0001112 SECATDESC SECAT_ID+LANGUAGE_ID  
Add I0001113 SECATDESC SHORTDESCRIPTION  
Delete I0001112 SECATDESC SETCAT_ID+LANGUAGE_ID UNIQUE
Delete I0001113 SECATDESC SHORTDESCRIPTION NON-UNIQUE
Add I0001114 SECATOWNERREL SECATOWNER_ID+SECAT_ID  
Delete I0001114 SECATOWNERREL STOREENT_ID + SECAT_ID UNIQUE
Update I0001114 SECATPWNERREL STOREENT_ID+SECAT_ID  
Add I0001120 SEDESC STOREEVENT_ID+LANGUAGE_ID  
Delete I0001120 SEDESC STOREEVENT_ID+LANGUAGE_ID UNIQUE
Add I0001119 SEOWNERREL SEOWNER_ID+STOREEVENT_ID  
Update I0001119 SEOWNERREL STOREENT_ID+STOREEVENT_ID  
Delete I0001119 SEOWNERREL STOREENT_ID+STOREEVENT_ID UNIQUE
Add I0001287 SHDCACRM SCHED_ID NON-UNIQUE
Add I0001102 SITE COMPNAME  
Add I0001220 STLFFMREL STLOC_ID, FMMCENTER_ID Unique
Add I0001221 STLFFMREL FFMCENTER_ID Non-Unique
Add I0001222 STLFFMREL ADDRESS_ID Non-Unique
Add I0001123 STLOC IDENTIFIER  
Delete I0001123 STLOC IDENTIFIER UNIQUE
Add I0001209 STLOC IDENTIFIER Unique
Add I0001210 STLOC LATITUDE+LONGITUDE Non-Unique
Add I0001211 STLOC GEONODE_ID Non-Unique
Add I0001124 STLOCATTR STLOC_ID+LANGUAGE_ID+NAME+VALUE  
Delete I0001124 STLOCATTR STLOC_ID+LANGUAGE_ID+NAME+VALUE UNIQUE
Add I0001212 STLOCATTR STLOC_ID+LANGUAGE_ID+NAME Non-Unique
Add I0001213 STLOCATTR VALUE Non-Unique
Delete I0001212 STLOCATTR STLOC_ID, LANGUAGE_ID, NAME NON-UNIQUE
Add I0001212 STLOCATTR STLOC_ID, NAME, LANGUAGE_ID UNIQUE
Add I0001125 STLOCDS STLOC_ID+LANGUAGE_ID  
Add I0001126 STLOCDS NAME  
Delete I0001125 STLOCDS STLOC_ID+LANGUAGE_ID UNIQUE
Delete I0001126 STLOCDS NAME NON-UNIQUE
Add I0001214 STLOCDS STLOC_ID+LANGUAGE_ID Unique
Add IPF00026 STORE UPPER(DIRECTORY) NON-UNIQUE
Add I0001288 STORE STOREGRP_ID NON-UNIQUE
Add I0001115 STOREEVENT IDENTIFIER  
Add I0001116 STOREEVENT STARTTIME  
Add I0001117 STOREEVENT LOCATION  
Add I0001118 STOREEVENT ENDTIME  
Drop I0001117 STOREEVENT LOCATION  
Delete I0001115 STOREEVENT IDENTIFIER UNIQUE
Delete I0001116 STOREEVENT STARTTIME NON-UNIQUE
Delete I0001118 STOREEVENT ENDTIME NON-UNIQUE
Add I0001117 STORELOCFFMREL STLOC_ID+FFMCENTER_ID  
Delete I0001117 STORELOCFFMREL FFMCENTER_ID Unique
Add I0001289 STOREMERCH MERCHANT_ID NON-UNIQUE
Add I0001290 STORLANGDS LANGUAGE_ID_DESC, STOREENT_ID NON-UNIQUE
Add I0001291 TFEXTENG TFALGOREG_ID NON-UNIQUE
Add I0001292 TRDATTACH ATTACHMENT_ID NON-UNIQUE
Add I0001105 USERPWDHST USERS_ID+PASSWORDCREATION  
Add I0001109 USERS PERSONALIZATIONID  
Add I0001293 VERSIONSPC ITEMVERSN_ID NON-UNIQUE


Relationships

Action ConstraintName Table Column Foreign Table Foreign Column Constraint Type
Add f_3551 ATTR ATTRTYPE_ID ATTRTYPE ATTRTYPE_ID Cascade
Add f_3552 ATTR ATTRDICT_ID ATTRDICT ATTRDICT_ID Cascade
Add f_3553 ATTR STOREENT_ID STOREENT STOREENT_ID Cascade
Add f_3556 ATTRDESC ATTR_ID ATTR ATTR_ID Cascade
Add f_3557 ATTRDESC ATTRTYPE_ID ATTRTYPE ATTRTYPE_ID Cascade
Add f_3558 ATTRDESC LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Add f_3559 ATTRDESC QTYUNIT_ID QTYUNIT QTYUNIT_ID Cascade
Add f_3504 ATTRDICT STOREENT_ID STOREENT STOREENT_ID Cascade
Add f_3505 ATTRDICTATTR ATTRDICT_ID ATTRDICT ATTRDICT_ID Cascade
Add f_3507 ATTRDICTATTR STOREENT_ID STOREENT STOREENT_ID Cascade
Delete f_3505 ATTRDICTATTR ATTRDICT_ID ATTRDICT ATTRDICT_ID Cascade
Delete f_3507 ATTRDICTATTR STOREENT_ID STOREENT STOREENT_ID Cascade
Add f_3510 ATTRDICTATTRDEF ATTRDICTATTR_ID ATTRDICTATTR ATTRDICTATTR_ID Cascade
Add f_3522 ATTRDICTATTRDEF ATTRIBUTE_ID + LANGUAGE_ID ATTRIBUTE ATTRIBUTE_ID + LANGUAGE_ID Cascade
Delete R_3510 ATTRDICTATTRDEF ATTRDICTATTR_ID ATTRDICTATTR ATTRDICTATTR_ID Cascade
Delete f_3522 ATTRDICTATTRDEF ATTRIBUTE_ID+LANGUAGE_ID ATTRIBUTE ATTRIBUTE_ID+LANGUAGE_ID Cascade
Add f_3506 ATTRDICTGRP ATTRDICT_ID ATTRDICT ATTRDICT_ID Cascade
Add f_3511 ATTRDICTGRP STOREENT_ID STOREENT STOREENT_ID Cascade
Add f_3564 ATTRDICTGRPATTRREL ATTRDICTGRP_ID ATTRDICTGRP ATTRDICTGRP_ID Cascade
Add f_3565 ATTRDICTGRPATTRREL ATTR_ID ATTR ATTR_ID Cascade
Add f_3512 ATTRDICTGRPDESC ATTRDICTGRP_ID ATTRDICTGRP ATTRDICTGRP_ID Cascade
Add f_3517 ATTRDICTGRPDESC LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Add f_3515 ATTRDICTGRPMBR ATTRDICTGRP_ID ATTRDICTGRP ATTRDICTGRP_ID Cascade
Add f_3508 ATTRDICTGRPMBR ATTRDICTATTR_ID ATTRDICTATTR ATTRDICTATTR_ID Cascade
Delete f_3508 ATTRDICTGRPMBR ATTRDICTATTR_ID ATTRDICTATTR ATTRDICTATTR_ID Cascade
Delete f_3515 ATTRDICTGRPMBR ATTRDICTGRP_ID ATTRDICTGRP ATTRDICTGRP_ID Cascade
Add f_3513 ATTRDICTGRPREL ATTRDICTGRP_PARENT ATTRDICTGRP ATTRDICTGRP_ID Cascade
Add f_3514 ATTRDICTGRPREL ATTRDICTGRP_CHILD ATTRDICTGRP ATTRDICTGRP_ID Cascade
Add f_3518 ATTRIBUTESRC ATTRIBUTE_ID_SRC + LANGUAGE_ID_SRC ATTRIBUTE ATTRIBUTE_ID + LANGUAGE_ID Cascade
Add f_3519 ATTRIBUTESRC ATTRIBUTE_ID_TGT + LANGUAGE_ID_TGT ATTRIBUTE ATTRIBUTE_ID + LANGUAGE_ID Cascade
Delete f_3518 ATTRIBUTESRC ATTRIBUTE_ID_SRC+LANGUAGE_ID_SRC ATTRIBUTE ATTRIBUTE_ID+LANGUAGE_ID Cascade
Delete f_3519 ATTRIBUTESRC ATTRIBUTE_ID_TGT+LANGUAGE_ID_TGT ATTRIBUTE ATTRIBUTE_ID+LANGUAGE_ID Cascade
Add f_3516 ATTRTXNMY CATGROUP_ID CATGROUP CATGROUP_ID Cascade
Add f_3509 ATTRTXNMY ATTRDICTATTR_ID ATTRDICTATTR ATTRDICTATTR_ID Cascade
Delete f_3509 ATTRTXNMY ATTRDICTATTR_ID ATTRDICTATTR ATTRDICTATTR_ID Cascade
Delete f_3516 ATTRTXNMY CATGROUP_ID CATGROUP CATGROUP_ID Cascade
Add f_3554 ATTRVAL ATTR_ID ATTR ATTR_ID Cascade
Add f_3555 ATTRVAL STOREENT_ID STOREENT STOREENT_ID Cascade
Add f_3560 ATTRVALDESC ATTRVAL_ID ATTRVAL ATTRVAL_ID Cascade
Add f_3561 ATTRVALDESC LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Add f_3562 ATTRVALDESC ATTR_ID+LANGUAGE_ID ATTRDESC ATTR_ID+LANGUAGE_ID Cascade
Add f_3563 ATTRVALDESC QTYUNIT_ID QTYUNIT QTYUNIT_ID Cascade
Add f_3520 ATTRVALUESRC ATTRVALUE_ID_SRC + LANGUAGE_ID_SRC ATTRVALUE ATTRVALUE_ID + LANGUAGE_ID Cascade
Add f_3521 ATTRVALUESRC ATTRVALUE_ID_TGT + LANGUAGE_ID_TGT ATTRVALUE ATTRVALUE_ID + LANGUAGE_ID Cascade
Delete f_3520 ATTRVALUESRC ATTRVALUE_ID_SRC+LANGUAGE_ID_SRC ATTRVALUE ATTRVALUE_ID+LANGUAGE_ID Cascade
Delete f_3521 ATTRVALUESRC ATTRVALUE_ID_TGT+LANGUAGE_ID_TGT ATTRVALUE ATTRVALUE_ID+LANGUAGE_ID Cascade
Add f_3566 CATENTRYATTR CATENTRY_ID CATENTRY CATENTRY_ID Cascade
Add f_3567 CATENTRYATTR ATTR_ID ATTR ATTR_ID Cascade
Add f_3568 CATENTRYATTR ATTRVAL_ID ATTRVAL ATTRVAL_ID Cascade
Add f_3523 DMACTIVITY DMCAMPAIGN_ID DMCAMPAIGN DMCAMPAIGN_ID Cascade
Add f_3524 DMACTIVITY DMACTTYPE_ID DMACTTYPE DMACTTYPE_ID Cascade
Add f_3525 DMACTIVITY DMTEMPLATETYPE_ID DMTEMPLATETYPE DMTEMPLATETYPE_ID Cascade
Add f_3526 DMACTIVITY DMEXPTYPE_ID DMEXPTYPE DMEXPTYPE_ID Cascade
Add f_3528 DMELEMENT DMELETEMPLATE_ID DMELETEMPLATE DMELETEMPLATE_ID Cascade
Add f_3529 DMELEMENT DMACTIVITY_ID DMACTIVITY DMACTIVITY_ID Cascade
Add f_3532 DMELEMENTNVP DMELEMENT_ID DMELEMENT DMELEMENT_ID Cascade
Add f_3527 DMELETEMPLATE DMELEMENTTYPE_ID DMELEMENTTYPE DMELEMENTTYPE_ID Cascade
Add f_3535 DMEMSPOTCMD DMEMSPOTORD_ID DMEMSPOTORD DMEMSPOTORD_ID Cascade
Add f_3536 DMEMSPOTCMD EMSPOT_ID EMSPOT EMSPOT_ID Cascade
Add f_3537 DMEMSPOTDEF EMSPOT_ID EMSPOT EMSPOT_ID Cascade
Add f_3533 DMEMSPOTPAGE DMPAGE_ID DMPAGE DMPAGE_ID Cascade
Add f_3534 DMEMSPOTPAGE EMSPOT_ID EMSPOT EMSPOT_ID Cascade
Add f_3550 DMEXPFAMILY DMACTIVITY_ID DMACTIVITY DMACTIVITY_ID Cascade
Add f_3592 DMMBRGRPPZN MBRGRP_ID MBRGRP MBRGRP_ID Cascade
Add f_3530 DMTRIGLSTN DMACTIVITY_ID DMACTIVTY DMACTIVITY_ID Cascade
Add f_3531 DMTRIGLSTN DMELEMENT_ID DMELEMENT DMELEMENT_ID Cascade
Add f_3495 GEONDDS GEONODE_ID GEONODE GEONODE_ID Cascade
Add f_3496 GEONDDS LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Delete f_3495 GEONDDS GEONODE_ID GEONODE GEONODE_ID Cascade
Delete f_3496 GEONDDS LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Add f_3574 GEONDDS GEONODE_ID GEONODE GEONODE_ID Cascade
Add f_3575 GEONDDS LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Add f_3497 GEOTREE PARENT_GEONODE_ID GEONODE GEONODE_ID Cascade
Add f_3498 GEOTREE CHILD_GEONODE_ID GEONODE GEONODE_ID Cascade
Delete f_3497 GEOTREE PARENT_GEONODE_ID GEONODE GEONODE_ID Cascade
Delete f_3498 GEOTREE CHILD_GEONODE_ID GEONODE GEONODE_ID Cascade
Add f_3576 GEOTREE CHILD_GEONODE_ID GEONODE GEONODE_ID Cascade
Add f_3577 GEOTREE PARENT_GEONODE_ID GEONODE GEONODE_ID Cascade
Add f_3581 INVAVL CATENTRY_ID CATENTRY CATENTRY_ID Cascade
Add f_3582 INVAVL STORE_ID STORE STORE_ID Cascade
Add f_3583 INVAVL STLOC_ID STLOC STLOC_ID Cascade
Add f_3584 INVAVL QUANTITYMEASURE QTYUNIT QTYUNIT_ID Cascade
Add f_3585 INVCNF QUANTITYMEASURE QTYUNIT QTYUNIT_ID Cascade
Add f_3586 INVCNFREL CATENTRY_ID CATENTRY CATENTRY_ID Cascade
Add f_3587 INVCNFREL STORE_ID STORE STORE_ID Cascade
Add f_3588 INVCNFREL STLOC_ID STLOC STLOC_ID Cascade
Add f_3589 INVCNFREL INVCNF_ID INVCNF INVCNF_ID Cascade
Add f_3590 MGPCONDELE MBRGRP_ID MBRGRP MBRGRP_ID Cascade
Add f_3591 MGPCONDELENVP MGPCONDELE_ID MGPCONDELE MGPCONDELE_ID Cascade
Add f_3477 PPCBATCH MERCHCONF_ID MERCHCONF MERCHCONF_ID cascade
Add f_3479 PPCEXTDATA PPCBATCH_ID PPCBATCH PPCBATCH_ID Cascade
Add f_3478 PPCPAYTRAN PPCBATCH_ID PPCBATCH PPCBATCH_ID Cascade
Add f_3493 PSTLCDDS LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Add f_3494 PSTLCDDS PSTLCODE_ID PSTLCODE PSTLCODE_ID Cascade
Delete f_3493 PSTLCDDS LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Delete f_3494 PSTLCDDS PSTLCODE_ID PSTLCODE PSTLCODE_ID Cascade
Add f_3548 PX_DESCRIPTION PX_PROMOTION_ID PX_PROMOTION PX_PROMOTION_ID Cascade
Add f_3549 PX_DESCRIPTION LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Add f_3546 PX_ELEMENT PX_PROMOTION_ID PX_PROMOTION PX_PROMOTION_ID Cascade
Add f_3547 PX_ELEMENTNVP PX_ELEMENT_ID PX_ELEMENT PX_ELEMENT_ID Cascade
Add f_3545 PX_PROMOAUDIT PX_PROMOTION_ID PX_PROMOTION PX_PROMOTION_ID Cascade
Add f_3544 PX_PROMOAUTH PX_PROMOTION_ID PX_PROMOTION PX_PROMOTION_ID Cascade
Add f_3538 PX_PROMOCD PX_PROMOTION_ID PX_PROMOTION PX_PROMOTION_ID Cascade
Add f_3593 PX_RWDOPTION PX_PROMOTION_ID PX_PROMOTION PX_PROMOTION_ID Cascade
Add f_3594 PX_RWDOPTION ORDERS_ID ORDERS ORDERS_ID Cascade
Add f_3487 SEBOOKING STOREEVENT_ID STOREEVENT STOREEVENT_ID Cascade
Delete f_3487 SEBOOKING STOREEVENT_ID STOREEVENT STOREEVENT_ID Cascade
Add f_3480 SECATDESC SECAT_ID SECAT SECAT_ID Cascade
Add f_3481 SECATDESC LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Delete f_3480 SECATDESC SECAT_ID SECAT SECAT_ID Cascade
Delete f_3481 SECATDESC LANGUAAGE_ID LANGUAGE LANGUAGE_ID Cascade
Add f_3482 SECATOWNERREL SECAT_ID SECAT SECAT_ID Cascade
Add f_3499 SECATOWNERREL STOREENT_ID STOREENT STOREENT_ID Cascade
Delete f_3482 SECATOWNERREL SECAT_ID SECAT SECAT_ID Cascade
Delete f_3499 SECATOWNERREL STOREENT_ID STOREENT STOREENT_ID Cascade
Add f_3485 SEDESC LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Add f_3486 SEDESC STOREEVENT_ID STOREEVENT STOREEVENT_ID Cascade
Delete f_3485 SEDESC LANGUAAGE_ID LANGUAGE LANGUAGE_ID Cascade
Delete f_3486 SEDESC STOREEVENT_ID STOREEVENT STOREEVENT_ID Cascade
Add f_3484 SEOWNERREL STOREEVENT_ID STOREEVENT STOREEVENT_ID Cascade
Add f_3500 SEOWNERREL STOREENT_ID STOREENT STOREENT_ID Cascade
Delete f_3484 SEOWNERREL STOREEVENT_ID STOREEVENT STOREEVENT_ID Cascade
Delete f_3500 SEOWNERREL STOREENT_ID STOREENT STOREENT_ID Cascade
Add f_3578 STLFFMREL STLOC_ID STLOC STLOC_ID Cascade
Add f_3579 STLFFMREL FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade
Add f_3580 STLFFMREL ADDRESS_ID ADDRESS ADDRESS_ID Cascade
Add f_3488 STLOC GEONODE_ID GEONODE GEONODE_ID Cascade
Delete f_3488 STLOC GEONODE_ID GEONODE GEONODE_ID Cascade
Add f_3569 STLOC GEONODE_ID GEONODE GEONODE_ID Cascade
Add f_3489 STLOCATTR STLOC_ID STLOC STLOC_ID Cascade
Add f_3490 STLOCATTR LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Delete f_3489 STLOCATTR STLOC_ID STLOC STLOC_ID Cascade
Delete f_3490 STLOCATTR LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Add f_3570 STLOCATTR STLOC_ID STLOC STLOC_ID Cascade
Add f_3571 STLOCATTR LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Add f_3491 STLOCDS STLOC_ID STLOC STLOC_ID Cascade
Add f_3492 STLOCDS LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Delete f_3491 STLOCDS STLOC_ID STLOC STLOC_ID Cascade
Delete f_3492 STLOCDS LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Add f_3572 STLOCDS STLOC_ID STLOC STOLOC_ID Cascade
Add f_3573 STLOCDS LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Add f_3483 STOREEVENT SECAT_ID SECAT SECAT_ID Cascade
Delete f_3483 STOREEVENT SECAT_ID SECAT SECAT_ID Cascade
Add f_3501 STORELOCFFMREL FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade
Add f_3502 STORELOCFFMREL ADDRESS_ID ADDRESS ADDRESS_ID Cascade
Add f_3503 STORELOCFFMREL STLOC_ID STLOC STLOC_ID Cascade
Delete f_3501 STORELOCFFMREL FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade
Delete f_3502 STORELOCFFMREL ADDRESS_ID ADDRESS ADDRESS_ID Cascade
Add f_3476 USERPWDHST USERS_ID USERREG USERS_ID Cascade


+

Search Tips   |   Advanced Search