About extending the database

Certain aspects of the Sterling Selling and Fulfillment Foundation database cannot be modified. If you try to make these modifications, your data is not harmed, but your attempted changes are not incorporated into the database. The application does not permit modification of the following:

When planning extensions to the database, consider the implications of your changes and how they may impact other areas.

Note: If you modify a table and your deployment uses the Sterling Business Centercomponent, the view associated with the table must also be modified.

Entity relationship diagrams

To learn more about the Sterling Selling and Fulfillment Foundation database, see the entity relationship diagrams (ERDs) using the INSTALL_DIR/xapidocs/erd/html/erd.html file. These ERDs provide the following information:
  • Indicate which tables can be extended by adding columns.
  • Indicate which tables can have hang-off relationship.
  • Relationships between tables (to help you understand the relationship between logical entities such as orders, shipments, and payments).
  • Indices details. Each table is indexed by a primary key. Most tables also have a unique index that is constituted of the columns that make the logical unique key. In addition, some tables have alternate indices to support queries.
  • Views that indicate how several tables interact.

Entity database XML files

The standard tables that are shipped with the application database are defined in a set of entity XML files, also known as database definition XML files. Each entity XML file may contain several table definitions. To learn more about these tables, see the files in the INSTALL_DIR/repository/entity directory. Within these entity XML files, an entity represents a table and an attribute represents a column.