survey

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 nextval('action.survey_id_seq'::regclass)
survey_question.survey survey_question_survey_fkey R
survey_response.survey survey_response_survey_fkey R
owner int4 10 null
org_unit.id survey_owner_fkey R
start_date timestamptz 35,6 now()
end_date timestamptz 35,6 (now() + '10 years'::interval)
usr_summary bool 1 false
opac bool 1 false
poll bool 1 false
required bool 1 false
name text 2147483647 null
description text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
survey_pkey Primary key Asc id
asv_once_per_owner_idx Must be unique Asc/Asc owner + name

Relationships