WorkFerret/tables/project: Difference between revisions
< WorkFerret | tables
Jump to navigation
Jump to search
(Created page with '==About== * '''History''': ** '''2010-01-28''' Adapted from MS Access version ==SQL== <mysql>DROP TABLE IF EXISTS `project`; CREATE TABLE `project` ( `ID` INT(4) NO…') |
(consolidating project and account (client) tables) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''History''': | * '''History''': | ||
** '''2010-01-28''' Adapted from MS Access version | ** '''2010-01-28''' Adapted from MS Access version; consolidating WorkProject and WorkAcct tables | ||
* '''Fields''': | |||
** '''InvcPfx''': If set, this indicates that the project is billable (otherwise it's just a category or sub-project) | |||
==SQL== | ==SQL== | ||
<mysql>DROP TABLE IF EXISTS `project`; | <mysql>DROP TABLE IF EXISTS `project`; | ||
CREATE TABLE `project` ( | CREATE TABLE `project` ( | ||
`ID` INT(4) | `ID` INT(4) NOT NULL AUTO_INCREMENT, | ||
` | `ID_Parent INT(4) DEFAULT NULL COMMENT "Parent project (can be client or category)", | ||
`Name` VARCHAR(63) NOT NULL COMMENT "Name of project", | `Name` VARCHAR(63) NOT NULL COMMENT "Name of project", | ||
`InvcPfx` VARCHAR(7) DEFAULT NULL COMMENT "prefix for invoice numbers", | |||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) ENGINE=MyISAM;</mysql> | ) ENGINE=MyISAM;</mysql> | ||
Revision as of 00:32, 29 January 2010
About
- History:
- 2010-01-28 Adapted from MS Access version; consolidating WorkProject and WorkAcct tables
- Fields:
- InvcPfx: If set, this indicates that the project is billable (otherwise it's just a category or sub-project)
SQL
<mysql>DROP TABLE IF EXISTS `project`; CREATE TABLE `project` (
`ID` INT(4) NOT NULL AUTO_INCREMENT, `ID_Parent INT(4) DEFAULT NULL COMMENT "Parent project (can be client or category)", `Name` VARCHAR(63) NOT NULL COMMENT "Name of project", `InvcPfx` VARCHAR(7) DEFAULT NULL COMMENT "prefix for invoice numbers", PRIMARY KEY(`ID`)
) ENGINE=MyISAM;</mysql>