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"}