Tasks database table
From TaskDepender
(→Design) |
(→Design) |
||
Line 19: | Line 19: | ||
| <tt>Description</tt>|| text || [[System Data Format|SDF string]]. | | <tt>Description</tt>|| text || [[System Data Format|SDF string]]. | ||
|- valign="top" | |- valign="top" | ||
− | | <tt>ResourceId</tt> || | + | | <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. | ||
Line 28: | Line 28: | ||
|} | |} | ||
+ | There is one constraint on the table that states that when the resource with the <tt>ResourceId</tt> is deleted, the value of the <tt>ResourceId</tt> is to be set to NULL. | ||
The following actions are defined on the tasks table: | The following actions are defined on the tasks table: |