WorkFerret/tables/rate proj

From Woozle Writes Code
Jump to navigation Jump to search

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>