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:
Table of contents for main document: