WorkFerret/tables/project

About

• History:
  • 2010-01-28 Adapted from MS Access version; consolidating WorkProject and WorkAcct tables
  • 2013-06-07 Added isActive field.
  • 2013-06-09 Changed isActive default from FALSE to b'1' (TRUE); added Notes field.
  • 2014-03-10 Adding ID_Rate
• Fields:
  • ID_Rate: default Rate for new sessions
    • Ideally this should be something individual users can set, but that requires a "user preferences" infrastructure that should probably be part of the framework rather than provided by individual applications.
  • InvcPfx: If set, this indicates that the project is billable (otherwise it's just a category or sub-project)
  • isActive: This field can be set FALSE for inactive projects, to reduce clutter in various lists.

SQL

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

 `ID`        INT(4)           NOT NULL AUTO_INCREMENT,
 `ID_Parent` INT(4)       DEFAULT NULL COMMENT "Parent project (can be client or category)",
 `Name`      VARCHAR(63)      NOT NULL COMMENT "Name of project",
 `ID_Rate`   INT(4)       DEFAULT NULL COMMENT "ID of default rate to use for new sessions",
 `Notes`     VARCHAR(255) DEFAULT NULL COMMENT "human-entered notes",
 `InvcPfx`   VARCHAR(7)   DEFAULT NULL COMMENT "prefix for invoice numbers",
 `isActive`  BIT(1)       DEFAULT b'1' COMMENT "TRUE = currently in use; FALSE = don't include in most lists",
 PRIMARY KEY(`ID`)

) ENGINE=MyISAM;</mysql>