search for: _tasks_

...t has a field for the creator, and another field for the assignee. both of these fields reference the users table. obviously i can''t have two fields that say user_id in my tasks table, so how do i get them to link right and specify a different field? here is my current database schema: _Tasks_ id int not null auto_increment, task_name varchar(100) not null, description text not null, user_id int not null, assignee int not null, date_due date not null, completed_at datetime not null, constraint fk_task_user foreign key (user_id) references users(id), constraint fk_task_a...