Database schema changes from Version 7 to Version 8

Database tables and columns within the WebSphere Commerce Version 8.0 database schema can differ from the tables and columns in the database schema for WebSphere Commerce Version 7.

Tables that are added since Version 7

Tables added in WebSphere Commerce Version 8
Tables added with WebSphere Commerce Version 7 Feature Pack 8
Tables added with WebSphere Commerce Version 7 Feature Pack 6
Tables added with WebSphere Commerce Version 7 Feature Pack 4
Tables added with WebSphere Commerce Version 7 Fix Pack 9
Tables added with WebSphere Commerce Version 7 Fix Pack 7

Tables that are changed since Version 7

Tables that are changed with WebSphere Commerce Version 7 Fix Pack 7
Tables that are changed with WebSphere Commerce Version 7 Fix Pack 2

Tables that are removed since Version 7

  • SRCHSTATS - Removed with WebSphere Commerce Version 7 Feature Pack 3

Deprecated tables

For the list of deprecated database tables, see Deprecated tables and columns.

Tables that include new columns

Columns introduced in WebSphere Commerce Version 8
Columns introduced with WebSphere Commerce Version 7 Feature Pack 7
Columns introduced with WebSphere Commerce Version 7 Feature Pack 6
Columns introduced with WebSphere Commerce Version 7 Fix Pack 9
Columns introduced with WebSphere Commerce Version 7 Fix Pack 7
Columns introduced with WebSphere Commerce Version 7 Fix Pack 6
Columns introduced with WebSphere Commerce Version 7 Fix Pack 5
Columns introduced with WebSphere Commerce Version 7 Fix Pack 3
Columns introduced with WebSphere Commerce Version 7 Fix Pack 2

Tables that include changed columns

Columns that are changed with WebSphere Commerce Version 8
Columns that are changed with WebSphere Commerce Version 7 Feature Pack 7
Columns that are changed with WebSphere Commerce Version 7 Feature Pack 6
Columns that are changed with WebSphere Commerce Version 7 Fix Pack 8
Columns that are changed with WebSphere Commerce Version 7 Fix Pack 7
Columns that are changed with WebSphere Commerce Version 7 Fix Pack 5
Columns that are changed with WebSphere Commerce Version 7 Fix Pack 2
Columns that are changed with WebSphere Commerce Version 7 Fix Pack 1

Tables that include new or changed indexes

