The Support Tables
Prev |  | Next

## The Support Tables

Support tables are used to control the values used in other tables. Each support table has a key, with an appropriate column name, and a column named `Description`. Both of these columns are of type `TEXT`. The keys of the support table are foreign keys of a column which has a controlled vocabulary, a limited number of terms which are allowed to be used.

An administrator can add or remove rows from the support tables to dynamically control the allowed vocabulary.

The support table `Description` columns must be unique when the comparison is made in a case-insensitive manner.

### IQ_TYPES (Integrity Query Types)

IQ_TYPES contains one row for every code used to classify database integrity queries. Classification may be by the type of data integrity problem the related queries are designed to uncover, by who is responsible for resolving the discovered problems, or any other desired classification scheme.

#### Key: IQType

The IQ_TYPES table is keyed by the IQType column. This column may not contain whitespace characters. This column must be unique when compared in a case-insensitive fashion.

### IR_TYPES (Isok Result Types)

IR_TYPES contains one row for every code used to classify or explain sets of database integrity problems, problems discovered by Isok's queries. Codes may be used as needed, whether to organize reported problems pending resolution, to describe the circumstances which resolve an issue, or to serve other purposes.

#### Key: IRType

The IR_TYPES table is keyed by the IRType column. This column may not contain whitespace characters. This column must be unique when compared in a case-insensitive fashion.

Prev |  | Next
The Main Tables | Home | The Functions (Running Isok)

Page generated: 2025-12-15T15:11:24-06:00.