Displaying 2 results from an estimated 2 matches for "is_produc".
Did you mean:
is_producer
2006 Sep 25
3
Subclasses - help required
Hello all and hoping for some insight
a project manger type of application, staff are assigned to projects,
but each staff has varied roles for different projects... STI does not
seem to be applicable here
Imagine a table staffs...
id int
name varchar
blah....
is_manager int 1
is_engineer int 1
is_producer int 1
and projects...
id
name
manager_id
engineer_id
producer_id
how is the best way to subclass manager, engineer, and producer from
class:staff??
cheers
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you...
2006 Jan 16
0
belongs_to with has_and_belongs_to_many
...project_name text not null unique
, created_by integer not null
references members (member_id)
);
create table projects__members (
project_id integer not null
references projects(project_id)
, member_id integer not null
references members(member_id)
, is_producer boolean not null default false
, is_active boolean not null default true
, unique (project_id, member_id)
);
From looking at the SQL that gets called, a statement like
@member.projects.find(:all) appears to be doing something like
select projects.*
from members
join projects on (m...