Displaying 4 results from an estimated 4 matches for "idstatussir_next".
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...
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 Plan...
2006 Jan 28
0
having problems to map a existing schema in model classes
...a user is related to many works and a work is related to many users,
no primary key in table user_work, so I don?t know what to do there
And the last one:
Table status_sir
Primary key: idstatussir
Table status_sir_next
Foreign key: idstatussir references status_sir: idstatussir
Foreign key: idstatussir_next references status_sir: idstatussir
No primary key in the table status_sir_next, so I don?t know what to do,
the idea is that if you are in state 2, then you will have two tuples in
status_sir_next:
Idstatussir: 2 Idstatussir_sig: 3
Idstatussir: 2 Idstatussir_sig: 4
So now you know that if you are...
2006 Jan 28
0
having problems to map a existing schema into model classes
...a user is related to many works and a work is related to many users,
no primary key in table user_work, so I don?t know what to do there
And the last one:
Table status_sir
Primary key: idstatussir
Table status_sir_next
Foreign key: idstatussir references status_sir: idstatussir
Foreign key: idstatussir_next references status_sir: idstatussir
No primary key in the table status_sir_next, so I don?t know what to do,
the idea is that if you are in state 2, then you will have two tuples in
status_sir_next:
Idstatussir: 2 Idstatussir_sig: 3
Idstatussir: 2 Idstatussir_sig: 4
So now you know that if you are...