Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Here is the list of all tables created in the database.
Clic on a table name for more informations.
A keyquestion is a question related to a section in a report. This question must be completed in order to valid a report.
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. |