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.
• Fields:
  • 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",
 `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>