Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Sidebar
model:activity
Table of Contents
Table activity
Remarks
The table Activity is used to represent an indicator group used to difference each activity type these indicators can be assigned.
Schema
| Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
| :——— | :——— | :————- | :—————- | :—————- | :———— |
| activityid | integer | X | X | This is the primary key of the table. | |
| allowedit | bool | X | It indicates if this activity is editable. In Sigmah, this column is not used. | ||
| isassessment | bool | X | It indicates if this activity is an assessment. In Sigmah, this column is not used. | ||
| category | character varying(255) | It corresponds to the category of the activity. In Sigmah, this column is not used. | |||
| datedeleted | timestamp(0) | This is the date it was deleted | |||
| mapicon | character varying(255) | This is the path of the icon representing the activity on the map. In Sigmah, this column is not used. | |||
| name | character varying(45) | X | This is the label of the activity | ||
| reportingfrequency | integer | X | It corresponds to the frequency of each report, of each filling of an child indicator. In Sigmah, this column is not used. | ||
| sortorder | integer | X | It corresponds to the order it will be displayed | ||
| databaseid | integer | X | userdatabase(databaseid) | This is a foreign key to the table userdatabase. | |
| locationtypeid | integer | X | locationtype(locationtypeid) | This is a foreign key to the table Location. |
Diagram
model/activity.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
