action.survey

↑ action schema

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('action.survey_id_seq'::regclass)

owner FK

integer

No

→ actor.org_unit(id)

start_date

timestamp with time zone

No

now()

end_date

timestamp with time zone

No

(now() + '10 years'::interval)

usr_summary

boolean

No

false

opac

boolean

No

false

poll

boolean

No

false

required

boolean

No

false

name

text

No

description

text

No

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

owner

actor.org_unit(id)

NO ACTION

NO ACTION

DEFERRED

survey_owner_fkey

Indexes

Index Method Definition

survey_pkey PK

btree

CREATE UNIQUE INDEX survey_pkey ON action.survey USING btree (id)

asv_once_per_owner_idx UNIQUE

btree

CREATE UNIQUE INDEX asv_once_per_owner_idx ON action.survey USING btree (owner, name)

Referenced By

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

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

action.survey_question

survey

id

survey_question_survey_fkey

action.survey_response

survey

id

survey_response_survey_fkey
Previous
Next