11 Replies Latest reply on Nov 9, 2005 5:13 PM by Gavin King

    When will we be able to make a primary key comprised of fore


      I am trying to represent a database object similar to the tomcat role authentication.


      CREATE TABLE `myTest` (
       `user` varchar(128) NOT NULL,
       `role` varchar(15) NOT NULL,
       PRIMARY KEY (`user`,`role`),
       CONSTRAINT `FK_user` FOREIGN KEY (`user`) REFERENCES `tableOne` (`user`) ,
       CONSTRAINT `FK_role` FOREIGN KEY (`role`) REFERENCES `tableTwo` (`role`)

      Each column is a foreign key to another table, and the primary key is both columns.

      How do I create a par representation of this?