Tasks database table - TaskDepender

Tasks database table

From TaskDepender
Jump to: navigation, search
(Implementation)
Line 3: Line 3:
 
== Description ==
 
== 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 does not have to be unique. Therefore, a task also has to have a unique id. Since a task represents a graphical element, it has a position, a width and a height. When using a true-type font, the width and height will be determined when the task is displayed.
+
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 does not have to be unique. Therefore, a task also has to have a unique id. Further, since a task represents a graphical element, it has a position, a width and a height. These attributes are expressed in pixels. The TaskDepender™ program uses a true-type font, and therefore the width and height will be determined when the task is displayed.
  
The following constraints apply:
+
The following constraints apply for the :
 
* When a container task is deleted, the contained tasks need to be deleted as well.
 
* 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.
 
* When a resource is deleted that is the responsible resource for a task, the resource is set to undefined.
Line 25: Line 25:
 
| <tt>ResourceId</tt> || integer || Id of the person responsible for the task as defined in the [[Resources database table|<tt>Resources</tt> table]].
 
| <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"
 
|- valign="top"
| <tt>X</tt> || integer || The x-coordinate of the task in the diagram.
+
| <tt>X</tt> || integer || The x-coordinate of the task in the diagram, expressed in pixels.
 
|- valign="top"
 
|- valign="top"
| <tt>Y</tt> || integer || The y-coordinate of the task in the diagram.
+
| <tt>Y</tt> || integer || The y-coordinate of the task in the diagram, expressed in pixels.
 
|- valign="top"
 
|- valign="top"
| <tt>Width</tt> || integer || The width of the task in the diagram.
+
| <tt>Width</tt> || integer || The width of the task in the diagram, expressed in pixels.
 
|- valign="top"
 
|- valign="top"
| <tt>Height</tt> || integer || The height of the task in the diagram.
+
| <tt>Height</tt> || integer || The height of the task in the diagram, expressed in pixels.
 
|- valign="top"
 
|- valign="top"
 
| <tt>ContainerId</tt> || integer || The id of the container task. Set to 0 if defined at the top level.
 
| <tt>ContainerId</tt> || integer || The id of the container task. Set to 0 if defined at the top level.

Revision as of 20:08, 16 November 2011

Personal tools