Technical data

Column Data Type and Constraints
Database Design 3-7
Default Value Setting
The rules for setting the database default values are as follows:
• When a predefined default value is not available, set the default value of Non-null CHAR or
VARCHAR columns to blank except the primary key columns.
• When a predefined default value is not available, set the default value Non-null Number
columns to 0 (zero) except the primary key columns.
• No database default values should be assigned to the Non Null Date, Time, and Timestamp
columns.
Foreign Key Constraints
Referential integrity is enforced by the application. In the database do not define FK constraints.
Indexes are created on most of Foreign Key columns to increase performance.
Standard Columns
This section discusses the rules applied to standard columns and the attributes that are associated
with these objects.
Owner Flag
Owner Flag (OWNER_FLG) columns exist on the system tables that are shared by multiple
products. Oracle Utilities Application Framework limits the data modification of the tables that
have owner flag to the data owned by the product.
Version
The Version column is used to for optimistic concurrency control in the application code. Add the
Version column to all tables that are maintained by a Row Maintenance program irrespective of
the language used (COBOL or JAVA).