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 KE
# [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_12
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` varchar
