[MOBY-l] current database schema

[Mark Wilkinson]

Here's the schema as it exists right now.  We're just setting up a
port-forward so that it is accessible from outside - it is served by the
MySQL server running on our RAID.

The schema is still "work in progress" so please do comment, and don't
hold this as gospel!

As soon as Jacek (our sysadmin) gets the port forward up and running
I'll send out the login information.

M


--
--------------------------------
"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 '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',
  xsd text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table 'OntologyEntry'
#


#
# Table structure for table 'Parameter'
#

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

#
# Dumping data for table 'Parameter'
#


#
# 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 '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'
#