Project Management - Existing table tiki_user_tasks
Existing table: tiki_user_tasks
Tables:
The existing fields in the this existing table are as follows:
Field | Type | Null | Default | Comments
|
| taskId | int(14) | No | ||
| last_version | int(4) | No | 0 | |
| user | varchar(200) | No | ||
| creator | varchar(200) | No | ||
| public_for_group | varchar(30) | Yes | NULL | |
| rights_by_creator | char(1) | Yes | NULL | y indicates only the creator can delete |
| created | int(14) | No | ||
| status | char(1) | Yes | NULL | |
| priority | int(2) | Yes | NULL | |
| completed | int(14) | Yes | NULL | |
| percentage | int(4) | Yes | NULL | |
Additional fields need to be added to this existing Table e.g. projectid, which defaults to -1 and denotes that the associated task is used in the existing ad-hoc/non-project oriented way ie this provides backwards capability for existing data.
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:
Field | Type | Null | Default | Comments
|
| All existing fields remain the same | - | - | - | - |
| projectId | int(14) | No | -1 | For backward compatibility projectId=-1 equates to the existing ad hoc use of tasks |
| milestone | char(1) | No | n | Set to y if Task is a designated milestone |
| activity | varchar(200) | No | Activity designator for Work Breakdown Structure (WBS) analysis | |
| work_required | int(4) | No | ||
| work_units | char(1) | No | h | minutes (m), hours (h), days (d), weeks (w) or months (m) with a default of hours |
| effort_applied | int(3) | No | percentage in 10% increments | |
| duration | int(4) | No | ||
| duration_units | char(1) | No | d | minutes (m), hours (h), days (d), weeks (w) or months (m) with a default of days |
Indexes:
Existing indexes:
Keyname | Type | Cardinality | FieldId(s)
| |
| PRIMARY | PRIMARY | 1 | taskId | |
| creator | UNIQUE | 1 | creator + created | |
New Indexes:
Keyname | Type | Cardinality | FieldId(s)
| |
Table of contents for section:
Table of contents for main document: