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
correspondence_evidence_acc varchar 20 UNIQUE, NOT NULL
feature_correspondence_id int 11 0 NOT NULL
evidence_type_acc 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
feature_start1 double 11,2 NULL
feature_start2 double 11,2 NULL
feature_stop1 double 11,2 NULL
feature_stop2 double 11,2 NULL
map_id1 int 11 NULL
map_id2 int 11 NULL
feature_type_acc1 varchar 20 NULL
feature_type_acc2 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_acc varchar 20 0 NOT NULL
reference_map_name varchar 32 NOT NULL
reference_map_set_acc varchar 20 0 NOT NULL
reference_species_acc varchar 20 0 NOT NULL
link_map_acc varchar 20 NULL
link_map_name varchar 32 NULL
link_map_set_acc varchar 20 0 NOT NULL
link_species_acc 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
feature_acc varchar 20 UNIQUE, NOT NULL
map_id int 11 0 NOT NULL
feature_type_acc varchar 20 0 NOT NULL
feature_name varchar 32 NOT NULL
is_landmark tinyint 4 0 NOT NULL
feature_start double 11,2 0.00 NOT NULL
feature_stop 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, feature_start
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
feature_correspondence_acc 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
map_acc 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
map_start double 11,2 NULL
map_stop 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
map_set_acc varchar 20 UNIQUE, NOT NULL
map_set_name varchar 64 NOT NULL
map_set_short_name varchar 30 UNIQUE, NOT NULL
map_type_acc varchar 20 0 NOT NULL
species_id int 11 0 UNIQUE, NOT NULL
published_on date 0 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 is_relational_map, is_enabled, species_id, display_order, published_on, map_set_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
species_acc varchar 20 NOT NULL
species_common_name varchar 64 NOT NULL
species_full_name varchar 64 NOT NULL
display_order int 11 1 NOT NULL

Indices

Name Fields
acc_id_species_id species_acc, 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