Displaying 2 results from an estimated 2 matches for "completed_at".
Did you mean:
completed_
2006 Apr 06
4
using two foreign keys to the same table
...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_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)...
2006 Jul 02
2
Problems implementing a N:M table that contains actual data
...o do.
+-------+ +-------------+ +-----+
|clients|----------|clients_steps|-------------|steps|
+-------+ +-------------+ +-----+
|id |
|client_id |
|step_id |
|completed_at |
+-------------+
|
+--------------+
|documents |
+--------------+
|client_step_id|
| more |
| fields |...