Hang off Tables in IBM Sterling and Purpose?

The database framework allows you to extend the application database by creating custom or hang-off tables.

 

Sterling application framework allows extending the existing database by creating new columns in existing tables, creating new custom independent tables and creating a custom table having a relationship with the out of the box table. Such custom tables having relationship with an existing out of the box table is called as Hang off table.

 

A custom table is an independent table and cannot be modeled as an extension to a standard application database table. A hang-off table is a table with a many-to-one relationship with a standard application database table.

 

Creating a custom or hang-off entity enables you to: 

 

• Create a relationship between a standard table and a hang-off table. 
• Invoke Extensible APIs that store and retrieve data from hang-off tables. 
• Invoke dbverify for generating appropriate SQL scripts to create or alter tables for custom or hang-off entities.

 

Keep in mind the following which apply to the creation of custom or hang-off tables: 

• Based on the Extensions.xml file, the application does not create a foreign key constraint in the EFrame_TableChanges.sql, but the foreign key relationship is enforced. 
• Currently only order, order line, work order, shipment, item, and organization tables are marked as hang-off enabled. 
• Custom and hang-off table names must not start with Y.