Loading...
 
Skip to main content

History: Project Management - New table tiki_projects_tasklinks

Source of version: 2 (current)

Copy to clipboard
!::New table: tiki_projects_tasklinks::
---
New Table that allows a task sequencing to be maintained.

All the new fields identified so far are as follows, but this is highly likely to be changed/refined once the development is under way:

!!!Tables:
||__::Field::__|__::Type::__|__::Null::__|__::Default::__|__::Comments::__
predecessor_task| int(14) | No |  | task that is before the current task in sequence
current_task| int(14) | No |  | task that is selected
predecessor_type| char(2) | No | ES | 'End-to-Start' (ES), 'Start-to-Start' (SS) or 'End-to-End' (EE )
task_delay| int(4)| No | 0 | Delay or Lag before the current Task starts which is applied for the 'End-to-Start' and 'Start-to-Start' cases
 ||

!!!Indexes:
||__::Keyname::__|__::Type::__|__::FieldId(s)::__
PRIMARY| PRIMARY | predecessor_task + current_task
 ||

Table of contents for section:{toc pagename="Project Management - DB Table design" maxdepth="1"}

Table of contents for main document:{toc pagename="Project Management Development" maxdepth="1"}
Show PHP error messages