Hi Sri, Would it be possible for you to provide a more concrete example where the double-relation exists? I'd like to see how the two tables should be joined in a sensible way.
Thanks, Junjun 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
