Mapped Cache Extensions and the Application Database

The fields of a mapped cache extension that are mapped to the fields of a base data access class (DAC) are used by the system to work with the database columns to which the fields of the base DAC are bound.

If a mapped cache extension includes fields that are bound to database columns (with the type attributes that are derived from the PXDBFieldAttribute class, such as PXDBString), the database table that corresponds to the base DAC must contain these fields of the mapped cache extension. That is, the database table must include the fields bound to a database column that are defined both in the base DAC and the mapped cache extension, as shown in the following diagram.
Figure 1. Database schema for a DAC and mapped cache extension