Table harbinger.public.scheduling_tasks
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19  √  nextval('scheduling_tasks_id_seq'::regclass)
external_system_id int8 19 scheduling_task_external_system_fk R
task_identifier text 2147483647
scheduling_task_grouping_id int8 19 scheduling_task_scheduling_task_grouping_fk R
task_start timestamptz 35,6 now()
task_stop timestamptz 35,6 now()
task_entity_id int8 19  √  null
task_entity_table_name text 2147483647  √  null
holiday bool 1 false
deleted bool 1 false
updated_at timestamptz 35,6 now()

Analyzed at Tue Aug 16 14:31 UTC 2022

Column(s) Type Sort Constraint Name
id Primary key Asc scheduling_task_id
deleted Performance Asc scheduling_tasks_deleted_idx
external_system_id Performance Asc scheduling_tasks_external_system_id_idx
holiday Performance Asc scheduling_tasks_holiday_idx
task_entity_id Performance Asc scheduling_tasks_task_entity_id_idx
task_entity_table_name Performance Asc scheduling_tasks_task_entity_table_name_idx
scheduling_task_grouping_id Performance Asc scheduling_tasks_task_grouping_id_idx
task_identifier Performance Asc scheduling_tasks_task_identifier_idx
task_start Performance Asc scheduling_tasks_task_start_idx
task_stop Performance Asc scheduling_tasks_task_stop_idx

Close relationships  within of separation: