Deliverables database table
From TaskDepender
(→Actions) |
(→Description) |
||
Line 4: | Line 4: | ||
The deliverable component is described in [[Task_Management_Method#Deliverable|"Task Management Method"]]. The deliverables in the project are stored in a table in the project database. Since the name does not have to be unique, a deliverable has to have a unique id which can be generated as a integer primary key [http://www.sqlite.org/lang_createtable.html#rowid] by the database [http://www.sqlite.org/lang_createtable.html#rowid]. Since a deliverable 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 deliverable component is described in [[Task_Management_Method#Deliverable|"Task Management Method"]]. The deliverables in the project are stored in a table in the project database. Since the name does not have to be unique, a deliverable has to have a unique id which can be generated as a integer primary key [http://www.sqlite.org/lang_createtable.html#rowid] by the database [http://www.sqlite.org/lang_createtable.html#rowid]. Since a deliverable 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. | ||
+ | |||
+ | == Constraints == | ||
The following constraints apply for the deliverables table: | The following constraints apply for the deliverables table: | ||
* 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 the connection between the parent and the connected task is deleted, | + | * When the connection between the parent and the connected task is deleted, a [[Clone|cloned deliverable]] must be deleted as well. |
* When a deliverable is deleted, all its connections are deleted as well. | * When a deliverable is deleted, all its connections are deleted as well. | ||
== Design == | == Design == | ||
− | + | The <tt>Deliverables</tt> table has the following fields: | |
− | + | ||
− | The | + | |
{| valign="top" border="1" cellpadding="3" cellspacing="0" | {| valign="top" border="1" cellpadding="3" cellspacing="0" | ||
Line 43: | Line 43: | ||
|} | |} | ||
− | |||
− | + | The following actions are defined: | |
− | * [[Deliverables database table - Create|Create]] | + | * [[Deliverables database table - Create|Create]] |
* [[Deliverables database table - Insert|Insert]] | * [[Deliverables database table - Insert|Insert]] | ||
− | |||
− | |||
* [[Deliverables database table - Update|Update]] | * [[Deliverables database table - Update|Update]] | ||
− | + | * [[Deliverables database table - Delete|Delete]] | |
− | * [[Deliverables database table - Delete|Delete]] | + | |
− | + | ||
* [[Deliverables database table - Cut|Cut]] | * [[Deliverables database table - Cut|Cut]] | ||
− | |||
* [[Deliverables database table - Paste|Paste]] | * [[Deliverables database table - Paste|Paste]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
---- | ---- | ||
* [[Database]] | * [[Database]] |