Indexes that are new or changed with WebSphere Commerce Version 8
Table Action Index name Index Uniqueness
PAGELAYOUT Delete I0001443 NAME + MEMBER_ID Unique
Delete I0001444 NAME + STOREENT_ID Unique
Add I0001443 NAME + MEMBER_ID + MANAGINGTOOL Unique
Add I0001444 NAME + STOREENT_ID + MANAGINGTOOL Unique
PLLOCSTATIC Add I0001523 PAGELAYOUT_ID Unique
PLPROPERTY Add I0001524 NAME + VALUE + PAGELAYOUT_ID Unique
PX_PROMOTION Add I0001525 STATUS + CDREQUIRED + TYPE + STARTDATE + ENDDATE Non-unique
Indexes that are new or changed with WebSphere Commerce Version 7 Feature Pack 8
Table Action Index name Index Uniqueness
CATGRPRULE Add I0001520 DMACTIVITY_ID Non-unique
Indexes that are new or changed with WebSphere Commerce Version 7 Feature Pack 7
Table Action Index name Index Uniqueness
EXPRESSION Add I0001517 TRADING_ID Non-unique
Add I0001518 CATFILTER_ID Non-unique
PLLOCATION Add I0001496 PAGELAYOUT_ID + DMACTIVITY_ID Unique
Add I0001497 DMACTIVITY_ID Non-unique
PLPAGE Add I0001492 ADMINNAME + MEMBER_ID Unique
Add I0001493 ADMINNAME + STOREENT_ID Unique
Add I0001494 STOREENT_ID + PAGELAYOUTTYPE_ID Non-unique
Add I0001495 PAGELAYOUTTYPE_ID Non-unique
PLSTOREWIDGET Add I0001512 PLWIDGETDEF_ID + STOREENT_ID Unique
Add I0001513 STOREENT_ID Non-unique
PLTEMPLATEREL Add I0001509 TEMPLATE_ID Non-unique
PLWIDGET Add I0001489 PAGELAYOUT_ID + ADMINNAME Unique
Add I0001514 PLWIDGETDEF_ID Non-unique
PLWIDGETDEF Add I0001488 IDENTIFIER + STOREENT_ID Unique
Add I0001511 STOREENT_ID Non-unique
PLWIDGETNVP Add I0001491 NAME + VALUE + PLWIDGET_ID Unique
Add I0001519 PLWIDGET_ID Non-unique
PLWIDGETREL Add I0001516 PLWIDGET_ID_PARENT Non-unique
PLWIDGETSLOT Add I0001490 PAGELAYOUT_ID + ADMINNAME Unique
Add I0001515 PLWIDGET_ID Non-unique
Indexes that are new or changed with WebSphere Commerce Version 7 Feature Pack 6
Table Action Index name Index Uniqueness
COLLIMGMAPAREA Add I0001485 COLLATERAL_ID + LANGUAGE_ID + COORDINATES Unique
Add I0001486 LANGUAGE_ID Non-unique
DMEMSPOTCOLLDEF Add I0001483 EMSPOT_ID + STOREENT_ID + COLLATERAL_ID Unique
Add I0001484 COLLATERAL_ID Non-unique
PX_CDPOOL Delete I0001313 CODE + STORE_ID Unique
Add I0001313 CODE + STORE_ID + INTERNAL_ID Unique
SRCHATTRDESC Add I0001487 LANGUAGE_ID Non-unique
Add IPF00034 UP_DISPLAYNAME Non-unique
Add IPF00035 UP_DESCRIPTION Non-unique
SRCHPROPRELV Add I0001498 INDEXFIELD + CATGROUP_ID + STOREENT_ID + CATALOG_ID Unique
Add I0001499 CATALOG_ID Non-unique
Add I0001503 STOREENT_ID Non-unique
Add I0001504 CATGROUP_ID + STOREENT_ID + CATALOG_ID Non-unique
Indexes that are new or changed with WebSphere Commerce Version 7 Feature Pack 5
Table Action Index name Index Uniqueness
ATTRDICTSRCHCONF Add I0001471 ATTR_ID Non-unique
Add I0001472 ATTRTYPE_ID Non-unique
Add I0001473 MASTERCATALOG_ID Non-unique
CATENTDESCOVR Add I0001446 CATENTRY_ID + LANGUAGE_ID + CATOVRGRP_ID Unique
Add I0001447 LANGUAGE_ID Non-unique
Add I0001448 CATOVRGRP_ID Non-unique
Add I0001449 CATENTRY_ID + CATOVRGRP_ID Non-unique
Add IPF00031 UP_NAME Non-unique
CATOVRGRP Add I0001450 IDENTIFIER + MEMBER_ID Unique
Add I0001451 STOREENT_ID Non-unique
IPF00032 UP_IDENTIFIER Non-unique
FACET Add I0001476 ATTR_ID Non-unique
Add I0001477 SRCHATTR_ID Non-unique
Add I0001478 STOREENT_ID + KEYWORD_SEARCH Non-unique
FACETCATGRP Add I0001479 FACET_ID + CATGROUP_ID + STOREENT_ID Unique
Add I0001480 STOREENT_ID Non-unique
Add I0001481 CATGROUP_ID Non-unique
FACETDESC Add I0001482 LANGUAGE_ID Non-unique
FOLDER Add I0001453 PARENTFOLDER_ID + TYPE + IDENTIFIER + STOREENT_ID + MEMBER_ID + Unique
Add I0001454 STOREENT_ID + IDENTIFIER Non-unique
IPF00033 UP_IDENTIFIER Non-unique
FOLDERITEM Add I0001455 FOLDERITEMTYPE Non-unique
Add I0001456 FOLDER_ID + FOLDERITEMTYPE + REFERENCE_ID Unique
Add I0001461 STOREENT_ID Non-unique
PAGELAYOUT Add I0001443 NAME + MEMBER_ID Unique
Add I0001444 NAME + STOREENT_ID Unique
Add I0001445 STOREENT_ID + PAGELAYOUTTYPE_ID Not uniuqe
Add IPF00030 UP_NAME Non-unique
SRCHATTR Add I0001474 INDEXTYPE Non-unique
SRCHATTRPROP Add I0001475 PROPERTYNAME + PROPERTYVALUE Non-unique
STORECATOVRGRP Add I0001452 STOREENT_ID Non-unique
STOREDEFCAT Add I0001439 STOREENT_ID + CATALOG_ID Non-unique
Add I0001440 CATALOG_ID Non-unique
Indexes that are new or changed with WebSphere Commerce Version 7 Feature Pack 4
Table Action Index name Index Uniqueness
CLIENTLOCATION Add I0001438 MODIFICATIONTIME + CREATIONTIME Non-unique
POIDESC Add I0001437 POINTOFINTEREST_ID + LANGUAGE_ID Unique
POINTOFINTEREST Add I0001434 PROGRAM_ID + STORE_ID + IDENTIFIER Unique
Add I0001435 PROGRAM_ID + STORE_ID + POITYPE + LATITUDE + LONGITUDE + ALTITUDE Non-unique
Add I0001436 PROGRAM_ID + STORE_ID + POITYPE + REGION_ID + ZONE_ID + CELL_ID + POINT_ID Unique
Indexes that are new or changed with WebSphere Commerce Version 7 Feature Pack 3
Table Action Index name Index Uniqueness
CMEXTDATA Add I0001431 CMPRMYOBJ_ID Non-unique
Add I0001432 ATTRIBUTENAME + ATTRIBUTEVALUE + CMPRMYOBJ_ID Non-unique
CMPRMYOBJ Add I0001416 WORKSPACE + TASKGRP + NOUN + OBJECT_ID + STOREENT_ID Unique
Add I0001418 STATUS + LASTUPDATE Non-unique
Add I0001419 LASTUPDATE + NOUN + STOREENT_ID + WORKSPACE + ACTION + SOURCE Non-unique
Add I0001427 NOUN + OBJECT_ID Non-unique
Add I0001428 STOREENT_ID Non-unique
OICONFIG Add I0001412 ORDERITEMS_ID Unique
SEOPAGEDEF Add I0001409 PAGENAME + STOREENT_ID Unique
Add I0001410 STOREENT_ID Non-unique
SEOPAGEDEFDESC Add I0001411 LANGUAGE_ID Non-unique
SEOPAGEDEFOVR Add I0001413 SEOPAGEDEF_ID + OBJECTTYPE + OBJECT_ID Unique
SEOPAGEDEFSUBPARAM Add I0001415 STOREENT_ID Non-unique
SEOREDIRECT Add I0001414 SEOURLKWD_ID_NEW Non-unique
Add I0001424 SEOURLKWD_ID_ORIG Non-unique
SEOTOKENUSGTYPE Add I0001425 TOKENUSGTYPE + STOREENT_ID Unique
Add I0001426 STOREENT_ID Non-unique
SEOURL Add I0001429 TOKENVALUE + TOKENNAME + SEOURL_ID Unique
SEOURLKEYWORD Add I0001417 URLKEYWORD + STOREENT_ID Unique
Add I0001420 SEOURL_ID Non-unique
Add I0001421 STOREENT_ID Non-unique
Add I0001430 LANGUAGE_ID Non-unique
Add I0001433 MOBILEURLKEYWORD + STOREENT_ID Non-unique
SRCHCONFEXT Add I0001422 INDEXSCOPE + INDEXTYPE + LANGUAGE + INDEXSUBTYPE Unique
Add I0001423 LANGUAGE_ID Non-unique
SRCHSTAT Add I0001391 KEYWORD + LANGUAGE_ID + STOREENT_ID + KEYWORDCOUNT + LOGDATE + SEARCHCOUNT + SUGGESTION Non-unique
Add I0001392 STOREENT_ID + LOGDATE Non-unique
SRCHSTATS Delete I0001391 Non-unique
Delete I0001392 STOREENT_ID Non-unique
Indexes that are new or changed with WebSphere Commerce Version 7 Feature Pack 2
Table Action Index name Index Uniqueness
CATENTSUBS Add I0001358 SUBSCPTYPE_ID Non-unique
CATFILTER Add I0001373 STOREENT_ID + IDENTIFIER + CATALOG_ID Unique
Add I0001374 STOREENT_ID + CATALOG_ID Non-unique
Add I0001375 CATALOG_ID Non-unique
CFCATGROUP Add I0001379 CATFILTER_ID + CATGROUP_ID Unique
Add I0001387 CATGROUP_ID Non-unique
CFCOND Add I0001380 CFCONDGRP_ID Non-unique
Add I0001381 ATTR_ID Non-unique
CFCONDGRP Add I0001378 CFCATGROUP_ID + IDENTIFIER Unique
CFCONDVAL Add I0001382 CFCOND_ID Non-unique
Add I0001383 ATTRVAL_ID Non-unique
Add I0001394 LANGUAGE_ID Non-unique
CFPRODUCTSET Add I0001376 CATFILTER_ID + PRODUCTSET_ID Unique
Add I0001377 PRODUCTSET_ID Non-unique
Add I0001395 CATFILTER_ID Non-unique
CMFEEDLOG Add I0001390 FEED_ID + STOREENT_ID Non-unique
Add I0001393 FEED_ID + STOREENT_ID + FEEDRECORD_ID Unique
DKOFFERADJMNT Add I0001407 KIT_ID Non-unique
Add I0001408 CATENTRY_ID Non-unique
ORDERREL Add I0001354 PARENTORDER_ID + CHILDORDER_ID Unique
Add I0001355 PARENTORDERITEM_ID + CHILDORDER_ID Unique
Add I0001356 CHILDORDER_ID Non-unique
PRCONSTANT Add I0001351 IDENTIFIER + STOREENT_ID Unique
Add I0001352 STOREENT_ID Non-unique
Add I0001353 TYPE Non-unique
PRELEMENT Add I0001345 IDENTIFIER + PRICERULE_ID Unique
Add I0001346 PRELETEMPLATE_ID + PRICERULE_ID Non-unique
Add I0001347 PRICERULE_ID Non-unique
PRELEMENTATTR Add I0001348 NAME + VALUE Non-unique
PRELETEMPLATE Add I0001343 PRELETPLTGRP_ID + IDENTIFIER + STOREENT_ID Unique
Add I0001344 STOREENT_ID Non-unique
PREQENTRY Add I0001359 PREQUATION_ID Non-unique
Add I0001385 PREQENTRYTYPE_ID Non-unique
PREQENTRYTYPE Add I0001386 IDENTIFIER Unique
PREQUATION Add I0001349 IDENTIFIER + STOREENT_ID Unique
Add I0001350 STOREENT_ID Non-unique
PRICERULE Add I0001340 IDENTIFIER + STOREENT_ID Unique
Add I0001341 STOREENT_ID Non-unique
Add I0001342 TYPE Non-unique
SRCHATTR Add I0001403 INDEXSCOPE + INDEXTYPE + IDENTIFIER Unique
SRCHSTATS Add I0001391 SRCHTERM + STOREENT_ID Unique
Add I0001392 STOREENT_ID Non-unique
SRCHTERM Add I0001400 TERM Non-unique
Add I0001401 TYPE Non-unique
Add I0001402 SRCHTERMASSOC_ID Non-unique
SRCHTERMASSOC Add I0001396 STOREENT_ID Non-unique
Add I0001397 LANGUAGE_ID Non-unique
Add I0001398 SCOPE Non-unique
Add I0001399 STATUS Non-unique
STORETPC Add I0001357 TRADEPOSCN_ID Non-unique
Add I0001388 STTPCUSG_ID Non-unique
SUBSCRIPTION Add I0001360 CATENTRY_ID Non-unique
Add I0001361 ORDERS_ID Non-unique
Add I0001362 STOREENT_ID Non-unique
Add I0001363 MEMBER_ID Non-unique
Add I0001364 SUBSCPTYPE_ID Non-unique
Add I0001365 SUBSCRTEMPLATE_ID Non-unique
Add I0001384 ORDERITEMS_ID + ORDERS_ID Unique
Add I0001404 FFMFREQ_UOM Non-unique
Add I0001405 PAYMENTFREQ_UOM Non-unique
Add I0001406 TIMEPERIOD_UOM Non-unique
SUBSCRRENEW Add I0001372 SUBSCRIPTION_ID Non-unique
SUBSCRSCHJOBS Add I0001371 SUBSCRIPTION_ID Non-unique
SUBSCRSUSPEND Add I0001366 SUBSCRIPTION_ID + SUSPENDSTARTDATE Unique
SUBSCRTEMPLATE Add I0001367 STOREENT_ID Non-unique
Add I0001368 MEMBER_ID Non-unique
Add I0001369 CATENTRY_ID Non-unique
SUBSCRTMPLITEMLIST Add I0001370 CATENTRY_ID Non-unique
Indexes that are new or changed with WebSphere Commerce Version 7 Feature Pack 1
Table Action Index name Index Uniqueness
DMRANKINGITEM Add I0001302 DMELEMENT_ID + STOREENT_ID + OBJECT_ID + GROUP_ID Unique
DMRANKINGSTAT Add I0001303 STOREENT_ID + DMELEMENT_ID + GROUP_ID + TIMECREATED Non-unique
FILEPROCREL Add I0001312 PROCESSFILE_ID Non-unique
INSRULE Add I0001326 STOREENT_ID + NAME Unique
INSRULECATENT Add I0001330 INSRULE_ID + CATENTRY_ID Non-unique
Add I0001331 CATENTRY_ID Non-unique
INSRULECATGRP Add I0001327 INSRULECATGRP_ID + INSRULE_ID Non-unique
Add I0001328 INSRULE_ID Non-unique
Add I0001329 CATGROUP_ID Non-unique
INSRULECOND Add I0001333 INSRULE_ID Non-unique
INSRULEINSOPT Add I0001334 INSRULE_ID Non-unique
Add I0001335 CURRENCY Non-unique
INSRULEPAYMTHD Add I0001332 INSRULEPAYMTHD Non-unique
PROCESSFILE Add I0001311 MEMBER_ID Non-unique
PX_CDPOOL Add I0001313 CODE + STORE_ID Non-unique
Add I0001314 STORE_ID Non-unique
PX_CDPROMO Add I0001315 PX_CDPOOL_ID + PX_PROMOTION_ID Unique
Add I0001316 PX_PROMOTION_ID Non-unique
PX_CDUSAGE Add I0001317 PX_CDPOOL_ID Non-unique
Add I0001318 OWNER_ID Non-unique
Add I0001319 ORDERS_ID Non-unique
Add I0001320 STATUS Non-unique
UPLOADFILE Add I0001308 UPLOADTYPE + STORE_ID + OBJECTID Non-unique
Add I0001309 MEMBER_ID Non-unique
Add I0001310 STORE_ID Non-unique
WALLET Add I0001322 STOREENT_ID + MEMBER_ID + NAME Unique
Add I0001323 MEMBER_ID Non-unique
WALLETITEM Add I0001324 WALLET_ID + TYPE + NAME + CREATIONDATE Non-unique
WIREL Add I0001325 WALLETITEM_ID_CHD Non-unique
Indexes that are new or changed with WebSphere Commerce Version 7 Fix Pack 9
Table Action Index name Index Uniqueness
ADDRESS Add I0001521 EMAIL1 Non-unique
ORDAUDIT Add I0001522 TIMEPLACED Non-unique
Indexes that are new or changed with WebSphere Commerce Version 7 Fix Pack 8
Table Action Index name Index Uniqueness
CONTRACT Add I0001510 FAMILY_ID Non-unique
Indexes that are new or changed with WebSphere Commerce Version 7 Fix Pack 7
Table Action Index name Index Uniqueness
PREVIEWTOKEN Add I0001506 STOREENT_ID Non-unique
Add I0001507 ENDDATE + STATUS Non-unique
ORDERS Add I0001508 STATUS + LASTUPDATE Non-unique
Indexes that are new or changed with WebSphere Commerce Version 7 Fix Pack 6
Table Action Index name Index Uniqueness
ATTR Add I0001464 FACETABLE Non-unique
ATTRDESC Add I0001465 LANGUAGE_ID Non-unique
Add I0001466 ATTRTYPE_ID Non-unique
Add I0001467 QTYUNIT_ID Non-unique
ATTRVALDESC Add I0001468 LANGUAGE_ID Non-unique
Add I0001469 ATTR_ID Non-unique
Add I0001470 QTYUNIT_ID Non-unique
CATENTRYATTR Add I0001462 ATTRVAL_ID Non-unique
Add I0001463 ATTR_ID Non-unique
GEONODE Delete I0001215 IDENTIFIER Unique
Add I0001459 STOREENT_ID + IDENTIFIER Unique
STLOC Delete I0001209 IDENTIFIER Unique
Add I0001460 STOREENT_ID + IDENTIFIER Unique
Indexes that are new or changed with WebSphere Commerce Version 7 Fix Pack 5
Table Action Index name Index Uniqueness
CMFTGTSKREL Add I0001441 CMFTASKGRP_ID Non-unique
CMFWSTGREL Add I0001442 CMFTASKGRP_ID Non-unique

No indexes are new or changed with WebSphere Commerce Version 7 Fix Pack 4

No indexes are new or changed with WebSphere Commerce Version 7 Fix Pack 3

No indexes are new or changed with WebSphere Commerce Version 7 Fix Pack 2

Indexes that are new or changed with WebSphere Commerce Version 7 Fix Pack 1
Table Action Index name Index Uniqueness
GRGFTREG Delete GR_INDEX2 POSTEVENTADDRESS_ID Unique
Add GR_INDEX2 POSTEVENTADDRESS_ID Non-unique
Delete GR_INDEX3 PREVENTADDRESS_ID Unique
Add GR_INDEX3 PREVENTADDRESS_ID Non-unique

Table relationships that are new or changed

Table relationships that are new or changed with WebSphere Commerce Version 8
Table Column Action Constraint name Foreign table Foreign column Constraint type
PLLOCSTATIC PLLOCSTATIC_ID Add P_0033 Primary key
PAGELAYOUT_ID Add F_3771 PAGELAYOUT PAGELAYOUT_ID Cascade
PLPROPERTY PLPROPERTY_ID Add P_0034 Primary key
PAGELAYOUT_ID Add F_3772 PAGELAYOUT PAGELAYOUT_ID Cascade
Table relationships that are new or changed with WebSphere Commerce Version 7 Feature Pack 8
Table Column Action Constraint name Foreign table Foreign column Constraint type
CATGRPRULE CATGROUP_ID, DMACTIVITY_ID Add P_0031 Primary key
CATGROUP_ID Add F_3770 CATGROUP CATGROUP_ID Cascade
Table relationships that are new or changed with WebSphere Commerce Version 7 Feature Pack 7
Table Column Action Constraint name Foreign table Foreign column Constraint type
EXPRESSION EXPRESSION_ID Add P_0030 Primary key
TRADING_ID Add F_3768 TRADING TRADING_ID Cascade
CATFILTER_ID Add F_3769 CATFILTER CATFILTER_ID Cascade
PLLOCATION PLLOCATION_ID Add P_0026 Primary key
PAGELAYOUT_ID Add F_3760 PAGELAYOUT PAGELAYOUT_ID Cascade
DMACTIVITY_ID Add F_3761 DMACTIVITY DMACTIVITY_ID Cascade
PLPAGE PLPAGE_ID Add P_0025 Primary key
PAGELAYOUTTYPE_ID Add F_3758 PAGELAYOUTTYPE PAGELAYOUTTYPE_ID Cascade
STOREENT_ID Add F_3759 STOREENT STOREENT_ID Cascade
PLSTOREWIDGET PLSTOREWIDGET_ID Add P_0020 Primary key
PLWIDGETDEF_ID Add F_3749 PLWIDGETDEF PLWIDGETDEF_ID Cascade
STOREENT_ID Add F_3750 STOREENT STOREENT_ID Cascade
PLTEMPLATEREL PAGELAYOUT_ID Add P_0029 Primary key
PAGELAYOUT_ID Add F_3766 PAGELAYOUT PAGELAYOUT_ID Cascade
TEMPLATE_ID Add F_3767 PAGELAYOUT PAGELAYOUT_ID Cascade
PLWIDGET PLWIDGET_ID Add P_0021 Primary key
PLWIDGETDEF_ID Add F_3751 PLWIDGETDEF PLWIDGETDEF_ID Cascade
PAGELAYOUT_ID Add F_3752 PAGELAYOUT PAGELAYOUT_ID Cascade
PLWIDGETDEF PLWIDGETDEF_ID Add P_0018 Primary key
STOREENT_ID Add F_3746 STOREENT STOREENT_ID Cascade
PLWIDGETDEFDESC PLWIDGETDEF_ID, LANGUAGE_ID Add P_0019 Primary key
PLWIDGETDEF_ID Add F_3747 PLWIDGETDEF PLWIDGETDEF_ID Cascade
LANGUAGE_ID Add F_3748 LANGUAGE LANGUAGE_ID Cascade
PLWIDGETNVP PLWIDGETNVP_ID Add P_0023 Primary key
PLWIDGET_ID Add F_3755 PLWIDGET PLWIDGET_ID Cascade
PLWIDGETREL PLWIDGET_ID_CHILD Add P_0024 Primary key
PLWIDGET_ID_PARENT Add F_3756 PLWIDGET PLWIDGET_ID Cascade
PLWIDGET_ID_CHILD Add F_3757 PLWIDGET PLWIDGET_ID Cascade
PLWIDGETSLOT PLWIDGETSLOT_ID Add P_0022 Primary key
PAGELAYOUT_ID Add F_3753 PAGELAYOUT PAGELAYOUT_ID Cascade
PLWIDGET_ID Add F_3754 PLWIDGET PLWIDGET_ID Cascade
Table relationships that are new or changed with WebSphere Commerce Version 7 Feature Pack 6
Table Column Action Constraint name Foreign table Foreign column Constraint type
COLLIMGMAPAREA COLLIMGMAPAREA_ID Add P_0016 Primary key
COLLATERAL_ID Add F_3742 COLLATERAL COLLATERAL_ID Cascade
LANGUAGE_ID Add F_3743 LANGUAGE LANGUAGE_ID Cascade
DMEMSPOTCOLLDEF DMEMSPOTCOLLDEF_ID Add P_0015 Primary key
EMSPOT_ID Add F_3740 EMSPOT EMSPOT_ID Cascade
COLLATERAL_ID Add F_3741 COLLATERAL COLLATERAL_ID Cascade
FOLDER PARENTFOLDER_ID Delete F_3739 FOLDER FOLDER_ID Cascade
SRCHATTRDESC SRCHATTR_ID, LANGUAGE_ID Add P_0017 Primary key
SRCHATTR_ID Add F_3744 SRCHATTR SRCHATTR_ID Cascade
LANGUAGE_ID Add F_3745 LANGUAGE LANGUAGE_ID Cascade
SRCHPROPRELV SRCHPROPRELV_ID Add P_0027 Primary key
CATALOG_ID Add F_3762 CATALOG CATALOG_ID Cascade
STOREENT_ID Add F_3763 STOREENT STOREENT_ID Cascade
CATGROUP_ID Add F_3764 CATGROUP CATGROUP_ID Cascade
Table relationships that are new or changed with WebSphere Commerce Version 7 Feature Pack 5
Table Column Action Constraint name Foreign table Foreign column Constraint type
CATENTDESCOVR CATENTDESCOVR_ID Add P_0006 Primary key
CATENTRY_ID Add F_3721 CATENTRY CATENTRY_ID Cascade
LANGUAGE_ID Add F_3722 LANGUAGE LANGUAGE_ID Cascade
CATOVRGRP_ID Add F_3723 CATOVRGRP CATOVRGRP_ID Cascade
CATOVRGRP CATOVRGRP_ID Add P_0007 Primary key
STOREENT_ID Add F_3724 STOREENT STOREENT_ID Cascade
FACET FACET_ID Add P_0012 Primary key
ATTR_ID Add F_3732 ATTR ATTR_ID Cascade
SRCHATTR_ID Add F_3733 SRCHATTR SRCHATTR_ID Cascade
FACETCATGRP FACETCATGRP_ID Add P_0013 Primary key
STOREENT_ID Add F_3734 STOREENT STOREENT_ID Cascade
CATGROUP_ID Add F_3735 CATGROUP CATGROUP_ID Cascade
FACET_ID Add F_3736 FACET FACET_ID Cascade
FACETDESC FACET_ID + LANGUAGE_ID Add P_0014 Primary key
FACET_ID Add F_3737 FACET FACET_ID Cascade
LANGUAGE_ID Add F_3738 LANGUAGE LANGUAGE_ID Cascade
FOLDER FOLDER_ID Add P_0009 Primary key
STOREENT_ID Add F_3727 STOREENT STOREENT_ID Cascade
PARENTFOLDER_ID Add F_3739 FOLDER FOLDER_ID Cascade
FOLDERITEM FOLDERITEM_ID Add P_0010 Primary key
STOREENT_ID Add F_3728 STOREENT STOREENT_ID Cascade
FOLDER_ID Add F_3729 FOLDER FOLDER_ID Cascade
PAGELAYOUT PAGELAYOUT_ID Add P_0005 Primary key
PAGELAYOUTTYPE_ID Add F_3719 PAGELAYOUTTYPE PAGELAYOUTTYPE_ID Cascade
STOREENT_ID Add F_3720 STOREENT STOREENT_ID Cascade
PAGELAYOUTTYPE PAGELAYOUTTYPE_ID Add P_0003 Primary key
STORECATOVRGRP CATOVRGRP_ID Add F_3726 CATOVRGRP CATOVRGRP_ID Cascade
CATOVRGRP_ID + STOREENT_ID Add P_0008 Primary key
STOREENT_ID Add F_3725 STOREENT STOREENT_ID Cascade
STOREDEFCAT STOREDEFCAT_ID Add P_0001 Primary key
CATALOG_ID Add F_3714 CATALOG CATALOG_ID Cascade
STOREENT_ID Add F_3715 STOREENT STOREENT_ID Cascade
STOREPLTYPES PAGELAYOUTTYPE_ID + STOREENT_ID Add P_0004 Primary key
PAGELAYOUTTYPE_ID Add F_3717 PAGELAYOUTTYPE PAGELAYOUTTYPE_ID Cascade
STOREENT_ID Add F_3718 STOREENT STOREENT_ID Cascade
Table relationships that are new or changed with WebSphere Commerce Version 7 Feature Pack 4
Table Column Action Constraint name Foreign table Foreign column Constraint type
CLIENTLOCATION CLIENTLOCATION_ID Add Primary key
POIDESC POIDESC_ID Add Primary key
POINTOFINTEREST_ID Add f_3713 POINTOFINTEREST POINTOFINTEREST_ID Cascade
POINTOFINTEREST POINTOFINTEREST_ID Add Primary key
STORECONF STOREENT_ID + NAME Add P_002 Primary key
STOREENT_ID Add F_3716 STOREENT STOREENT_ID Cascade
Table relationships that are new or changed with WebSphere Commerce Version 7 Feature Pack 3
Table Column Action Constraint name Foreign table Foreign column Constraint type
CMEXTDATA CMEXTDATA_ID Add Primary key
CMPRMYOBJ_ID Add F_3707 CMPRMYOBJ CMPRMYOBJ_ID Cascade
CMPRMYOBJ CMPRMYOBJ_ID Add Primary key
OICONFIG OICONFIG_ID Add Primary key
ORDERITEMS_ID Add F_3712 ORDERITEMS ORDERITEMS_ID Cascade
SEOPAGEDEF SEOPAGEDEF_ID Add Primary key
STOREENT_ID Add F_3697 STOREENT STOREENT_ID Cascade
SEOPAGEDEFDESC SEOPAGEDEF_ID + LANGUAGE_ID Add Primary key
SEOPAGEDEF_ID Add F_3698 SEOPAGEDEF SEOPAGEDEF_ID Cascade
LANGUAGE_ID Add F_3699 LANGUAGE LANGUAGE_ID Cascade
SEOPAGEDEFOVR SEOPAGEDEFOVR_ID Add Primary key
SEOPAGEDEF_ID Add F_3700 SEOPAGEDEF SEOPAGEDEF_ID Cascade
SEOPAGEDEFSUBPARAM SUBPARAMNAME + STOREENT_ID Add Primary key
STOREENT_ID Add F_3703 STOREENT STOREENT_ID Cascade
SEOREDIRECT SEODIRECT_ID Add Primary key
SEOURLKWD_ID_NEW Add F_3701 SEOURLKEYWORD SEOURLKEYWORD_ID Cascade
SEOURLKWD_ID_ORIG Add F_3702 SEOURLKEYWORD SEOURLKEWORD_ID Cascade
SEOREDIRECTTRAFFIC SEOREDIRECT_ID Add Primary key
SEOREDIRECT_ID Add F_3708 SEOREDIRECT SEOREDIRECT_ID Cascade
SEOTOKENUSGTYPE TOKENUSGTYPE_ID Add Primary key
STOREENT_ID Add F_3711 STOREENT STOREENT_ID Cascade
SEOURL SEOURL_ID Add Primary key
SEOURLKEYWORD SEOURLKEYWORD_ID Add Primary key
SEOURL_ID Add F_3704 SEOURL SEOURL_ID Cascade
STOREENT_ID Add F_3705 STOREENT STOREENT_ID Cascade
LANGUAGE_ID Add F_3706 LANGUAGE LANGUAGE_ID Cascade
SRCHCONFEXT SRCHCONFEXT_ID Add Primary key
LANGUAGE_ID Add F_3709 LANGUAGE LANGUAGE_ID Cascade
INDEXTYPE + INDEXSCOPE Add F_3710 SRCHCONF INDEXTYPE + INDEXSCOPE Cascade
SRCHSTAT SRCHSTAT_ID Add Primary key
SRCHSTATS SRCHSTATS_ID Delete Primary key
STOREENT_ID Delete F_3696 STOREENT STOREENT_ID Cascade
Table relationships that are new or changed with WebSphere Commerce Version 7 Feature Pack 2
Table Column Action Constraint name Foreign table Foreign column Constraint type
ATTRDICTSRCHCONF MASTERCATALOG_ID Add F_3679 CATALOG CATALOG_ID Cascade
ATTRDICTSRCHCNF_ID Add Primary key
ATTR_ID Add F_3680 ATTR ATTR_ID Cascade
ATTRTYPE_ID Add F_3681 ATTRTYPE ATTRTYPE_ID Cascade
CATENTSUBS CATENTRY_ID Add Primary key
CATENTRY_ID Add F_3644 CATENTRY CATENTRY_ID Cascade
SUBSCPTYPE_ID Add F_3645 SUBSCPTYPE SUBSCPTYPE_ID Cascade
CATFLTDSC CATFILTER_ID + LANGUAGE_ID Add Primary key
CATFILTER_ID Add F_3664 CATFILTER CATFILTER_ID Cascade
LANGUAGE_ID Add F_3665 LANGUAGE LANGUAGE_ID Cascade
CATFILTER STOREENT_ID Add F_3663 STOREENT STOREENT_ID Primary key
CATFILTER_ID Add Primary key
CATALOG_ID Add F_3662 CATALOG CATALOG_ID Cascade
CFCATGROUP CFCATGROUP_ID Add Primary key
CATFILTER_ID Add F_3669 CATFILTER CATFILTER_ID Cascade
CATGROUP_ID Add F_3674 CATGROUP CATGROUP_ID Cascade
CFCOND CFCOND_ID Add Primary key
ATTR_ID Add F_3670 ATTR ATTR_ID Cascade
CFCONDGRP_ID Add F_3671 CFCONDGRP CFCONDGRP_ID Cascade
CFCONDGRP CFCONDGRP_ID Add Primary key
CFCATGROUP_ID Add F_3668 CFCATGROUP CFCATGROUP_ID Cascade
CFCONDVAL CFCONDVAL_ID Add Primary key
ATTRVAL_ID Add F_3672 ATTRVAL ATTRVAL_ID Cascade
CFCOND_ID Add F_3673 CFCOND CFCOND_ID Cascade
LANGUAGE_ID Add F_3685 LANGUAGE LANGUAGE_ID Cascade
CFPRODUCTSET CFPRODUCTSET_ID Add Primary key
CATFILTER_ID Add F_3666 CATFILTER CATFILTER_ID Cascade
PRODUCTSET_ID Add F_3667 PRODUCTSET PRODUCTSET_ID Cascade
CLSATTRSRCHCONF CLSATTRSRCHCONF_ID Add Primary key
ATTRTYPE_ID Add F_3680 ATTRTYPE ATTRTYPE_ID Cascade
MASTERCATALOG_ID Add F_3682 CATALOG CATALOG_ID Cascade
LANGUAGE_ID Add F_3683 LANGUAGE LANGUAGE_ID Cascade
CMFEEDLOG CMFEEDLOG_ID Add Primary key
STOREENT_ID Add F_3678 STOREENT STOREENT_ID Cascade
DKOFFERADJMNT TRADEPOSCN_ID + KIT_ID + CATENTRY_ID Add Primary key
TRADEPOSCN_ID Add F_3693 TRADEPOSCN TRADEPOSCN_ID Cascade
KIT_ID Add F_3694 CATENTRY CATENTRY_ID Cascade
CATENTRY_ID Add F_3695 CATENTRY CATENTRY_ID Cascade
ORDERREL ORDERREL_ID Add Primary key
PARENTORDER_ID Add F_3639 ORDERS ORDERS_ID Cascade
CHILDORDER_ID Add F_3640 ORDERS ORDERS_ID Cascade
PARENTORDERITEM_ID Add F_3641 ORDERITEMS ORDERITEMS_ID Cascade
PRCONSTANT PRCONSTANT_ID Add Primary key
STOREENT_ID Add f_3637 STOREENT STOREENT_ID Cascade
PRCONVALUE PRCONSTANT_ID + CURRENCY Add Primary key
PRCONSTANT_ID Add F_3638 PRCONSTANT PRCONSTANT_ID Cascade
PRELEMENT PRELEMENT_ID Add Primary key
PRICERULE_ID Add F_3633 PRICERULE PRICERULE_ID Cascade
PRELETEMPLATE_ID Add F_3634 PRELETEMPLATE PRELETEMPLATE_ID Cascade
PRELEMENTATTR PRELEMENT_ID + NAME + VALUE Add Primary key
PRELEMENT_ID Add F_3635 PRELEMENT PRELEMENT_ID Cascade
PRELETEMPLATE PRELETEMPLATE_ID Add Primary key
PRELETPLTGRP_ID Add F_3631 PRELETPLTGRP PRELETPLTGRP_ID Cascade
STOREENT_ID Add F_3632 STOREENT STOREENT_ID Cascade
PRELETPLTGRP PRELETPLTGRP_ID Add Primary key
PREQENTRY PREQENTRY_ID Add Primary key
PREQUATION_ID Add F_3676 PREQUATION PREQUATION_ID Cascade
PREQENTRYTYPE_ID Add F_3677 PREQENTRYTYPE PREQENTRYTYPE_ID Cascade
PREQENTRYTYPE PREQENTRYTYPE_ID Add Primary key
PREQUATION PREQUATION_ID Add Primary key
STOREENT_ID Add F_3636 STOREENT STOREENT_ID Cascade
PRICERULE PRICERULE_ID Add Primary key
STOREENT_ID Add F_3630 STOREENT STOREENT_ID Cascade
SRCHATTR SRCHATTR_ID Add Primary key
SRCHATTRPROP SRCHATTR_ID + PROPERTYNAME Add Primary key
SRCHATTR_ID Add F_3689 SRCHATTR SRCHATTR_ID Cascade
SRCHCONF INDEXTYPE Add Primary key
SRCHSTATS SRCHSTATS_ID Add Primary key
STOREENT_ID Add F_3696 STOREENT STOREENT_ID Cascade
SRCHTERM SRCHTERMASSOC_ID + TYPE + TERM Add Primary key
SRCHTERMASSOC_ID Add F_3688 SRCHTERMASSOC SRCHTERMASSOC_ID Cascade
SRCHTERMASSOC SRCHTERMASSOC_ID Add Primary key
STOREENT_ID Add F_3686 STOREENT STOREENT_ID Cascade
LANGUAGE_ID Add F_3687 LANGUAGE LANGUAGE_ID Cascade
STORETPC STOREENT_ID + TRADEPOSCN_ID + STTPCUSG_ID Add Primary key
STOREENT_ID Add F_3642 STOREENT STOREENT_ID Cascade
TRADEPOSCN_ID Add F_3643 TRADEPOSCN TRADEPOSCN_ID Cascade
STTPCUSG_ID Add F_3675 STTPCUSG STTPCUSG_ID Cascade
STTPCUSG STTPCUSG_ID Add Primary key
SUBSCPTYPE SUBSCPTYPE_ID Add Primary key
SUBSCRIPTION SUBSCRIPTION_ID Add Primary key
CATENTRY_ID Add F_3646 CATENTRY CATENTRY_ID Cascade
SUBSCPTYPE_ID Add F_3647 SUBSCPTYPE SUBSCPTYPE_ID Cascade
ORDERITEMS_ID Add F_3648 ORDERITEMS ORDERITEMS_ID Cascade
ORDERS_ID Add F_3649 ORDERS ORDERS_ID Cascade
STOREENT_ID Add F_3650 STOREENT STOREENT_ID Cascade
MEMBER_ID Add F_3651 MEMBER MEMBER_ID Cascade
SUBSCRTEMPLATE_ID Add F_3652 SUBSCRTEMPLATE SUBSCRTEMPLATE_ID Cascade
FFMFREQ_UOM Add F_3690 QTYUNIT QTYUNIT_ID Cascade
PAYMENTFREQ_UOM Add F_3691 QTYUNIT QTYUNIT_ID Cascade
TIMEPERIOD_UOM Add F_3692 QTYUNIT QTYUNIT_ID Cascade
SUBSCRRENEW RENEWEDSUBSCR_ID + SUBSCRIPTION_ID Add Primary key
RENEWEDSUBSCR_ID Add F_3660 SUBSCRIPTION SUBSCRIPTION_ID Cascade
SUBSCRIPTION_ID Add F_3661 SUBSCRIPTION SUBSCRIPTION_ID Cascade
SUBSCRSCHJOBS SCHEDULED_ID Add Primary key
SUBSCRIPTION_ID Add F_3659 SUBSCRIPTION SUBSCRIPTION_ID Cascade
SUBSCRSUSPEND SUSPEND_ID Add Primary key
SUBSCRIPTION_ID Add F_3653 SUBSCRIPTION SUBSCRIPTION_ID Cascade
SUBSCRTEMPLATE SUBSCRTEMPLATE_ID Add Primary key
STOREENT_ID Add F_3654 STOREENT STOREENT_ID Cascade
MEMBER_ID Add F_3655 MEMBER MEMBER_ID Cascade
CATENTRY_ID Add F_3656 CATENTRY CATENTRY_ID Cascade
SUBSCRTMPLITEMLIST SUBSCRTEMPLATE_ID Add Primary key
SUBSCRTEMPLATE_ID Add F_3657 SUBSCRTEMPLATE SUBSCRTEMPLATE_ID Cascade
CATENTRY_ID Add F_3658 CATENTRY CATENTRY_ID Cascade
Table relationships that are new or changed with WebSphere Commerce Version 7 Feature Pack 1
Table Column Action Constraint name Foreign table Foreign column Constraint type
DMRANKINGITEM DMRANKINGITEM_ID Add Primary key
DMELEMENT_ID Add f_3595 DMELEMENT DMELEMENT_ID Cascade
DMRANKINGSTAT DMRANKINGSTAT_ID Add Primary key
FILEPROCREL UPLOADFILE_ID + PROCESSFILE_ID Add Primary key
UPLOADFILE_ID Add f_3602 UPLOADFILE UPLOADFILE_ID Cascade
PROCESSFILE_ID Add f_3603 PROCESSFILE PROCESSFILE_ID Cascade
INSRULE INSRULE_ID Add Primary key
STOREENT_ID Add f_3618 STOREENT STOREENT_ID Cascade
INSRULECATENT INSRULECATENT_ID Add Primary key
INSRULE_ID Add f_3621 INSRULE INSRULE_ID Cascade
CATENTRY_ID Add f_3622 CATENTRY CATENTRY_ID Cascade
INSRULECATGRP INSRULECATGRP_ID Add Primary key
CATGROUP_ID Add f_3620 CATGROUP CATGROUP_ID Cascade
INSRULE_ID Add f_3619 INSRULE INSRULE_ID Cascade
INSRULECOND INSRULECOND_ID Add Primary key
INSRULE_ID Add f_3624 INSRULE INSRULE_ID Cascade
INSRULEINSOPT INSRULEINSOPT_ID Add Primary key
INSRULE_ID Add f_3625 INSRULE INSRULE_ID Cascade
CURRENCY Add f_3626 SETCURR SETCCURR Cascade
INSRULEPAYMTHD INSRULEPAYMTHD_ID Add Primary key
INSRULE_ID Add f_3623 INSRULE INSRULE_ID Cascade
PROCESSFILE PROCESSFILE_ID Add Primary key
MEMBER_ID Add f_3601 MEMBER MEMBER_ID Cascade
PX_CDPOOL PX_CDPOOL_ID Add Primary key
STORE_ID Add f_3605 STORE STORE_ID Cascade
PX_CDPROMO PX_CDPROMO_ID Add Primary key
PX_PROMOTION_ID Add f_3606 PX_PROMOTION PX_PROMOTION_ID Cascade
PX_CDPOOL_ID Add f_3607 PX_CDPOOL PX_CDPOOL_ID Cascade
PX_CDSPEC PX_PROMOTION_ID Add Primary key
PX_PROMOTION_ID Add f_3604 PX_PROMOTION PX_PROMOTION_ID Cascade
PX_CDUSAGE PX_CDUSAGE_ID Add Primary key
PX_CDPOOL_ID Add f_3608 PX_CDPOOL PX_CDPOOL_ID Cascade
OWNER_ID Add f_3609 USERS USERS_ID Cascade
ORDERS_ID Add f_3610 ORDERS ORDERS_ID Cascade
UPLOADFILE UPLOADFILE_ID Add Primary key
MEMBER_ID Add f_3599 MEMBER MEMBER_ID Cascade
STORE_ID Add f_3600 STORE STORE_ID Cascade
WALLET WALLET_ID Add Primary key
MEMBER_ID Add f_3613 MEMBER MEMBER_ID Cascade
STOREENT_ID Add f_3614 STOREENT STOREENT_ID Cascade
WALLETITEM WALLETITEM_ID Add Primary key
WALLET_ID Add f_3615 WALLET WALLET_ID Cascade
WIREL WALLETITEM_ID_PNT + WALLETITEM_ID_CHD + TYPE Add Primary key
WALLETITEM_ID_PNT Add f_3616 WALLETITEM WALLETITEM_ID Cascade
WALLETITEM_ID_CHD Add f_3617 WALLETITEM WALLETITEM_ID Cascade
Table relationships that are new or changed with WebSphere Commerce Version 7 Fix Pack 9
Table Column Action Constraint name Foreign table Foreign column Constraint type
ORDAUDIT ORDERS_ID Add P_0032 Primary key

