User Tools

Site Tools


Sidebar

Table listing

Here is the list of all tables created in the database.

Clic on a table name for more informations.

model:keyquestion

Table keyquestion

Remarks

A keyquestion is a question related to a section in a report. This question must be completed in order to valid a report.

Schema

Name Type Not Null Primary Key Foreign Key Remarks
:———:———:————-:—————-:—————-:————
id integer X X This is the primary key of the table.
sort_order integer It corresponds to the order it will be displayed.
label character varying(255) This is a human readable name for the question.
sectionid integer X projectreportmodelsection(id) This is a foreign key to the table ProjectReportModelSection.
qualitycriterion_id_quality_criterion integer X quality\_criterion(id_quality_criterion) This is a foreign key to the table quality_criterion. It is not actually used in Sigmah.

Diagram

model/keyquestion.txt · Last modified: 2016/01/11 21:38 (external edit)