search for: completed_at

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 |...