No table relationships are new or changed with WebSphere Commerce Version 7 Fix Pack 8

Table relationships that are new or changed with WebSphere Commerce Version 7 Fix Pack 7
Table Column Action Constraint name Foreign table Foreign column Constraint type
PREVIEWTOKEN PREVIEWTOKEN_ID Add P_0028 Primary key
STOREENT_ID Add F_3765 STOREENT STOREENT_ID Cascade
Table relationships that are new or changed with WebSphere Commerce Version 7 Fix Pack 6
Table Column Action Constraint name Foreign table Foreign column Constraint type
GEONODE STOREENT_ID Add F_3730 STOREENT STOREENT_ID Cascade
STLOC STOREENT_ID Add F_3731 STOREENT STOREENT_ID Cascade

No table relationships are new or changed with WebSphere Commerce Version 7 Fix Pack 5

No table relationships are new or changed with WebSphere Commerce Version 7 Fix Pack 4

No table relationships are new or changed with WebSphere Commerce Version 7 Fix Pack 3

No table relationships are new or changed with WebSphere Commerce Version 7 Fix Pack 2

Table relationships that are new or changed with WebSphere Commerce Version 7 Fix Pack 1
Table Column Action Constraint name Foreign table Foreign column Constraint type
GRGFTREG POSTEVENTADDRESS_ID Delete GRG_CONSTRAINT4 GRADDR ADDRESS_ID Cascade
GRRGSTRNT PREEVENTADDRESS_ID Delete GRR_CONSTRAINT2 GRADDR ADDRESS_ID Cascade