Table of Contents

Table question\_element

Remarks

A Question_Element corresponds to a list of choices, a ListBox for GUI designers or in a more programming vision an enumeration of strings.

Schema

Name Type Not Null Primary Key Foreign Key Remarks
:———:———:————-:—————-:—————-:————
id_flexible_element bigint X X flexible\_element(id_flexible_element) This is the primary key of the table and also a foreign key on the table flexible_element which is its parent table.
is_multiple bool It indicates if several values can be selected or only one value.
id_category_type integer X category\_type(id_category_type) This is a foreign key to the table category_type.
id_quality_criterion integer X quality\_criterion(id_quality_criterion) This is a foreign key to the table quality_criterion. It says if a question element corresponds to a question linked to a quality criterion.

Diagram