[MOBY-l] revised database schema

[Mark Wilkinson]

attached.

--
--------------------------------
"Speed is subsittute fo accurancy."
________________________________

Dr. Mark Wilkinson
Bioinformatics Group
National Research Council of Canada
Plant Biotechnology Institute
110 Gymnasium Place
Saskatoon, SK
Canada


-------------- next part --------------
# MySQL dump 8.14
#
# Host: localhost    Database: MOBY_Central
#--------------------------------------------------------
# Server version	3.23.41

#
# Table structure for table 'Object'
#

CREATE TABLE Object (
  ontologyentry_id int(11) NOT NULL default '0',
  xsd mediumtext NOT NULL
) TYPE=MyISAM;

#
# Dumping data for table 'Object'
#


#
# Table structure for table 'Ontology'
#

CREATE TABLE Ontology (
  id int(11) NOT NULL auto_increment,
  name varchar(128) NOT NULL default '',
  description text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table 'Ontology'
#


#
# Table structure for table 'OntologyEntry'
#

CREATE TABLE OntologyEntry (
  id int(11) NOT NULL auto_increment,
  term varchar(128) NOT NULL default '',
  accession varchar(128) NOT NULL default '',
  ontology_id int(11) NOT NULL default '0',
  description text NOT NULL,
  is_obselete enum('n','y') NOT NULL default 'n',
  is_root enum('n','y') NOT NULL default 'n',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table 'OntologyEntry'
#


#
# Table structure for table 'RelationshipType'
#

CREATE TABLE RelationshipType (
  id int(11) NOT NULL auto_increment,
  type varchar(128) NOT NULL default '',
  description text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table 'RelationshipType'
#


#
# Table structure for table 'Service'
#

CREATE TABLE Service (
  id int(11) NOT NULL auto_increment,
  service_name varchar(128) NOT NULL default '',
  service_type_id int(11) NOT NULL default '0',
  auth_uri varchar(128) NOT NULL default '',
  url varchar(128) NOT NULL default '',
  description text NOT NULL,
  registration_identifier varchar(128) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table 'Service'
#


#
# Table structure for table 'ServiceParameter'
#

CREATE TABLE ServiceParameter (
  id int(11) NOT NULL auto_increment,
  service_id int(11) NOT NULL default '0',
  ontologyentry_id int(11) NOT NULL default '0',
  type enum('in','out') default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table 'ServiceParameter'
#


#
# Table structure for table 'Term2Term'
#

CREATE TABLE Term2Term (
  ontologyentry1_id int(11) NOT NULL default '0',
  ontologyentry2_id int(11) NOT NULL default '0',
  relationship_type_id int(11) NOT NULL default '0',
  is_obselete enum('n','y') default NULL
) TYPE=MyISAM;

#
# Dumping data for table 'Term2Term'
#