Project Management - New table tiki_projects_resource_allocation
New table: tiki_projects_resource_allocation
New Table for allocating Resources to Tasks - special treatment for people ie users on the system.
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
|
| taskId | int(14) | No | task that the resource is allocated to | |
| resourceId | int(14) | No | resource that is being assigned if not an individual user - but could indicate a team | |
| user | varchar(200) | individual user being assigned as a resource | ||
| percent_allocated | int(4) | percentage of the resource being allocated | ||
Indexes:
Keyname | Type | FieldId(s)
| ||
| PRIMARY | PRIMARY | taskId + resourceId + user | ||
Table of contents for section:
Table of contents for main document: