Bookshelf Home | Contents | Index | Search | PDF

Configuration Guidelines > Database Extensibility >

Static Database Extensions

---

_X extension tables (1:1). This type of extension table is basically an extension of the base table record. You do not need to create a new business component object when you use these tables. The _X tables are implicitly defined as joins.
_XM extension tables (1:M). This type of extension table lets you create a one-to-many relationship with the record in the parent base table. The following list provides the guidelines to follow when using _XM tables:
Create a new business component based on the relevant _XM table.
Create a Type field based on the TYPE column and use this to filter the records by specifying it in the search specification for the business component.
Add the correct Predefault Value to the Type field.
Use the NAME column to track the main data field.
The unique index is on PAR_ROW_ID, TYPE, NAME, and CONFLICT_ID. Be aware of this index when planning your design.
If you are using MVGs to display data, extend the base table to track primary values.

Bookshelf Home | Contents | Index | Search | PDF