View source

''This page describes the design of the database table holding the resources in the project.''

== Description ==

== Constraints ==

The table has no constraints.

== Design ==

The table has 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 resources table.
|- valign="top"
| <tt>Initials</tt> || text || Unique initials of the resource - as displayed above a task in the dependency diagram.
|- valign="top"
| <tt>Name</tt> || text || Full name of the resource.
|- 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 (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]]


----

* [[Database]]