SchemaSpy - Table harbinger.public.scheduling_tasks

Legend:

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

external_systems.id

scheduling_task_external_system_fk R

task_identifier

text

2147483647

scheduling_task_grouping_id

int8

19

scheduling_task_groupings.id

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

Indexes:

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