obj_synonyms

namespace: SMRUCC.genomics.Data.Regtransbase.MySQL

DROP TABLE IF EXISTS obj_synonyms;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE obj_synonyms (
pkg_guid int(11) NOT NULL DEFAULT ‘0’,
art_guid int(11) NOT NULL DEFAULT ‘0’,
obj_guid int(11) NOT NULL DEFAULT ‘0’,
syn_name varchar(50) NOT NULL DEFAULT ‘’,
fl_real_name int(1) DEFAULT NULL,
PRIMARY KEY (obj_guid,syn_name),
KEY pkg_guid (pkg_guid),
KEY art_guid (art_guid),
CONSTRAINT obj_synonyms_ibfk_1 FOREIGN KEY (pkg_guid) REFERENCES packages (pkg_guid),
CONSTRAINT obj_synonyms_ibfk_2 FOREIGN KEY (art_guid) REFERENCES articles (art_guid),
CONSTRAINT obj_synonyms_ibfk_3 FOREIGN KEY (obj_guid) REFERENCES obj_name_genomes (obj_guid)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/!40101 SET character_set_client = @saved_cs_client /;