Difference between revisions of "WorkFerret/tables/rate proj"
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...") |
(primary key) |
||
| Line 6: | Line 6: | ||
<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> | ||
Revision as of 01:19, 7 June 2013
About
- Purpose: determines which rates are available for which projects
- History:
- 2013-06-06 Design work started.
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>