action.survey_question

↑ action schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('action.survey_question_id_seq'::regclass)
survey FK	`integer`	No		→ action.survey(id)
question	`text`	No

id PK

integer

nextval('action.survey_question_id_seq'::regclass)

survey FK

integer

→ action.survey(id)

question

text

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`survey`	action.survey(id)	NO ACTION	NO ACTION	DEFERRED	`survey_question_survey_fkey`

survey

action.survey(id)

NO ACTION

DEFERRED

survey_question_survey_fkey

Indexes

Index Method Definition

Index	Method	Definition
`survey_question_pkey` PK	btree	`CREATE UNIQUE INDEX survey_question_pkey ON action.survey_question USING btree (id)`

survey_question_pkey PK

btree

CREATE UNIQUE INDEX survey_question_pkey ON action.survey_question USING btree (id)

Referenced By

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
action.survey_answer	`question`	`id`	`survey_answer_question_fkey`
action.survey_response	`question`	`id`	`survey_response_question_fkey`

action.survey_answer

question

id

survey_answer_question_fkey

action.survey_response

question

id

survey_response_question_fkey