preset_refresh_runs


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('workbench.preset_refresh_runs_id_seq'::regclass)
preset_sync_states.last_run_id preset_sync_states_last_run_id_fkey R
preset_key text 2147483647 null
preset_sync_states.preset_key Implied Constraint R
target_table text 2147483647 null
started_at timestamptz 35,6 null
finished_at timestamptz 35,6 √ null
status text 2147483647 null
rows_read int8 19 √ null
rows_inserted int8 19 √ null
rows_updated int8 19 √ null
rows_deleted int8 19 √ null
duration_ms int8 19 √ null
error_message text 2147483647 √ null
created_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
preset_refresh_runs_pkey Primary key Asc id
idx_wb_refresh_runs_preset_finished Performance Asc/Desc preset_key + finished_at

Check Constraints

Constraint Name Constraint
preset_refresh_runs_status_check ((status = ANY (ARRAY['running'::text, 'success'::text, 'failed'::text])))

Relationships

Close relationships within degrees of separation