action.survey_answer

↑ action schema

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

Columns

Column Type Nullable Default Notes

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

id PK

integer

nextval('action.survey_answer_id_seq'::regclass)

question FK

integer

→ action.survey_question(id)

answer

text

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`question`	action.survey_question(id)	NO ACTION	NO ACTION	DEFERRED	`survey_answer_question_fkey`

question

action.survey_question(id)

NO ACTION

DEFERRED

survey_answer_question_fkey

Indexes

Index Method Definition

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

survey_answer_pkey PK

btree

CREATE UNIQUE INDEX survey_answer_pkey ON action.survey_answer USING btree (id)

Referenced By

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
action.survey_response	`answer`	`id`	`survey_response_answer_fkey`

action.survey_response

answer

id

survey_response_answer_fkey