Resources database table
From TaskDepender
(Created page with "''This page describes the design of the database table holding the resources in the project.'' == Description == == Design == The table has the following columns: {| valign=...") |
|||
Line 3: | Line 3: | ||
== Description == | == Description == | ||
+ | == Constraints == | ||
+ | |||
+ | The table has no constraints. | ||
== Design == | == Design == | ||
Line 12: | Line 15: | ||
| '''Name''' || '''Type''' || '''Description''' | | '''Name''' || '''Type''' || '''Description''' | ||
|- valign="top" | |- valign="top" | ||
− | | <tt>Id</tt> || integer primary key || Unique id within this | + | | <tt>Id</tt> || integer primary key || Unique id within this resources table. |
|- valign="top" | |- valign="top" | ||
− | | <tt> | + | | <tt>Initials</tt> || text || Unique initials of the resource - as displayed above a task in the dependency diagram. |
|- valign="top" | |- valign="top" | ||
− | | <tt> | + | | <tt>Name</tt> || text || Full name of the resource. |
|- valign="top" | |- valign="top" | ||
− | | <tt>Notification</tt> || text || The URL that will be executed when the status of a dependency changes of a task for which the resource is responsible. | + | | <tt>Notification</tt> || text || The URL that will be executed when the status of a dependency changes of a task for which the resource is responsible (for example: mailto:fred@company.com). |
|} | |} | ||
− | |||
+ | The following actions are defined: | ||
+ | * [[Resources database table - Create|Create]] | ||
+ | * [[Resources database table - Insert|Insert]] | ||
+ | * [[Resources database table - Update|Update]] | ||
+ | * [[Resources database table - Delete|Delete]] | ||