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