Hi Sri, Sorry that your case is not supported in the current version. We will investigate it and hopefully can add this feature in the next release.
Yong On 11-05-26 11:26 AM, "Sri Krishna Suresh Kumar" <[email protected]> wrote: > 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 _______________________________________________ Users mailing list [email protected] https://lists.biomart.org/mailman/listinfo/users
