Table sola.system.consolidation_config
This table contains the list of instructions to run the consolidation process.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id varchar 100
schema_name varchar 100 Name of the source schema.
table_name varchar 100 Name of the source table.
condition_description varchar 1000 Description of the condition has to be applied to rows of the source table for extraction.
condition_sql varchar 1000  √  null The SQL implementation of the condition.
remove_before_insert bool 1 false True - The records in the destination will be removed if they are found in the new extract. The check is done in rowidentifier.
order_of_execution int4 10 Order of execution of the extract.
log_in_extracted_rows bool 1 true True - If the records has to be logged in the extracted rows table.

Analyzed at Tue May 31 09:59 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc consolidation_config_pkey
schema_name + table_name Must be unique Asc/Asc consolidation_config_lkey