SchemaSpy Analysis of transmart.ts_batch - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Wed Jun 26 00:12 CEST 2019 |
| ||||||
|
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 |