Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Sidebar
model:reporttemplate
Table of Contents
Table reporttemplate
Remarks
A report template is a model of a report created with ActivityInfo. All its columns are defined with the xml column.
Schema
| Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
| :——— | :——— | :————- | :—————- | :—————- | :———— |
| reporttemplateid | integer | X | X | This is the primary key of the table. | |
| datedeleted | timestamp(0) | This is the date the report was deleted. | |||
| day | integer | It corresponds to a day of a week. | |||
| description | text | This is a description of the report. | |||
| frequency | character varying(255) | It corresponds to the frequency of each report. | |||
| title | character varying(255) | This is the title of the report set by the xml field <title> | |||
| visibility | integer | It defines the visibility of the report. | |||
| xml | text | X | This is the xml document that defines the report. | ||
| databaseid | integer | X | userdatabase(databaseid) | This is a foreign key to the table userdatabase. | |
| owneruserid | integer | X | userlogin(userid) | This is a foreign key to the table userlogin. |
Diagram
model/reporttemplate.txt · Last modified: 2016/01/11 21:38 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
