Data model for timesheet to task and/or timesheet to project? -

-

let's want make simple project tracking system. manager can create project. can create tasks project. team members can record hours work each task or project whole.

is following design t_timesheet table idea?

timesheet_id - primary key, autoincrement project_id - not null, foreign key constraint t_project task_id - nullable, foreign key constraint t_task user_id - not null, foreign key constraint t_user hours - decimal

or should this:

timesheet_id - primary key, autoincrement task_id - not null, foreign key constraint t_task user_id - not null, foreign key constraint t_user hours - decimal

in second option, intend have record in t_task labelled "miscellaneous items" foreign key relevant t_project record. i'll able track hours project aren't particular task.

are of ideas above good? better?

while believe nullable foreign keys have place in relational databases, in case tend towards second option.

  1. forces project manager explicitly create "micellaneous items" task per project make them decide if makes sense project in question or not.

  2. allows project manager call catch task whatever want.

  3. will user interface there won't need special case assign work against project directly , not task.

  4. will make writing reports easier developers have deal less complicated database model.


Comments

Post a Comment

Popular posts from this blog

javascript - Enclosure Memory Copies -

-
function myclass() { //lots , lots of vars , code here. this.bar = function() { //do numerous enclosed myclass vars } this.foo = function() { alert('hello'); //don't enclosed variables. } } each instance of myclass gets own copy of bar , foo, why prototyped methods use less memory. however, know more memory use of inner methods. it seems obvious me (1) below must true. agree? not distinct myclass instances have own distinct copies of bar, must have own distinct copies of myclass enclosure. (or else how bar method keep myclass variables straight on per instance basis?) now (2) question i'm after. since inner foo method doesn't use in myclass enclosure natural qustion is: javascript smart enough not keep myclass enclosure in memory use of foo? this depend entirely on implementation not language. naive implementations keep far more around others. answer true e.g. v8 (chrome's js engine) may not true spider...
Read more

php - Replacing tags in braces, even nested tags, with regex -

-
example preg_replace('/\{[a-za-z.,\(\)0-9]+\}/', 'replaced', 'lorem ipsum dolor sit {tag1({tag2()})}, consectetur adipiscing elit.'); the result: lorem ipsum dolor sit {tag1(replaced)}, consectetur adipiscing elit. question as can see "tag2" has been replaced, want replace "tag1" know how can this? (in cases might this: {tag1({tag2({tag3()})})}) , on.) btw using preg_replace_callback, easier show preg_replace here site can test code: http://www.spaweditor.com/scripts/regex/index.php you need add curly braces character set. here's pattern used: /\{[a-za-z.,\(\)\{\}0-9]+\}/ and here result: "lorem ipsum dolor sit replaced, consectetur adipiscing elit."
Read more