WorkFerret/tables/project

From Woozle Writes Code
< WorkFerret‎ | tables
Revision as of 00:32, 29 January 2010 by Woozle (talk | contribs) (consolidating project and account (client) tables)
Jump to navigation Jump to search

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>

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