Home
Reference
WebSphere Commerce database schema
The WebSphere Commerce database model was designed for data integrity and optimal performance. WebSphere Commerce provides several hundred tables that store WebSphere Commerce instance data. To maintain data integrity, and to ease maintenance referential integrity, constraints are widely used in the database model. Indexes are used carefully on tables to avoid over-indexing and to provide a good balance between data retrieval and data manipulation activities (insert and update). The business rules are implemented at the application level rather than by using database trigger. Triggers, however, are used to facilitate data staging and optimistic locking. A limited number of SQL-based database stored procedures are used for data intensive activities.
Data models
Any given database data model displays the relationship among database tables in the schema.
Order Management
The order management data model shows the relationship between database tables related to the Order Management subsystem.
Order management - RMA
The Order management - RMA data model shows the relationship between database tables that contain information about RMA (return merchandise authorization) data for an Order.

Order management - RMA data model

The Order management - RMA data model shows the relationship between database tables that contain information about RMA (return merchandise authorization) data for an Order.

Click any of the database table boxes to see more information about that table.