Legend for data models

Database tables within the WebSphere Commerce database schema are organized into functional groups, called data models. The referential integrity relationships between related database tables are illustrated by using the following crow's foot notation:

Database table entity.



One and only one. An object is related to one object and only one object.



One or many. An object can be related to one object or many objects.



Zero or one or many. An object can be related to one object, to many objects, or to no object.



Zero or one. An object can be related to one object or to no objects.

Notes:

• A solid line represents an identifying relationship. The existence of each child table object is dependent upon the parent table object. The primary key of each child table object includes the primary key of the parent table object.

  The following diagram shows an identifying foreign key relationship.

• A dotted line represents a non-identifying relationship. The existence of the objects in each table in the relationship is independent of the other object. The primary key of each table does not need to include the primary key of the other table.

  The following diagram shows a non-identifying foreign key relationship.

Related reference
Order Management data models
ATP inventory data model
ATP inventory adjustment data model
ATP expected inventory data model
ATP inventory fulfillment data model
ATP inventory orders data model
ATP inventory reservations data model
Billing 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
Country and state code data model
Currency data model
DOM inventory cache data model
Fulfillment data model
Interest item data model
Jurisdiction data model
Offers 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 - RMA data model
Order management - RMAitem data model
Order release data model
Order tax data model
Order trading agreement data model
Order item data model
Order item - allocated data model
Order item - backordered data model
Pricing data model
Price rules data model
Procurement data model
Quantity unit data model
Quantity unit - references data model
Receipt data model
Shipping data model
Buy online, pickup in-store
Suborders data model
Subscriptions and recurring orders data model
Tax type and category data model
Ticklers data model
Vendor data model
Payment data models
Payments subsystem data model
Payment batch data model
Payment merchant support data model
Payment processing data model
Payment rules data model
Member data models
Member data model
Access control data model
Access logging data model
Authentication data model
Store data models
Store data model
Store locator
Commerce Composer data model
System data models
Command data model
Scheduler data model
Language data model
Messaging data model
Messaging extension data model
Mobile device data model
Staging environment data model
System data model
User traffic data model
Views and temporary tables data model
Session management data model
Trading data models
Contract data model
Request for Quote (RFQ) data model
Content management data model
Content management system integration data model
Content versioning data model
Folder data model
IBM Gift Center data model
WebSphere Commerce search engine optimization (SEO) data model
WebSphere Commerce search data model