GMOD / CMAP - Genetic & Comparative Maps

CMap 0.11

Tables

cmap_attribute
cmap_feature
cmap_correspondence_evidence
cmap_map_set
cmap_xref
cmap_feature_alias
cmap_correspondence_matrix
cmap_feature_correspondence
cmap_map
cmap_correspondence_lookup
cmap_next_number
cmap_species
Comments:

MySQL dump 8.23
Host: localhost Database: CMAPTEST
-------------------------------------------------------
Server version 4.0.16-standard-log
Table structure for table `cmap_attribute`
Field Name Data Type Size Default Value Other Foreign Key
attribute_id int 11 0 PRIMARY KEY, NOT NULL
table_name varchar 30 NOT NULL
object_id int 11 0 NOT NULL
display_order int 11 1 NOT NULL
is_public tinyint 4 1 NOT NULL
attribute_name varchar 200 NOT NULL
attribute_value text 65535 NOT NULL

Indices

Name Fields
table_name table_name, object_id, display_order, attribute_name
Comments:

Table structure for table `cmap_correspondence_evidence`
Field Name Data Type Size Default Value Other Foreign Key
correspondence_evidence_id int 11 0 PRIMARY KEY, NOT NULL
accession_id varchar 20 UNIQUE, NOT NULL
feature_correspondence_id int 11 0 NOT NULL
evidence_type_accession varchar 20 0 NOT NULL
score double 8,2 NULL
rank int 11 0 NOT NULL

Indices

Name Fields
feature_correspondence_id feature_correspondence_id
Comments:

Table structure for table `cmap_correspondence_lookup`
Field Name Data Type Size Default Value Other Foreign Key
feature_id1 int 11 NULL
feature_id2 int 11 NULL
feature_correspondence_id int 11 NULL
start_position1 double 11,2 NULL
start_position2 double 11,2 NULL
stop_position1 double 11,2 NULL
stop_position2 double 11,2 NULL
map_id1 int 11 NULL
map_id2 int 11 NULL
feature_type_accession1 varchar 20 NULL
feature_type_accession2 varchar 20 NULL

Indices

Name Fields
feature_id1 feature_id1
corr_id feature_correspondence_id
cl_map_id1 map_id1
cl_map_id2 map_id2
cl_map_id1_map_id2 map_id1, map_id2
cl_map_id2_map_id1 map_id2, map_id1
Comments:

Table structure for table `cmap_correspondence_matrix`
Field Name Data Type Size Default Value Other Foreign Key
reference_map_aid varchar 20 0 NOT NULL
reference_map_name varchar 32 NOT NULL
reference_map_set_aid varchar 20 0 NOT NULL
reference_species_aid varchar 20 0 NOT NULL
link_map_aid varchar 20 NULL
link_map_name varchar 32 NULL
link_map_set_aid varchar 20 0 NOT NULL
link_species_aid varchar 20 0 NOT NULL
no_correspondences int 11 0 NOT NULL
Comments:

Table structure for table `cmap_feature`
Field Name Data Type Size Default Value Other Foreign Key
feature_id int 11 0 PRIMARY KEY, NOT NULL
accession_id varchar 20 UNIQUE, NOT NULL
map_id int 11 0 NOT NULL
feature_type_accession varchar 20 0 NOT NULL
feature_name varchar 32 NOT NULL
is_landmark tinyint 4 0 NOT NULL
start_position double 11,2 0.00 NOT NULL
stop_position double 11,2 NULL
default_rank int 11 1 NOT NULL
direction tinyint 4 1 NOT NULL

Indices

Name Fields
feature_name feature_name
feature_id_map_id feature_id, map_id
feature_id_map_id_start feature_id, map_id, start_position
map_id map_id
map_id_feature_id map_id, feature_id
Comments:

Table structure for table `cmap_feature_alias`
Field Name Data Type Size Default Value Other Foreign Key
feature_alias_id int 11 0 PRIMARY KEY, NOT NULL
feature_id int 11 0 UNIQUE, NOT NULL
alias varchar 255 NULL UNIQUE

Indices

Name Fields
feature_id feature_id
alias alias
Comments:

Table structure for table `cmap_feature_correspondence`
Field Name Data Type Size Default Value Other Foreign Key
feature_correspondence_id int 11 0 PRIMARY KEY, NOT NULL
accession_id varchar 20 UNIQUE, NOT NULL
feature_id1 int 11 0 NOT NULL
feature_id2 int 11 0 NOT NULL
is_enabled tinyint 4 1 NOT NULL

Indices

Name Fields
feature_id1 feature_id1
cmap_feature_corresp_idx is_enabled, feature_correspondence_id
Comments:

Table structure for table `cmap_map`
Field Name Data Type Size Default Value Other Foreign Key
map_id int 11 0 PRIMARY KEY, UNIQUE, NOT NULL
accession_id varchar 20 UNIQUE, NOT NULL
map_set_id int 11 0 UNIQUE, NOT NULL
map_name varchar 32 UNIQUE, NOT NULL
display_order int 11 1 NOT NULL
start_position double 11,2 NULL
stop_position double 11,2 NULL

Indices

Name Fields
map_set_id_index map_set_id
Comments:

Table structure for table `cmap_map_set`
Field Name Data Type Size Default Value Other Foreign Key
map_set_id int 11 0 PRIMARY KEY, UNIQUE, NOT NULL
accession_id varchar 20 UNIQUE, NOT NULL
map_set_name varchar 64 NOT NULL
short_name varchar 30 UNIQUE, NOT NULL
map_type_accession varchar 20 0 NOT NULL
species_id int 11 0 UNIQUE, NOT NULL
published_on date 0 NULL
can_be_reference_map tinyint 4 1 NOT NULL
display_order int 11 1 NOT NULL
is_enabled tinyint 4 1 NOT NULL
shape varchar 12 NULL
color varchar 20 NULL
width int 11 NULL
map_units varchar 12 NOT NULL
is_relational_map tinyint 11 0 NOT NULL

Indices

Name Fields
cmap_map_set_idx can_be_reference_map, is_enabled, species_id, display_order, published_on, short_name
Comments:

Table structure for table `cmap_next_number`
Field Name Data Type Size Default Value Other Foreign Key
table_name varchar 40 PRIMARY KEY, NOT NULL
next_number int 11 0 NOT NULL
Comments:

Table structure for table `cmap_species`
Field Name Data Type Size Default Value Other Foreign Key
species_id int 11 0 PRIMARY KEY, NOT NULL
accession_id varchar 20 NOT NULL
common_name varchar 64 NOT NULL
full_name varchar 64 NOT NULL
display_order int 11 1 NOT NULL

Indices

Name Fields
acc_id_species_id accession_id, species_id
Comments:

Table structure for table `cmap_xref`
Field Name Data Type Size Default Value Other Foreign Key
xref_id int 11 0 PRIMARY KEY, NOT NULL
table_name varchar 30 NOT NULL
object_id int 11 NULL
display_order int 11 1 NOT NULL
xref_name varchar 200 NOT NULL
xref_url text 65535 NOT NULL

Indices

Name Fields
table_name table_name, object_id, display_order
Created by SQL::Translator