Difference between revisions of "WorkFerret/tables/rate proj"
Jump to navigation
Jump to search
(primary key) |
(working) |
||
| Line 3: | Line 3: | ||
* '''History''': | * '''History''': | ||
** '''2013-06-06''' Design work started. | ** '''2013-06-06''' Design work started. | ||
| + | ** '''2013-06-07''' Code working. | ||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE `rate_proj` ( | <mysql>CREATE TABLE `rate_proj` ( | ||
Revision as of 02:09, 8 June 2013
About
- Purpose: determines which rates are available for which projects
- History:
- 2013-06-06 Design work started.
- 2013-06-07 Code working.
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>