Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
dictionary Table header_line_number int8 19 null
conversion Table source_data_id int8 19 null
row Table min_occurrence int4 10 1
data_row Table data_id int8 19 null
field Table data_type_id int8 19 get_data_type_id('STRING'::text)
data_type Table id bigserial 19 nextval('seq_data_type_id'::regclass)
dynamic_field Table label text 2147483647 null
mapping_function Table update_date timestamptz 35 clock_timestamp()
dictionary Table data_path text 2147483647 null
conversion_map_chain Table update_user int8 19 null
rule Table update_date timestamptz 35 clock_timestamp()
error_level Table id bigserial 19 nextval('seq_error_level_id'::regclass)
mapping_function Table function_order int4 10 null
map Table update_user int8 19 null
data_type Table create_date timestamptz 35 clock_timestamp()
dynamic_field Table create_user int8 19 null
function_definition Table update_user int8 19 null
conversion Table target_dictionary_id int8 19 null
dynamic_field Table update_user int8 19 null
function_definition Table id bigserial 19 nextval('seq_function_definition_id'::regclass)
conversion Table label text 2147483647 null
data Table data_size int8 19 null
conversion Table source_data_path text 2147483647 null
conversion Table update_user int8 19 null
field Table update_user int8 19 null
conversion Table map_id int8 19 null
dictionary Table dynamic bool 1 false
field Table label text 2147483647 null
data_format Table create_user int8 19 null
data_format Table id bigserial 19 nextval('seq_data_format_id'::regclass)
rule_definition Table identifier text 2147483647 null
mapping Table update_user int8 19 null
rule Table create_user int8 19 null
data_format Table create_date timestamptz 35 clock_timestamp()
rule Table rule_order int4 10 null
conversion_chain Table create_user int8 19 null
function_definition Table create_date timestamptz 35 clock_timestamp()
mapping_function Table function_value text 2147483647 null
aggregate_definition Table update_user int8 19 null
user_profile Table password text 2147483647 null
user_profile Table update_date timestamptz 35 clock_timestamp()
field Table max_occurrence int4 10 1
dictionary Table create_user int8 19 null
dictionary Table update_user int8 19 null
conversion Table source_dictionary_id int8 19 null
user_profile Table last_login timestamptz 35 null
mapping_function Table create_date timestamptz 35 clock_timestamp()
rule_definition Table update_date timestamptz 35 clock_timestamp()
data_row Table update_date timestamptz 35 clock_timestamp()
data_field Table id bigserial 19 nextval('seq_data_field_id'::regclass)
data_field Table dictionary_id int8 19 null
aggregate_definition Table create_user int8 19 null
user_profile Table id bigserial 19 nextval('seq_user_profile_id'::regclass)
data Table id bigserial 19 nextval('seq_data_id'::regclass)
customer Table id bigserial 19 nextval('seq_customer_id'::regclass)
data_type Table create_user int8 19 null
map Table update_date timestamptz 35 clock_timestamp()
map Table source_dictionary_id int8 19 null
conversion_chain Table recycle_output bool 1 false
row Table update_date timestamptz 35 clock_timestamp()
function_definition Table identifier text 2147483647 null
conversion_map_chain Table map_order int4 10 null
field Table data_format text 2147483647 null
user_profile Table update_user int8 19 null
data Table create_date timestamptz 35 clock_timestamp()
data_field Table original_value text 2147483647 null
data_row Table row_id int8 19 null
aggregate_definition Table create_date timestamptz 35 clock_timestamp()
rule Table update_user int8 19 null
dynamic_field Table create_date timestamptz 35 clock_timestamp()
conversion Table id bigserial 19 nextval('seq_conversion_id'::regclass)
dynamic_field Table data_format text 2147483647 null
row Table dictionary_id int8 19 null
rule Table create_date timestamptz 35 clock_timestamp()
data Table update_date timestamptz 35 clock_timestamp()
rule_definition Table create_date timestamptz 35 clock_timestamp()
mapping Table source_field_id int8 19 null
field Table aggregate_field_id int8 19 null
conversion_chain Table id bigserial 19 nextval('seq_conversion_chain_id'::regclass)
data_format Table update_user int8 19 null
dictionary Table xml bool 1 false
data_format Table format text 2147483647 null
mapping_function Table create_user int8 19 null
field Table id bigserial 19 nextval('seq_field_id'::regclass)
row Table row_order int4 10 1
dynamic_field Table id bigserial 19 nextval('seq_dynamic_field_id'::regclass)
mapping Table id bigserial 19 nextval('seq_mapping_id'::regclass)
user_profile Table create_date timestamptz 35 clock_timestamp()
rule Table error_level_id int8 19 null
map Table target_dictionary_id int8 19 null
function_definition Table prompt_text text 2147483647 null
conversion_chain Table label text 2147483647 null
mapping Table map_id int8 19 null
field Table aggregate_definition_id int8 19 null
mapping Table target_field_id int8 19 null
rule_definition Table id bigserial 19 nextval('seq_rule_definition_id'::regclass)
data_type Table update_user int8 19 null
rule Table id bigserial 19 nextval('seq_rule_id'::regclass)
data_field Table value text 2147483647 null
conversion_map_chain Table id bigserial 19 nextval('seq_conversion_map_chain_id'::regclass)
conversion Table create_user int8 19 null
data_field Table update_date timestamptz 35 clock_timestamp()
rule_definition Table create_user int8 19 null
row Table create_user int8 19 null
rule Table rule_value text 2147483647 null
row Table id bigserial 19 nextval('seq_row_id'::regclass)
conversion_map_chain Table conversion_chain_id int8 19 null
mapping Table create_date timestamptz 35 clock_timestamp()
data Table data_path text 2147483647 null
aggregate_definition Table identifier text 2147483647 null
data_row Table create_user int8 19 null
mapping Table mapping_order int4 10 null
conversion_chain Table update_date timestamptz 35 clock_timestamp()
mapping_function Table id bigserial 19 nextval('seq_mapping_function_id'::regclass)
data Table update_user int8 19 null
aggregate_definition Table update_date timestamptz 35 clock_timestamp()
data_field Table create_user int8 19 null
mapping Table create_user int8 19 null
dictionary Table column_delimiter text 2147483647 null
dictionary Table create_date timestamptz 35 clock_timestamp()
row Table create_date timestamptz 35 clock_timestamp()
conversion Table create_date timestamptz 35 clock_timestamp()
user_profile Table username text 2147483647 null
map Table label text 2147483647 null
mapping_function Table update_user int8 19 null
data_field Table create_date timestamptz 35 clock_timestamp()
field Table min_occurrence int4 10 1
row Table position text 2147483647 null
data_field Table data_type_id int8 19 null
dictionary Table row_length int8 19 null
error_level Table create_date timestamptz 35 clock_timestamp()
data_row Table id bigserial 19 nextval('seq_data_row_id'::regclass)
row Table label text 2147483647 null
conversion Table target_data_id int8 19 null
customer Table identifier text 2147483647 null
conversion_chain Table update_user int8 19 null
mapping_function Table mapping_id int8 19 null
dictionary Table update_date timestamptz 35 clock_timestamp()
map Table script_mime_type text 2147483647 'text/javascript'::text
customer Table update_user int8 19 null
row Table parent_row_id int8 19 null
field Table length int8 19 null
user_profile Table customer_id int8 19 null
user_profile Table create_user int8 19 null
error_level Table identifier text 2147483647 null
dictionary Table field_delimiter text 2147483647 null
data_row Table update_user int8 19 null
conversion_chain Table create_date timestamptz 35 clock_timestamp()
error_level Table update_user int8 19 null
function_definition Table update_date timestamptz 35 clock_timestamp()
data_row Table skip_row bool 1 false
customer Table create_date timestamptz 35 clock_timestamp()
map Table create_date timestamptz 35 clock_timestamp()
row Table next_row_id int8 19 null
function_definition Table create_user int8 19 null
dictionary Table customer_id int8 19 null
field Table aggregate_row_id int8 19 null
conversion Table end_time timestamptz 35 null
map Table customer_id int8 19 null
conversion_map_chain Table create_user int8 19 null
field Table create_user int8 19 null
dictionary Table label text 2147483647 null
field Table update_date timestamptz 35 clock_timestamp()
conversion Table update_date timestamptz 35 clock_timestamp()
conversion_map_chain Table update_date timestamptz 35 clock_timestamp()
rule Table rule_definition_id int8 19 null
map Table create_user int8 19 null
data_type Table update_date timestamptz 35 clock_timestamp()
error_level Table update_date timestamptz 35 clock_timestamp()
customer Table create_user int8 19 null
dynamic_field Table field_id int8 19 null
conversion Table start_time timestamptz 35 clock_timestamp()
data Table dictionary_id int8 19 null
dynamic_field Table update_date timestamptz 35 clock_timestamp()
data_format Table data_type_id int8 19 null
conversion_map_chain Table create_date timestamptz 35 clock_timestamp()
data_field Table data_row_id int8 19 null
conversion Table target_data_size int8 19 0
mapping Table update_date timestamptz 35 clock_timestamp()
row Table max_occurrence int4 10 1
data_row Table line_index int8 19 null
field Table create_date timestamptz 35 clock_timestamp()
mapping_function Table function_definition_id int8 19 null
error_level Table create_user int8 19 null
data_type Table identifier text 2147483647 null
dictionary Table create_header bool 1 false
data_row Table line text 2147483647 null
data_format Table update_date timestamptz 35 clock_timestamp()
field Table position int4 10 null
dynamic_field Table dynamic_field_order int4 10 null
row Table update_user int8 19 null
map Table script text 2147483647 null
customer Table update_date timestamp 29 clock_timestamp()
conversion Table target_data_path text 2147483647 null
aggregate_definition Table id bigserial 19 nextval('seq_aggregate_definition_id'::regclass)
dictionary Table id bigserial 19 nextval('seq_dictionary_id'::regclass)
data_field Table field_id int8 19 null
dictionary Table skip_lines int8 19 0
field Table row_id int8 19 null
data_row Table create_date timestamptz 35 clock_timestamp()
conversion_map_chain Table map_id int8 19 null
conversion Table source_data_size int8 19 0
data_field Table update_user int8 19 null
dynamic_field Table data_type_id int8 19 null
rule Table field_id int8 19 null
map Table id bigserial 19 nextval('seq_map_id'::regclass)
data Table create_user int8 19 null
customer Table company_name text 2147483647 null
rule_definition Table update_user int8 19 null