search for: fk_task_user

...ght 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_assignee foreign key (assignee) references users(id), _Users_ id int not null auto_increment, username varchar(20) not null, password varchar(20) not null, full_name varchar(100) not null, email varchar(150) not null, pr...