Loading...
 
Skip to main content

History: Project Management - New table tiki_projects_team_members

Source of version: 2 (current)

Copy to clipboard
!::New table: tiki_projects_team members::
---
New table that is used to capture which users are part of a project team as a Resource.

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::__
resourceId| int(14) | No |  | resource - which in this case indicates a team of users
user| varchar(200) |  |  | individual user that is a member of this resource team
 ||

!!!Indexes:
||__::Keyname::__|__::Type::__|__::FieldId(s)::__
PRIMARY| PRIMARY | 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"}
Show PHP error messages