SchemaSpy Analysis of transmart.ts_batch - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Wed Jun 26 00:12 CEST 2019
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

transmart.ts_batch contains 47 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
batch_job_execution create_time timestamp 29,6
batch_job_execution end_time timestamp 29,6  √  null
batch_job_execution exit_code varchar 2500  √  null
batch_job_execution exit_message varchar 2500  √  null
batch_job_execution job_configuration_location varchar 2500  √  null
batch_job_execution job_execution_id int8 19
batch_job_execution job_instance_id int8 19
batch_job_execution last_updated timestamp 29,6  √  null
batch_job_execution start_time timestamp 29,6  √  null
batch_job_execution status varchar 10  √  null
batch_job_execution version int8 19  √  null
batch_job_execution_context job_execution_id int8 19
batch_job_execution_context serialized_context text 2147483647  √  null
batch_job_execution_context short_context varchar 2500
batch_job_execution_params date_val timestamp 29,6  √  null
batch_job_execution_params double_val float8 17,17  √  null
batch_job_execution_params identifying bpchar 1
batch_job_execution_params job_execution_id int8 19
batch_job_execution_params key_name varchar 100
batch_job_execution_params long_val int8 19  √  null
batch_job_execution_params string_val varchar 250  √  null
batch_job_execution_params type_cd varchar 6
batch_job_instance job_instance_id int8 19
batch_job_instance job_key varchar 32
batch_job_instance job_name varchar 100
batch_job_instance version int8 19  √  null
batch_step_execution commit_count int8 19  √  null
batch_step_execution end_time timestamp 29,6  √  null
batch_step_execution exit_code varchar 2500  √  null
batch_step_execution exit_message varchar 2500  √  null
batch_step_execution filter_count int8 19  √  null
batch_step_execution job_execution_id int8 19
batch_step_execution last_updated timestamp 29,6  √  null
batch_step_execution process_skip_count int8 19  √  null
batch_step_execution read_count int8 19  √  null
batch_step_execution read_skip_count int8 19  √  null
batch_step_execution rollback_count int8 19  √  null
batch_step_execution start_time timestamp 29,6
batch_step_execution status varchar 10  √  null
batch_step_execution step_execution_id int8 19
batch_step_execution step_name varchar 100
batch_step_execution version int8 19
batch_step_execution write_count int8 19  √  null
batch_step_execution write_skip_count int8 19  √  null
batch_step_execution_context serialized_context text 2147483647  √  null
batch_step_execution_context short_context varchar 2500
batch_step_execution_context step_execution_id int8 19