Displaying 1 result from an estimated 1 matches for "fk_task_us".
Did you mean:
fk_task_user
2006 Apr 06
4
using two foreign keys to the same table
...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,...