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