reporter.output_folder

↑ reporter schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: output_folder_owner_fkey, output_folder_parent_fkey, output_folder_share_with_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('reporter.output_folder_id_seq'::regclass)

parent FK

integer

Yes

→ reporter.output_folder(id)

owner FK

integer

No

→ actor.usr(id)

create_time

timestamp with time zone

No

now()

name

text

No

shared

boolean

No

false

simple_reporter

boolean

No

false

share_with FK

integer

Yes

→ actor.org_unit(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

owner

actor.usr(id)

NO ACTION

NO ACTION

DEFERRED

output_folder_owner_fkey

parent

reporter.output_folder(id)

NO ACTION

NO ACTION

DEFERRED

output_folder_parent_fkey

share_with

actor.org_unit(id)

NO ACTION

NO ACTION

DEFERRED

output_folder_share_with_fkey

Indexes

Index Method Definition

output_folder_pkey PK

btree

CREATE UNIQUE INDEX output_folder_pkey ON reporter.output_folder USING btree (id)

rpt_output_folder_once_idx UNIQUE

btree

CREATE UNIQUE INDEX rpt_output_folder_once_idx ON reporter.output_folder USING btree (name, owner, simple_reporter) WHERE (parent IS NULL)

rpt_output_folder_once_parent_idx UNIQUE

btree

CREATE UNIQUE INDEX rpt_output_folder_once_parent_idx ON reporter.output_folder USING btree (name, parent)

rpt_output_fldr_owner_idx

btree

CREATE INDEX rpt_output_fldr_owner_idx ON reporter.output_folder USING btree (owner)

Referenced By

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

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

reporter.output_folder

parent

id

output_folder_parent_fkey

reporter.schedule

folder

id

schedule_folder_fkey
Previous
Next