View source for WorkFerret/tables/rate

==About==
* '''History''':
** '''2010-01-29''' Adapted from MS Access version
** '''2010-01-30''' changed isActive from BOOL to BIT(1) because that's what "boolean" apparently exports as
* '''Fields''':
** '''ID_Proj''' designates the outermost project for this rate; rate can also be used in sub-projects of this project, but not in parent projects
==SQL==
<mysql>DROP TABLE IF EXISTS `rate`;
CREATE TABLE  `rate` (
  `ID`         INT(4)       NOT NULL AUTO_INCREMENT,
  `ID_Proj`    INT(4)   DEFAULT NULL COMMENT "Project in which this rate can be used",
  `Name`       VARCHAR(63)  NOT NULL COMMENT "brief name for rate (for lists)",
  `PerHour`    DECIMAL(9,2) NOT NULL COMMENT "cost per hour",
  `isActive`   BIT(1)    DEFAULT FALSE COMMENT "TRUE = still in use; FALSE = only use in history",
   PRIMARY KEY(`ID`)
) ENGINE=MyISAM;</mysql>