Designing the Data Structure › Data Structure List › Data Structure List Terminology › Properties of Tables › Permitted Value Default Enforcement - Creates/Updates

Permitted Value Default Enforcement - Creates/Updates

The following list details the options you can set to handle the permitted value enforcement for creates or updates:

• Defaulted—Select this option if you want the permitted value enforcement to be handled at the database level.
• DBMS—Select this option if you want the permitted value enforcement for row creates and updates to be handled at the table level and you want the DBMS to do the enforcement.

  By enabling the DBMS to control the permitted value enforcement, you are requiring all application (CA Gen or not) that will be creating or updating rows in this table to adhere to the same permitted value rules.

• CA Gen—Select this option if you want the permitted value enforcement to be handled at the table level and you want CA Gen to do the enforcement. This is a good selection if there are no permitted values in the table, or if you do not want the DBMS to enforce the permitted values for create or and update statements.
• Description—Freeform text documentation about the table.

  Keep information about changes that have been made to this table in technical design. Although CA Gen knows these changes, you may want to know what changes were made in case the table is retransformed.

Note: Remember that this description will be eliminated when this table is transformed again (either by transformation or retransformation).

Other than these properties, each table contains a number of details that are specific to target DBMS implementations. The default settings are usually sufficient for unit testing; they need not be considered until volume or integration testing begins.