From: Petr Pícha <ppicha@xxxxxxxxxxx>
Table issue in the database lacks some attributes commonly found
in many issue-tracking tools, and potentially useful for analyses.
Add following attributes to table issue:
- issueType - type of the issue (e.g. bug, enhancement, task,
feature, etc.)
- title - short string characterizing the issue for developers
- description - detailed description of the issue
- startDate - date when the work on the issue should start (not
earlier); can differ from creation date, e.g. if planning ahead
(for next iteration/release)
- dueDate - date by which the issue should be resolved
- estimatedTime - time (in man-hours) estimated to be invested for
resolving the issue
- spentTime - time (in man-hours) actually spent on resolving the
issue (so far)
- progress - (estimated) percentage of the issue done so far
- category - used as a secondary classification (after issueType) or
for other purposes (e.g. discipline or target component of the issue)
Any other custom fields of an issue (customization is allowed in many
issue-tracking tools) are still stored via issue- and field_change tables
data and therefore no information is lost. Attributes of the table
field_change old- and newValue need to be expanded to LONGTEXT data type
to capture potential changes of issue's description.
Signed-off-by: Petr Pícha <ppicha@xxxxxxxxxxx>
Signed-off-by: Wolfgang Mauerer <wolfgang.mauerer@xxxxxxxxxxxxxxxxx>
---
datamodel/codeface.mwb | Bin 61536 -> 62448 bytes
datamodel/codeface_schema.sql | 15 ++++++++++++---
2 files changed, 12 insertions(+), 3 deletions(-)
diff --git a/datamodel/codeface.mwb b/datamodel/codeface.mwb
index f48fc5f..8aa29a4 100644
Binary files a/datamodel/codeface.mwb and b/datamodel/codeface.mwb differ
diff --git a/datamodel/codeface_schema.sql b/datamodel/codeface_schema.sql
index 6c30dd0..067617a 100644
--- a/datamodel/codeface_schema.sql
+++ b/datamodel/codeface_schema.sql
@@ -1,5 +1,5 @@
-- MySQL Script generated by MySQL Workbench
--- 11/28/16 17:27:09
+-- 11/28/16 17:39:48
-- Model: New Model Version: 1.0
-- MySQL Workbench Forward Engineering
@@ -79,6 +79,15 @@ CREATE TABLE IF NOT EXISTS `codeface`.`issue` (
`assignedTo` BIGINT NULL DEFAULT NULL,
`projectId` BIGINT NOT NULL,
`version` VARCHAR(45) NULL DEFAULT NULL,
+ `issueType` VARCHAR(45) NOT NULL,
+ `title` VARCHAR(255) NOT NULL,
+ `description` LONGTEXT NULL DEFAULT NULL,
+ `startDate` DATE NULL DEFAULT NULL,
+ `dueDate` DATE NULL DEFAULT NULL,
+ `estimatedTime` DECIMAL NULL DEFAULT NULL,
+ `spentTime` DECIMAL NOT NULL,
+ `progress` INT NOT NULL,
+ `category` VARCHAR(45) NULL DEFAULT NULL,
PRIMARY KEY (`id`),
CONSTRAINT `issue_createdBy`
FOREIGN KEY (`createdBy`)
@@ -1021,8 +1030,8 @@ DROP TABLE IF EXISTS `codeface`.`field_change` ;
CREATE TABLE IF NOT EXISTS `codeface`.`field_change` (
`id` BIGINT NOT NULL,
`field` VARCHAR(45) NOT NULL,
- `oldValue` VARCHAR(45) NULL DEFAULT NULL,
- `newValue` VARCHAR(45) NULL DEFAULT NULL,
+ `oldValue` LONGTEXT NULL DEFAULT NULL,
+ `newValue` LONGTEXT NULL DEFAULT NULL,
`issueChangeId` BIGINT NOT NULL,
PRIMARY KEY (`id`),
CONSTRAINT `field_change_issue_change`
--
2.8.3