job_executions__t


Columns

Column Type Size Nulls Auto Default Children Parents Comments
__id int8 19 √ null
__cf bool 1 true
__start timestamptz 35,6 null
__source varchar 63 null
__origin varchar 63 ''::character varying
id uuid 2147483647 null
upload_definitions__t.meta_job_execution_id upload_definitions__t_meta_job_execution_id_fkey1R
record_creation_status.job_execution_id record_creation_status_job_execution_id_fkey1R
job_execution_progress.id Implied ConstraintR
job_execution_progress__t.id Implied ConstraintR
job_execution_progress__t.job_execution_id job_execution_progress__t_job_execution_id_fkey1R
job_execution_source_chunks.id Implied ConstraintR
job_execution_source_chunks__t.id Implied ConstraintR
job_execution_source_chunks__t.job_execution_id job_execution_source_chunks__t_job_execution_id_fkey1R
job_executions.id Implied ConstraintR
job_monitoring.id Implied ConstraintR
job_monitoring.job_execution_id Implied ConstraintR
journal_records.id Implied ConstraintR
journal_records.job_execution_id journal_records_job_execution_id_fkey1R
journal_records.source_id Implied ConstraintR
mapping_params_snapshots.job_execution_id Implied ConstraintR
mapping_params_snapshots__t.job_execution_id Implied ConstraintR
mapping_rules.id Implied ConstraintR
mapping_rules__t.id Implied ConstraintR
mapping_rules_snapshots.job_execution_id Implied ConstraintR
mapping_rules_snapshots__t.job_execution_id Implied ConstraintR
source_records_state.id Implied ConstraintR
source_records_state__t.id Implied ConstraintR
hr_id numeric 131089 √ null
status varchar 19 √ null
user_id uuid 2147483647 √ null
users__t.id job_executions__t_user_id_fkeyR
started_date timestamptz 35,6 √ null
completed_date timestamptz 35,6 √ null
ui_status varchar 16 √ null
parent_job_id uuid 2147483647 √ null
snapshots_lb.id job_executions__t_parent_job_id_fkeyR
subordination_type varchar 13 √ null
file_name varchar 45 √ null
source_path varchar 45 √ null

Indexes

Constraint Name Type Sort Column(s)
job_executions__t_pkey Primary key Asc id
job_executions__t___origin_idx Performance Asc __origin
job_executions__t___source_idx Performance Asc __source
job_executions__t___start_idx Performance Asc __start
job_executions__t_completed_date_idx Performance Asc completed_date
job_executions__t_file_name_idx Performance Asc file_name
job_executions__t_hr_id_idx Performance Asc hr_id
job_executions__t_id_idx Performance Asc id
job_executions__t_parent_job_id_idx Performance Asc parent_job_id
job_executions__t_source_path_idx Performance Asc source_path
job_executions__t_started_date_idx Performance Asc started_date
job_executions__t_status_idx Performance Asc status
job_executions__t_subordination_type_idx Performance Asc subordination_type
job_executions__t_ui_status_idx Performance Asc ui_status
job_executions__t_user_id_idx Performance Asc user_id

Relationships

Close relationships within degrees of separation