snapshots_lb


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_fkeyR
record_creation_status.job_execution_id record_creation_status_job_execution_id_fkeyR
records_lb.snapshot_id records_lb_snapshot_id_fkeyR
job_execution_progress__t.job_execution_id job_execution_progress__t_job_execution_id_fkeyR
job_execution_source_chunks__t.job_execution_id job_execution_source_chunks__t_job_execution_id_fkeyR
job_executions__t.parent_job_id job_executions__t_parent_job_id_fkeyR
journal_records.job_execution_id journal_records_job_execution_id_fkeyR
status varchar 19 √ null
processing_started_date timestamptz 35,6 √ null
created_by_user_id uuid 2147483647 √ null
users__t.id snapshots_lb_created_by_user_id_fkeyR
created_date timestamptz 35,6 √ null
updated_by_user_id uuid 2147483647 √ null
users__t.id snapshots_lb_updated_by_user_id_fkeyR
updated_date timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
snapshots_lb_pkey Primary key Asc id
snapshots_lb___origin_idx Performance Asc __origin
snapshots_lb___source_idx Performance Asc __source
snapshots_lb___start_idx Performance Asc __start
snapshots_lb_created_by_user_id_idx Performance Asc created_by_user_id
snapshots_lb_created_date_idx Performance Asc created_date
snapshots_lb_id_idx Performance Asc id
snapshots_lb_processing_started_date_idx Performance Asc processing_started_date
snapshots_lb_status_idx Performance Asc status
snapshots_lb_updated_by_user_id_idx Performance Asc updated_by_user_id
snapshots_lb_updated_date_idx Performance Asc updated_date

Relationships

Close relationships within degrees of separation