WorkFerret/tables/invc line: Difference between revisions
< WorkFerret | tables
Jump to navigation
Jump to search
(Created page with '==About== * '''History''': ** '''2010-01-29''' Adapted from MS Access version ==SQL== <mysql>DROP TABLE IF EXISTS `session`; CREATE TABLE `session` ( `ID` INT(4) NOT…') |
(fixed name of table in SQL) |
||
| Line 3: | Line 3: | ||
** '''2010-01-29''' Adapted from MS Access version | ** '''2010-01-29''' Adapted from MS Access version | ||
==SQL== | ==SQL== | ||
<mysql>DROP TABLE IF EXISTS ` | <mysql>DROP TABLE IF EXISTS `invc_line`; | ||
CREATE TABLE ` | CREATE TABLE `invc_line` ( | ||
`ID` INT(4) NOT NULL AUTO_INCREMENT, | `ID` INT(4) NOT NULL AUTO_INCREMENT, | ||
`ID_Invc` INT(4) NOT NULL COMMENT "Invoice to which this line belongs", | `ID_Invc` INT(4) NOT NULL COMMENT "Invoice to which this line belongs", | ||
Revision as of 12:34, 29 January 2010
About
- History:
- 2010-01-29 Adapted from MS Access version
SQL
<mysql>DROP TABLE IF EXISTS `invc_line`; CREATE TABLE `invc_line` (
`ID` INT(4) NOT NULL AUTO_INCREMENT, `ID_Invc` INT(4) NOT NULL COMMENT "Invoice to which this line belongs", `Seq` INT(4) NOT NULL COMMENT "order in which this line was presented/added", `Date` DATETIME NOT NULL COMMENT "date which applies to this line", `What` TEXT NOT NULL COMMENT "what was done (may be text from several sessions combined)", `Qty` FLOAT DEFAULT NULL COMMENT "(optional) quantity of billable units", `Unit` VARCHAR(31) DEFAULT NULL COMMENT "(optional) description of unit -- typically 'hours'", `Rate` DECIMAL(9,2) NOT NULL COMMENT "$ per unit", `CostLine` DECIMAL(9,2) NOT NULL COMMENT "$ for this line", `CostBal` DECIMAL(9,2) NOT NULL COMMENT "$ total after this line is added", PRIMARY KEY(`ID`)
) ENGINE=MyISAM;</mysql>