Extending database tables

Adding a column to a standard table
You add columns to tables by modifying the entity database extension XML files and then rebuilding the application database and JAR files. After the application has been rebuilt, the APIs recognize these added columns and use them when storing and retrieving data.
Features requiring multiple extensions when adding a column to a standard table
You can review the information for fe3atures that you can extend in addition to standard tables.
Extending a catalog search
You can extend a catalog search to provide broader search capabilities by updating information in the catalog search index file. To update the index file, modify the corresponding extended XML configuration file.
Predefining and grouping a set of columns for a query
You can select and group columns to be used in a query (select/list) search by adding a parameter QueryGroup in the entity definition.
Adding unique tag identifiers and descriptors to a standard table
The default tag identifiers are Batch Number, Revision Number, and Lot Number. You may have a need to extend the application database to define unique tag identifiers or descriptors.
Adding non-unique indices to a standard table
You can add non-unique indices to entities. You add indices to a standard database table, by adding an Index element in the extension XML for that table.
Adding foreign key elements to a standard table
A foreign key relationship is a relationship between an extended column in any application database table and the YFS_PERSON_INFO table. You can create foreign key elements to establish relationship between an extended column and the YFS_PERSON_INFO table.
Adding text search indices to a standard table
You can add text search indices to entities. You add text search indices to a standard application database table by adding a TSIndex element in the extension XML for that table.
Enabling case-insensitive searches
You can enable search operations case-insensitive by enabling case-insensitive searches for the applicable entity or column. To achieve this, add the CaseInsensitiveSearch attribute in the applicable entity XML file.
Creating custom and hang-off tables
The database framework allows you to extend the application database by creating custom or hang-off tables.
Dropping custom tables or custom columns
When you drop custom tables or custom columns in a database, the objects and associated data get permanently deleted from the database schema.

Parent topic: Extending the database