reporter.schedule

↑ reporter schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: schedule_folder_fkey, schedule_report_fkey, schedule_runner_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('reporter.schedule_id_seq'::regclass)

report FK

integer

No

→ reporter.report(id)

folder FK

integer

No

→ reporter.output_folder(id)

runner FK

integer

No

→ actor.usr(id)

run_time

timestamp with time zone

No

now()

start_time

timestamp with time zone

Yes

complete_time

timestamp with time zone

Yes

email

text

Yes

excel_format

boolean

No

true

html_format

boolean

No

true

csv_format

boolean

No

true

chart_pie

boolean

No

false

chart_bar

boolean

No

false

chart_line

boolean

No

false

new_record_bucket

boolean

No

false

existing_record_bucket

boolean

No

false

error_code

integer

Yes

error_text

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

folder

reporter.output_folder(id)

NO ACTION

NO ACTION

DEFERRED

schedule_folder_fkey

report

reporter.report(id)

NO ACTION

NO ACTION

DEFERRED

schedule_report_fkey

runner

actor.usr(id)

NO ACTION

NO ACTION

DEFERRED

schedule_runner_fkey

Indexes

Index Method Definition

schedule_pkey PK

btree

CREATE UNIQUE INDEX schedule_pkey ON reporter.schedule USING btree (id)

rpt_sched_recurrence_once_idx UNIQUE

btree

CREATE UNIQUE INDEX rpt_sched_recurrence_once_idx ON reporter.schedule USING btree (report, folder, runner, run_time, COALESCE(email, ''::text))

rpt_sched_folder_idx

btree

CREATE INDEX rpt_sched_folder_idx ON reporter.schedule USING btree (folder)

rpt_sched_runner_idx

btree

CREATE INDEX rpt_sched_runner_idx ON reporter.schedule USING btree (runner)
Previous
Next