_Validation Table

The _Validation table is a system table that contains the column names and the column values for all of the tables in the database. It is used during the database validation process to ensure that all columns are accounted for and have the correct values. This table is not shipped with the installer database.

The _Validation table has the following columns.

Column Type Key Nullable
Table Identifier Y N
Column Identifier Y N
Nullable Text N N
MinValue DoubleInteger N Y
MaxValue DoubleInteger N Y
KeyTable Identifier N Y
KeyColumn Integer N Y
Category Text N Y
Set Text N Y
Description Text N Y

 

Columns

Table

Used to identify a particular table. This key and the Column key form the primary key of the _Validation table.

Column

Used to identify a particular column of the table. This key and the Table key form the primary key of the _Validation table.

Nullable

Identifies whether the column may contain a Null value.

This column may have one of the following values.

String Meaning
Y Yes, the column may have a Null value.
N No, the column may not have a Null value.

 

MinValue

This field applies to columns having numeric value. The field contains the minimum permissible value. This can be the minimum value for an integer or the minimum value for a date or version string.

MaxValue

This field applies to columns having numeric value. The field is the maximum permissible value. This may be the maximum value for an integer or the maximum value for a date or version string.

KeyTable

This field applies to columns that are external keys. The field identified in Column must link to the column number specified by KeyColumn in the table named in KeyTable. This can be a list of tables separated by semicolons.

KeyColumn

This field applies to table columns that are external keys. The field identified in Column must link to the column number specified by KeyColumn in the table named in KeyTable. The permissible range of the KeyColumn field is 1-32.

Category

This is the type of data contained by the database field specified by the Table and Column columns of the _Validation table. If this is a type having a numeric value, such as Integer, DoubleInteger or Time/Date, then enter null into this field and specify the value's range using the MinValue and MaxValue columns. Use the Category column to specify the non-numeric data types described in Column Data Types.

Set

This is a list of permissible values for this field separated by semicolons. This field is usually used for enumerations.

Description

A description of the data that is stored in the column.

Validation

ICE03
ICE06
ICE32

Remarks

The Category field of this table only applies to string data. If the Column field refers to a column with binary data, the binary data type must be specified in the Category field. Integer data Column types ignore the Category field during validation.