Table JiveAnalytics900.public.batch_step_execution 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
step_execution_id int8 19
batch_step_execution_context.step_execution_id step_exec_ctx_fk R
version int8 19
step_name varchar 100
job_execution_id int8 19
batch_job_execution.job_execution_id job_exec_step_fk R
start_time timestamp 29,6
end_time timestamp 29,6  √  null
status varchar 10  √  null
commit_count int8 19  √  null
read_count int8 19  √  null
filter_count int8 19  √  null
write_count int8 19  √  null
read_skip_count int8 19  √  null
write_skip_count int8 19  √  null
process_skip_count int8 19  √  null
rollback_count int8 19  √  null
exit_code varchar 100  √  null
exit_message varchar 2500  √  null
last_updated timestamp 29,6  √  null

Table contained 15,687 rows at Fri Jan 13 13:27 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
step_execution_id Primary key Asc batch_step_execution_pkey

Close relationships  within of separation: