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