--------------------------------------------------------------------------
-- Play this script in PRUEBAS@VISANY to make it look like DESA@VISMAR
--                                                                      --
-- Please review the script before using it to make sure it won't       --
-- cause any unacceptable data loss.                                    --
--                                                                      --
-- PRUEBAS@VISANY Schema Extracted by User PRUEBAS 
-- DESA@VISMAR Schema Extracted by User DESA 

--
-- SEG_MATRIZ  (View) 
--

ALTER TABLE SEG_GRANT
 ADD CONSTRAINT GENCOMPANIA_GRANT_FK 
 FOREIGN KEY (COD_CIA) 
 REFERENCES GEN_COMPANIA (COD_CIA);

ALTER TABLE SEG_GRANT
 ADD CONSTRAINT SEG_GRUPO_SEGGR_GRUPO_FK 
 FOREIGN KEY (COD_GRUPO) 
 REFERENCES SEG_GRUPO (COD_GRUPO);

ALTER TABLE SEG_MNUMNU
 ADD CONSTRAINT SEGMNUMOD_MNUMNU_FK 
 FOREIGN KEY (MODID) 
 REFERENCES SEG_MNUMOD (MODID);

ALTER TABLE SEG_MNUITM
 ADD CONSTRAINT SEGMNUMNU_MNUITM_FK 
 FOREIGN KEY (MODID, PARENTID) 
 REFERENCES SEG_MNUMNU (MODID,ITEMID);

_