History: Project Management - New table tiki_projects

!::New table: tiki_projects::
---
New table that allows a hierarchical project structure to be created so that projects can have sub-projects and be part of an overall programme. This new Project table is similar in layout to the existing Task Table.

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::__
projectId| int(14) | No | 0 | sequentially assigned by system
child_of| int(14) | No | -1 | parent projectId to allow project hierarchy. If set to -1 then this project is the top level of an overall programme and may have sub projects
creator| varchar(200) | No |  | userId of the project creator
created| int(14) | No |  | time stamp when project is created
project_manager| varchar(200) | No |  | userId of the assigned project manager
last_version| int(4) | No | 0 | tracks which is the latest version in table tiki_projects_history
started| int(14) |  |  | time stamp for formal project start date
actual_complete| int(14) |  |  | time stamp for project actual completion date
 ||

!!!Indexes:
||__::Keyname::__|__::Type::__|__::FieldId(s)::__
PRIMARY| PRIMARY | projectId + child_of
creator| UNIQUE | creator + created
 ||

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