# 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](userdatabase)(databaseid) | This is a foreign key to the table userdatabase. |
| owneruserid | integer  | X            |                 | [userlogin](userlogin)(userid) | This is a foreign key to the table userlogin. |

## Diagram ##
{{url>http://wiki.sigmah.org/svg_load.php?file=reporttemplate.svg 900px,550px noborder}}