Reference - Database ER Models

Product Version

7.0

Product To Version

 

Status

final

1 Introduction

Intershop applications use relational databases. A relational schema specifies a collection of table definitions, providing structure for the data housed in the database instance. The entity relationship model documentation depends on the used Intershop version.

The database structure is tangibly pictured in an entity-relationship diagram. These diagram/model is contained in the attached *.zip files.

The erm_pdf_<version>.zip contains a set of PDF documents.

Note

These materials are subject to change without notice. These materials are provided by Intershop Communications AG for informational purposes only, without representation or warranty of any kind, and Intershop shall not be liable for errors or omissions with respect to the materials. The only warranties for Intershop products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.

Especially, physical data models differ significantly for each implementation, not least due to the underlying operating-system requirements that sits underneath them.

2 Overview Database ER Models

TitleNameVersionPublication DatePDFNew CartridgesChanged Cartridges
Database ER Model 7.5.0Intershop 7 Entity-Relationship Model7.52014-10-30 erm_pdf_750.zip bc_dashboard_orm, bc_product_validationbc_customer_orm, bc_foundation, bc_image, bc_marketing, bc_marketing, bc_mvc, bc_pmc,
bc_preview_orm, bc_pricing, bc_product_configuration, bc_product_rating_orm, bc_region,
bc_search, bc_shipping, bc_shipping_data, bts, core, xcs
Database ER Model 7.4.5Intershop 7 Entity-Relationship Model7.4.52014-01-10erm_pdf_745.zip bc_customer_orm, bc_foundation, bc_image, bc_marketing, bc_mvc, bc_pmc, bc_ruleengine,
bts, core
Database ER Model 7.4 CIIntershop 7 Entity-Relationship Model7.4.62014-04-11 erm_pdf_746_ci.zip  bts
Database ER Model 7.3.2Intershop 7 Entity-Relationship Model7.3.22013-05-30erm_pdf_732.zipbc_customer_ormac_giftcard_std, bc_mvc, bc_pmc, bc_pmc_validation, bts, core, xcs
Database ER Model 7.3.1Intershop 7 Entity-Relationship Model7.3.12013-05-30erm_pdf_731.zip core, bc_marketing, bc_pmc
Database ER Model 7.3.0Intershop 7 Entity-Relationship Model7.32013-01-09erm_pdf_730.zip ac_giftcard_std
Database ER Model 7.2.1Intershop 7 Entity-Relationship Model7.2.12012-12-06erm_pdf_721.zipbc_pmc_validationcore, bc_product_configuration, bc_service, bts, xcs, bc_marketing
Database ER Model 7.2.0Intershop 7 Entity-Relationship Model7.22012-09-25erm_pdf_72.zip
Database ER Model - Intershop Commerce Management B2C/B2X 7.9Intershop 7 Entity-Relationship Model7.92017-07-18Intershop Commerce Management B2X 7.9 erm_pdf_790_b2x.zip; Intershop Commerce Management B2C 7.9 erm_pdf_790_b2c.zipbc_processchain_orm, bc_transport_ormbc_marketing, core
Database ER Model - Intershop Commerce Management B2C/B2X 7.8Intershop 7 Entity-Relationship Model7.82016-12-06Intershop Commerce Management B2X 7.8 Database ER Model - Intershop Commerce Management B2C/B2X 7.8; Intershop Commerce Management B2C 7.8 Database ER Model - Intershop Commerce Management B2C/B2X 7.8b2b only: bc_order_approval_ormbc_customer_orm, bc_product_configuration, bc_pmc, bts, core, xcs
Database ER Model - Intershop Commerce Management B2C/B2X 7.7Intershop 7 Entity-Relationship Model7.72016-06-08Intershop Commerce Management B2X 7.7 Database ER Model - Intershop Commerce Management B2C/B2X 7.7 ; Intershop Commerce Management B2C 7.7 Database ER Model - Intershop Commerce Management B2C/B2X 7.7B2B only: bc_costobject_orm, bc_order_costobject_ormbc_pmc, xcs
Database ER Model - Intershop Commerce Management B2C/B2X 7.6Intershop 7 Entity-Relationship Model7.62015-11-23Intershop Commerce Management B2X 7.6 erm_pdf_760_b2x.zip ; Intershop Commerce Management B2C 7.6 erm_pdf_760_b2c.zipbc_store_orm
B2B only: bc_b2b, bc_budget_orm, bc_contract_orm, bc_costcenter_orm
bc_rating_orm, core, xcs
Database ER Model (7.1 - 7.1.0.1)Intershop 7 Entity-Relationship Model7.12012-08-18erm_pdf_71.zip

Disclaimer

The information provided in the Knowledge Base may not be applicable to all systems and situations. Intershop Communications will not be liable to any party for any direct or indirect damages resulting from the use of the Customer Support section of the Intershop Corporate Web site, including, without limitation, any lost profits, business interruption, loss of programs or other data on your information handling system.

Customer Support
Knowledge Base
Product Resources
Support Tickets