WorkFerret/tables/rate proj: Difference between revisions
< WorkFerret | tables
Jump to navigation
Jump to search
(Created page with "==About== * '''Purpose''': determines which rates are available for which projects * '''History''': ** '''2013-06-06''' Design work started. ==SQL== <mysql>CREATE TABLE `rate...") |
m (4 revisions imported: moving from htyp) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
* '''History''': | * '''History''': | ||
** '''2013-06-06''' Design work started. | ** '''2013-06-06''' Design work started. | ||
** '''2013-06-07''' Editing interface working. | |||
** '''2013-06-14''' Fixed bug in editing interface; update Rates drop-down in Project to use this table. | |||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE `rate_proj` ( | <mysql>CREATE TABLE `rate_proj` ( | ||
ID_Rate INT(4) NOT NULL, | ID_Rate INT(4) NOT NULL, | ||
ID_Proj INT(4) NOT NULL | ID_Proj INT(4) NOT NULL, | ||
PRIMARY KEY(`ID_Rate`,`ID_Proj`) | |||
) ENGINE=MyISAM;</mysql> | ) ENGINE=MyISAM;</mysql> | ||
Latest revision as of 20:32, 1 May 2022
About
- Purpose: determines which rates are available for which projects
- History:
- 2013-06-06 Design work started.
- 2013-06-07 Editing interface working.
- 2013-06-14 Fixed bug in editing interface; update Rates drop-down in Project to use this table.
SQL
<mysql>CREATE TABLE `rate_proj` (
ID_Rate INT(4) NOT NULL, ID_Proj INT(4) NOT NULL, PRIMARY KEY(`ID_Rate`,`ID_Proj`)
) ENGINE=MyISAM;</mysql>