WorkFerret/tables/rate

From Woozle Writes Code
< WorkFerret‎ | tables
Revision as of 12:35, 29 January 2010 by Woozle (talk | contribs) (fixed name of table in SQL)
Jump to navigation Jump to search

About

  • History:
    • 2010-01-29 Adapted from MS Access version
  • 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`   BOOL    DEFAULT FALSE COMMENT "TRUE = still in use; FALSE = only use in history",
  PRIMARY KEY(`ID`)

) ENGINE=MyISAM;</mysql>

Retrieved from "https://wooz.dev/mw/index.php?title=WorkFerret/tables/rate&oldid=1400"