Displaying 1 result from an estimated 1 matches for "fk_requests_creator".
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?
...;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),
    constraint fk_requests_support    foreign key (primary...