journal_records


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
job_executions__t.id Implied ConstraintR
job_execution_id uuid 2147483647 √ null
snapshots_lb.id journal_records_job_execution_id_fkeyR
job_executions__t.id journal_records_job_execution_id_fkey1R
source_id uuid 2147483647 √ null
job_executions__t.id Implied ConstraintR
entity_type varchar 18 √ null
entity_id varchar 36 √ null
entity_hrid varchar 8 √ null
action_type varchar 9 √ null
action_status varchar 9 √ null
action_date timestamp 29,6 √ null
source_record_order int4 10 √ null
error varchar 236 √ null
title varchar 1015 √ null

Indexes

Constraint Name Type Sort Column(s)
journal_records_pkey Primary key Asc __id
journal_records___origin_idx Performance Asc __origin
journal_records___source_idx Performance Asc __source
journal_records___start_idx Performance Asc __start
journal_records_action_date_idx Performance Asc action_date
journal_records_action_status_idx Performance Asc action_status
journal_records_action_type_idx Performance Asc action_type
journal_records_entity_hrid_idx Performance Asc entity_hrid
journal_records_entity_id_idx Performance Asc entity_id
journal_records_entity_type_idx Performance Asc entity_type
journal_records_error_idx Performance Asc error
journal_records_id_idx Performance Asc id
journal_records_job_execution_id_idx Performance Asc job_execution_id
journal_records_source_id_idx Performance Asc source_id
journal_records_source_record_order_idx Performance Asc source_record_order
journal_records_title_idx Performance Asc title

Relationships

Close relationships within degrees of separation