search for: idstatussir

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

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

...Table user_work: Foreign key iduser references user: iduser Foreign key idwork references work: idwork So, 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 st...

...Table user_work: Foreign key iduser references user: iduser Foreign key idwork references work: idwork So, 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 st...