Displaying 2 results from an estimated 2 matches for "id_statussir".
2006 Jan 29
0
how to map a relation?
Ok, this is the tables
create table statussir (
idstatussir primary key int auto_numeric,
description varchar(255)
);
create table statussir_next (
idstatussir int not null,
idstatussir_next not null,
foreign key idstatussir references statussir(id_statussir),
foreign key idstatussir_next references
statussir(id_statussir)
);
so, the idea is that you have many states
idstatussir description
1 Not Started
2 Assigned
3...
2006 Jan 29
0
how do I map this relation?
Ok, these are the tables
create table statussir (
idstatussir primary key int auto_numeric,
description varchar(255)
);
create table statussir_next (
idstatussir int not null,
idstatussir_next not null,
foreign key idstatussir references statussir(id_statussir),
foreign key idstatussir_next references statussir(id_statussir)
);
so, the idea is that you have many states
idstatussir description
1 Not Started
2 Assigned
3 In Planning
4 In Progress
5 Finished
6...