You can override the default data types by creating a table of alternate data types, named uaci_column_types, in the
testRunDataSource or
prodUserDataSource. This additional table allows Interact to accommodate rare cases that aren’t covered by the hardcoded data types.
When the uaci_column_types table is defined, Interact uses the metadata for the columns as the data types to be used for any table generation. If the
uaci_column_types table is not defined, or if there are any exceptions encountered while trying to read the table, the default data types are used.
At startup, the runtime system first checks the testRunDataSource for the
uaci_column_types table. If the
uaci_column_types table does not exist in the
testDataSource, or if the
prodUserDataSource is of a different database type, Interact then checks the
prodUserDataSource for the table.