
----------------------------------------------------------------
--
-- Table creation scripts for class cds
--

----------------------------------------------------------------
--
-- Schema
--

----------------------------------------------------------------
--
-- Main table - cds
--
CREATE TABLE cds
	(
		id                               	VARCHAR(32)	NOT NULL PRIMARY KEY,
		geneid                           	VARCHAR(255),
		contig                           	VARCHAR(255),
		description                      	VARCHAR(255),
		end_pos                          	VARCHAR(255),
		name                             	VARCHAR(255),
		organism                         	VARCHAR(255),
		position                         	VARCHAR(255),
		source                           	VARCHAR(255),
		start_pos                        	VARCHAR(255),
		strand                           	VARCHAR(255),
		type                             	VARCHAR(255)
	)
;

----------------------------------------------------------------
--
-- Multivalue field - cds_go="goid
--
CREATE TABLE cds_go="goid
	(
		id                               	VARCHAR(32)	NOT NULL,
		go="goid                         	VARCHAR(255)
	)
;
CREATE INDEX cds_go="goid_id_index ON cds_go="goid (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_charge
--
CREATE TABLE cds_charge
	(
		id                               	VARCHAR(32)	NOT NULL,
		charge                           	VARCHAR(255)
	)
;
CREATE INDEX cds_charge_id_index ON cds_charge (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_codon_start
--
CREATE TABLE cds_codon_start
	(
		id                               	VARCHAR(32)	NOT NULL,
		codon_start                      	VARCHAR(255)
	)
;
CREATE INDEX cds_codon_start_id_index ON cds_codon_start (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_colour
--
CREATE TABLE cds_colour
	(
		id                               	VARCHAR(32)	NOT NULL,
		colour                           	VARCHAR(255)
	)
;
CREATE INDEX cds_colour_id_index ON cds_colour (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_db_xref
--
CREATE TABLE cds_db_xref
	(
		id                               	VARCHAR(32)	NOT NULL,
		db_xref                          	VARCHAR(255)
	)
;
CREATE INDEX cds_db_xref_id_index ON cds_db_xref (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_domain
--
CREATE TABLE cds_domain
	(
		id                               	VARCHAR(32)	NOT NULL,
		domain                           	VARCHAR(255)
	)
;
CREATE INDEX cds_domain_id_index ON cds_domain (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_gpi_anchor
--
CREATE TABLE cds_gpi_anchor
	(
		id                               	VARCHAR(32)	NOT NULL,
		gpi_anchor                       	VARCHAR(255)
	)
;
CREATE INDEX cds_gpi_anchor_id_index ON cds_gpi_anchor (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_introns
--
CREATE TABLE cds_introns
	(
		id                               	VARCHAR(32)	NOT NULL,
		introns                          	VARCHAR(255)
	)
;
CREATE INDEX cds_introns_id_index ON cds_introns (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_isoelectric_point
--
CREATE TABLE cds_isoelectric_point
	(
		id                               	VARCHAR(32)	NOT NULL,
		isoelectric_point                	VARCHAR(255)
	)
;
CREATE INDEX cds_isoelectric_point_id_index ON cds_isoelectric_point (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_method
--
CREATE TABLE cds_method
	(
		id                               	VARCHAR(32)	NOT NULL,
		method                           	VARCHAR(255)
	)
;
CREATE INDEX cds_method_id_index ON cds_method (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_molecular_weight
--
CREATE TABLE cds_molecular_weight
	(
		id                               	VARCHAR(32)	NOT NULL,
		molecular_weight                 	VARCHAR(255)
	)
;
CREATE INDEX cds_molecular_weight_id_index ON cds_molecular_weight (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_names
--
CREATE TABLE cds_names
	(
		id                               	VARCHAR(32)	NOT NULL,
		names                            	VARCHAR(255),
		qualifier                        	VARCHAR(20)
	)
;
CREATE INDEX cds_names_id_index ON cds_names (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_obsolete_gene_name
--
CREATE TABLE cds_obsolete_gene_name
	(
		id                               	VARCHAR(32)	NOT NULL,
		obsolete_gene_name               	VARCHAR(255)
	)
;
CREATE INDEX cds_obsolete_gene_name_id_index ON cds_obsolete_gene_name (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_pepstat_warning
--
CREATE TABLE cds_pepstat_warning
	(
		id                               	VARCHAR(32)	NOT NULL,
		pepstat_warning                  	VARCHAR(255)
	)
;
CREATE INDEX cds_pepstat_warning_id_index ON cds_pepstat_warning (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_peptide_length
--
CREATE TABLE cds_peptide_length
	(
		id                               	VARCHAR(32)	NOT NULL,
		peptide_length                   	VARCHAR(255)
	)
;
CREATE INDEX cds_peptide_length_id_index ON cds_peptide_length (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_primary_name
--
CREATE TABLE cds_primary_name
	(
		id                               	VARCHAR(32)	NOT NULL,
		primary_name                     	VARCHAR(255)
	)
;
CREATE INDEX cds_primary_name_id_index ON cds_primary_name (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_product
--
CREATE TABLE cds_product
	(
		id                               	VARCHAR(32)	NOT NULL,
		product                          	VARCHAR(255)
	)
;
CREATE INDEX cds_product_id_index ON cds_product (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_proteinid
--
CREATE TABLE cds_proteinid
	(
		id                               	VARCHAR(32)	NOT NULL,
		proteinid                        	VARCHAR(255)
	)
;
CREATE INDEX cds_proteinid_id_index ON cds_proteinid (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_signal_peptide
--
CREATE TABLE cds_signal_peptide
	(
		id                               	VARCHAR(32)	NOT NULL,
		signal_peptide                   	VARCHAR(255)
	)
;
CREATE INDEX cds_signal_peptide_id_index ON cds_signal_peptide (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_synonyms
--
CREATE TABLE cds_synonyms
	(
		id                               	VARCHAR(32)	NOT NULL,
		synonyms                         	VARCHAR(255)
	)
;
CREATE INDEX cds_synonyms_id_index ON cds_synonyms (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_systematic_id
--
CREATE TABLE cds_systematic_id
	(
		id                               	VARCHAR(32)	NOT NULL,
		systematic_id                    	VARCHAR(255)
	)
;
CREATE INDEX cds_systematic_id_id_index ON cds_systematic_id (id);

----------------------------------------------------------------
--
-- Multivalue field - cds_temporary_systematic_id
--
CREATE TABLE cds_temporary_systematic_id
	(
		id                               	VARCHAR(32)	NOT NULL,
		temporary_systematic_id          	VARCHAR(255)
	)
;
CREATE INDEX cds_temporary_systematic_id_id_index ON cds_temporary_systematic_id (id);

----------------------------------------------------------------
--
-- Expanded attribute - cds_db_xref_exp
--
CREATE TABLE cds_db_xref_exp
	(
		id                               	VARCHAR(32)	NOT NULL,
		xref_db                          	VARCHAR(255)
	)
;
CREATE INDEX cds_db_xref_exp_id_index ON cds_db_xref_exp (id);

----------------------------------------------------------------
--
-- Expanded attribute - cds_xrefs
--
CREATE TABLE cds_xrefs
	(
		id                               	VARCHAR(32)	NOT NULL,
		external_db                      	VARCHAR(255),
		external_id                      	VARCHAR(255)
	)
;
CREATE INDEX cds_xrefs_id_index ON cds_xrefs (id);
