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
# [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`
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`