View source

__NOTOC__''This page describes the design of the database table to hold the tasks.''

== Description ==

The task element is described in the [[Task_Management_Method#Task|"Task Management Method"]]. The tasks in the project are stored in a table in the project database. The name of a task does not have to be unique, a task has to have a unique id which can be generated as a integer primary key<ref name="primary_key">[http://www.sqlite.org/lang_createtable.html#rowid rowid - SQLite specification]</ref> by the database. Since a task represents a graphical element, it has a position, a width and a height. The TaskDepender&trade; program uses a true-type font, and therefore the width and height will be determined when the task is displayed.

== Constraints ==

The following constraints apply for the tasks table:
* When a container task is deleted, the contained tasks need to be deleted as well.
* When a resource is deleted that is the responsible resource for a task, the resource is set to undefined.

== Design ==

The tasks are stored in a table with the following columns:

{| valign="top" border="1" cellpadding="3" cellspacing="0"
|- style="color:white; background-color:#000000;" |
| '''Name''' || '''Type''' || '''Description'''
|- valign="top"
| <tt>Id</tt> || integer primary key || Unique id within this tasks table.
|- valign="top"
| <tt>Name</tt> || text || [[System Data Format|SDF string]].
|- valign="top"
| <tt>Description</tt>|| text || [[System Data Format|SDF string]].
|- valign="top"
| <tt>ResourceId</tt> || integer || Id of the person responsible for the task as defined in the [[Resources database table|<tt>Resources</tt> table]].
|- valign="top"
| <tt>X</tt> || integer || The x-coordinate of the task in the diagram, expressed in pixels.
|- valign="top"
| <tt>Y</tt> || integer || The y-coordinate  of the task in the diagram, expressed in pixels.
|- valign="top"
| <tt>Width</tt> || integer || The width of the task in the diagram, expressed in pixels.
|- valign="top"
| <tt>Height</tt> || integer || The height of the task in the diagram, expressed in pixels.
|- valign="top"
| <tt>ContainerId</tt> || integer || The id of the container task. Set to 0 if defined at the top level.
|}


The following actions are defined:
* [[Tasks database table - Create|Create]]
* [[Tasks database table - Insert|Insert]]
* [[Tasks database table - Update|Update]]
* [[Tasks database table - Delete|Delete]]
* [[Tasks database table - Cut|Cut]]
* [[Tasks database table - Paste|Paste]]

== References ==
<references/>


----
* [[Database]]