WorkFerret/tables/session

About

• History:
  • 2010-01-28 Adapted from MS Access version
• Fields:
  • TimeAdd: time added to (finish-start), typically an approximation for when start/finish times aren't known
  • TimeSub: time subtracted from (finish-start), typically for distractions in the middle of a work session
  • TimeTotal = WhenFinish - WhenStart + TimeAdd - TimeSub

SQL

<mysql>DROP TABLE IF EXISTS `session`; CREATE TABLE `session` (

 `ID`         INT(4)           NOT NULL AUTO_INCREMENT,  PRIMARY KEY(`ID`),
 `ID_Proj`    INT(4)           NOT NULL COMMENT "Project to which this session applies",
 `WhenStart`  DATETIME     DEFAULT NULL COMMENT "when Session started (optional)",
 `WhenFinish` DATETIME     DEFAULT NULL COMMENT "when Session finished (optional)",
 `Sort`       DECIMAL(7,4) DEFAULT NULL COMMENT "when there's no specific time, use this to sort sessions",
 `TimeAdd`    INT(4)       DEFAULT NULL COMMENT "time to add, in minutes",
 `TimeSub`    INT(4)       DEFAULT NULL COMMENT "time to subtract, in minutes",
 `TimeTotal`  INT(4)       DEFAULT NULL COMMENT "calculated total time for this session",

/* INCOMPLETE; saving work */ ) ENGINE=MyISAM;</mysql>