WorkFerret/tables/rate: Difference between revisions
< WorkFerret | tables
Jump to navigation
Jump to search
(Created page with '==About== * '''History''': ** '''2010-01-29''' Adapted from MS Access version * '''Fields''': ** '''ID_Proj''' designates the outermost project for this rate; rate can also be us…') |
(fixed name of table in SQL) |
||
| Line 5: | Line 5: | ||
** '''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 | ** '''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== | ==SQL== | ||
<mysql>DROP TABLE IF EXISTS ` | <mysql>DROP TABLE IF EXISTS `rate`; | ||
CREATE TABLE ` | CREATE TABLE `rate` ( | ||
`ID` INT(4) NOT NULL AUTO_INCREMENT, | `ID` INT(4) NOT NULL AUTO_INCREMENT, | ||
`ID_Proj` INT(4) DEFAULT NULL COMMENT "Project in which this rate can be used", | `ID_Proj` INT(4) DEFAULT NULL COMMENT "Project in which this rate can be used", | ||
Revision as of 12:35, 29 January 2010
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>