WorkFerret/tables/rate: Difference between revisions

From Woozle Writes Code
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…')
 
m (9 revisions imported: moving from htyp)
 
(8 intermediate revisions by the same user not shown)
Line 2: Line 2:
* '''History''':
* '''History''':
** '''2010-01-29''' Adapted from MS Access version
** '''2010-01-29''' Adapted from MS Access version
* '''Fields''':
** '''2010-01-30''' changed isActive from BOOL to BIT(1) because that's what "boolean" apparently exports as
** '''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
** '''2010-03-05''' added isLineItem so that purchases on same day can still be listed separately
** '''2010-03-11''' Changed PerHour so it could be NULL -- some "rates" are for non-rate charges, e.g. purchases or preset fee
** '''2013-06-14''' ID_Proj is about to be obsoleted by the {{l/same|rate_proj}} table.
** '''2013-10-31''' Removing ID_Proj
==SQL==
==SQL==
<mysql>DROP TABLE IF EXISTS `session`;
<mysql>DROP TABLE IF EXISTS `rate`;
CREATE TABLE  `session` (
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",
   `Name`      VARCHAR(63)     NOT NULL COMMENT "brief name for rate (for lists)",
   `Name`      VARCHAR(63) NOT NULL COMMENT "brief name for rate (for lists)",
   `PerHour`    DECIMAL(9,2) DEFAULT NULL COMMENT "cost per hour",
   `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",
   `isActive`  BOOL    DEFAULT FALSE COMMENT "TRUE = still in use; FALSE = only use in history",
  `isLineItem` BIT(1)      DEFAULT FALSE COMMENT "TRUE = don't consolidate this session by date",
   PRIMARY KEY(`ID`)
   PRIMARY KEY(`ID`)
) ENGINE=MyISAM;</mysql>
) ENGINE=MyISAM;</mysql>

Latest revision as of 20:32, 1 May 2022

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
    • 2010-03-05 added isLineItem so that purchases on same day can still be listed separately
    • 2010-03-11 Changed PerHour so it could be NULL -- some "rates" are for non-rate charges, e.g. purchases or preset fee
    • 2013-06-14 ID_Proj is about to be obsoleted by the rate_proj table.
    • 2013-10-31 Removing ID_Proj

SQL

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

 `ID`         INT(4)           NOT NULL AUTO_INCREMENT,
 `Name`       VARCHAR(63)      NOT NULL COMMENT "brief name for rate (for lists)",
 `PerHour`    DECIMAL(9,2) DEFAULT NULL COMMENT "cost per hour",
 `isActive`   BIT(1)      DEFAULT FALSE COMMENT "TRUE = still in use; FALSE = only use in history",
 `isLineItem` BIT(1)      DEFAULT FALSE COMMENT "TRUE = don't consolidate this session by date",
  PRIMARY KEY(`ID`)

) ENGINE=MyISAM;</mysql>

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