Re: multiple foreign key references on one column

2003-10-02 Thread dobbo
Quoting Roman Neuhauser [EMAIL PROTECTED]: # [EMAIL PROTECTED] / 2003-09-25 14:59:33 +0100: CREATE TABLE `pheno` ( `id` smallint(5) unsigned NOT NULL auto_increment, `relevant` enum('y','n') default NULL, `phenotype` varchar(50) NOT NULL default '', PRIMARY KEY

Re: multiple foreign key references on one column

2003-09-26 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-09-25 14:59:33 +0100: CREATE TABLE `pheno` ( `id` smallint(5) unsigned NOT NULL auto_increment, `relevant` enum('y','n') default NULL, `phenotype` varchar(50) NOT NULL default '', PRIMARY KEY (`id`,`phenotype`), KEY `id` (`id`), CONSTRAINT `0_125`

multiple foreign key references on one column

2003-09-25 Thread dobbo
Hi, I have three tables. One of the tables has a column that is a foreign key that references columns from the other two tables. This table is shown below. CREATE TABLE `pheno` ( `id` smallint(5) unsigned NOT NULL auto_increment, `relevant` enum('y','n') default NULL, `phenotype`