reporter.report

↑ reporter schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: report_folder_fkey, report_owner_fkey, report_template_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('reporter.report_id_seq'::regclass)

owner FK

integer

No

→ actor.usr(id)

create_time

timestamp with time zone

No

now()

name

text

No

''::text

description

text

No

''::text

template FK

integer

No

→ reporter.template(id)

data

text

No

folder FK

integer

No

→ reporter.report_folder(id)

recur

boolean

No

false

recurrence

interval

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

folder

reporter.report_folder(id)

NO ACTION

NO ACTION

DEFERRED

report_folder_fkey

owner

actor.usr(id)

NO ACTION

NO ACTION

DEFERRED

report_owner_fkey

template

reporter.template(id)

NO ACTION

NO ACTION

DEFERRED

report_template_fkey

Indexes

Index Method Definition

report_pkey PK

btree

CREATE UNIQUE INDEX report_pkey ON reporter.report USING btree (id)

rtp_report_folder_once_idx UNIQUE

btree

CREATE UNIQUE INDEX rtp_report_folder_once_idx ON reporter.report USING btree (name, folder)

rpt_rpt_fldr_idx

btree

CREATE INDEX rpt_rpt_fldr_idx ON reporter.report USING btree (folder)

rpt_rpt_owner_idx

btree

CREATE INDEX rpt_rpt_owner_idx ON reporter.report USING btree (owner)

Referenced By

The following tables have foreign keys pointing to reporter.report (1 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

reporter.schedule

report

id

schedule_report_fkey
Previous
Next