Extending database tables

You can extend database tables by following the guidelines.

Adding columns to a default table
You can add columns to tables by modifying the entity database extension XML files and then rebuilding the application database and JAR files. After the application is rebuilt, the APIs recognize these added columns and use them while storing and retrieving data.
Features requiring multiple extensions
You can review the information for features that you can extend in addition to default tables.
Adding unique tag identifiers and descriptors to a default table
The default tag identifiers are Batch Number, Revision Number, and Lot Number. You might need to extend the application database to define unique tag identifiers or descriptors.
Adding non-unique indices to a default table
You can add non-unique indices to entities. You add indices to a default database table, by adding an Index element in the extension XML for that table.
Adding foreign key elements to a default 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.
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 text search indexes to a default table
You can add text search indexes to entities. You add text search indexes to a default 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 facilitates 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