Tasks database table
From TaskDepender
(→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. | + | 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. |