search

agrihold / sagi

Sistema de Mantenimiento y Seguimiento de Documentos.
1 stars 0 forks source link

Migrar dbo.TB_RET a sgr_ret_registry #173

Open csrocha opened 11 years ago

morrillo commented 11 years ago

En lugar de actualizar la tabla sgr_ret_registry no se debe actualizar la tabla sgr_ret_registry_ids_crop_ids_rel?

morrillo commented 11 years ago

En la tabla sgr_ret_registry_ids_crop_ids_rel no estan al reves las foreign keys? crop ids no deberia relacionarse cokn sgr_crop y registry_ids con sgr_ret_registry?

"sgr_ret_registry_ids_crop_ids_rel_crop_ids_fkey" FOREIGN KEY (crop_ids) REFERENCES sgr_ret_registry(id) ON DELETE CASCADE
"sgr_ret_registry_ids_crop_ids_rel_ret_registry_ids_fkey" FOREIGN KEY (ret_registry_ids) REFERENCES sgr_crop(id) ON DELETE CASCADE