Hello Again, I am trying to setup a database with relations into biomart. I am facing a problem where there is multi-relation between the tables. For example I am trying to setup the following table with the structure
CREATE TABLE Parent ( id int(10) NOT NULL, sample varchar(10) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE Child ( id1 int(10) NOT NULL, id2 int(10) NOT NULL, relation varchar(10) NOT NULL, INDEX (id1), INDEX (id2), FOREIGN KEY (id1) REFERENCES Parent (id), FOREIGN KEY (id2) REFERENCES Parent (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; In this case, Biomart does not allow to add the database and gives an error saying "An relation already exist between these two keys" and throws out an exception. I was wondering if this can be avoided? Or how would one go about setting such relations. Thanks and Regards, Sri Krishna _______________________________________________ Users mailing list [email protected] https://lists.biomart.org/mailman/listinfo/users
