Displaying 1 result from an estimated 1 matches for "primary_support_id".
2006 Apr 04
1
What is the best way to handle this? It''s not a good use of the new Polymorphic-Association thingy is it?
...have the following
(showing just the fields I''m really interested in here):
CREATE TABLE requests
(
id int not null auto_increment,
created_by_id int not null,
last_updated_by_id int,
primary_customer_id int,
primary_support_id int,
:
:
constraint fk_requests_creator foreign key (created_by_id) references
users(id),
constraint fk_requests_updater foreign key (last_updated_by_id)
references users(id),
constraint fk_requests_customer foreign key (primary_customer_id)
references users(id),...