Default Value Setting

The rule to set the database default value is the following:

  • 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.