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.
This table contains all sections related to a projectReportModel. Indeed, a report is composed of several sections.
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. | |||
name | character varying(255) | It corresponds to an human-readable name for the section. | |||
numberoftextarea | integer | It defines the number of text area that will be displayed under the section. It can be compared to the number of paragraph of this section. | |||
parentsectionmodelid | integer | X | projectreportmodelsection(id) | This is a foreign key to a projectReportModelSection beacause a section can be under another section. | |
projectmodelid | integer | projectreportmodel(id) | This is a foreign key to the table ProjectReportModel. |