-- Relacion interaccion proteinas con enfermedades a traves de genes
DROP TABLE IF EXISTS tmp_disppi;
CREATE TABLE tmp_disppi AS
SELECT DISTINCT dp1.disease_cui, ppi.id_p1, ppi.id_p2
  FROM p_interacts_with_p ppi
       INNER JOIN edsssdb.tmp_disprot dp1
         ON ( dp1.prot_id = ppi.id_p1 )
       INNER JOIN edsssdb.tmp_disprot dp2
         ON ( dp2.prot_id = ppi.id_p2 AND dp1.disease_cui = dp2.disease_cui);
CREATE INDEX ix_tmp_disppi1 ON tmp_disppi ( id_p1, id_p2, disease_cui );
CREATE INDEX ix_tmp_disppi2 ON tmp_disppi ( disease_cui, id_p1, id_p2 );