Deliverables database table
From TaskDepender
(→Design) |
(→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. | ||
Line 41: | Line 43: | ||
|} | |} | ||
− | |||
The following actions are defined: | The following actions are defined: |