Project Management - New table tiki_projects_tasklinks
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:
Table of contents for main document: