History: 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:{toc pagename="Project Management - DB Table design" maxdepth="1"}

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