History: Project Management - Existing table tiki_user_tasks_history

!::Existing table: tiki_user_tasks_history::
---
!!!Tables:
The existing fields in this existing table are as follows:

||__::Field::__|__::Type::__|__::Null::__|__::Default::__|__::Comments::__
belongs_to| int(14) | No |  | the taskId that this history record belongs to
task_version| int(4) | No | 0 | 
title| varchar(250) | No |  | 
description| text | Yes | NULL |
start| int(14) | Yes | NULL |
end| int(14) | Yes | NULL |
lasteditor| varchar(200) | No | |
lastchanges| int(14) | No | |
priority| int(2) | No | 3 | 
completed| int(14) | Yes | NULL | 
deleted| int(14) | yes | NULL |
status| char(1) | Yes | NULL | 
percentage| int(4) | Yes | NULL |
accepted_creator| char(1) | Yes | NULL |
accepted_user| char(1) | Yes | NULL |
 ||

Additional fields may need to be added to this existing 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:

||__::Field::__|__::Type::__|__::Null::__|__::Default::__|__::Comments::__
All existing fields remain the same| - | - | - | - 
 ||

!!!Indexes:
Existing indexes:

||__::Keyname::__|__::Type::__|__::Cardinality::__|__::FieldId(s)::__
PRIMARY| PRIMARY | 1 | belongs_to + task_version
 ||

New Indexes:

||__::Keyname::__|__::Type::__|__::Cardinality::__|__::FieldId(s)::__
 |   |   | 

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