MoMaVis - Supplemental Material

© Copyright 2003-2006 IPK Gatersleben. All rights reserved.

Data Base Schema

ER-Schema:

Using the tables VIS_CULTIVAR and VIS_POPULATION various mapping populations could be stored. All possible populations are connected over the foreign key POPULATION_ID into the mapping table VIS_MAPPING_DATA. When this value is 0, then MoMaVis interpretes this population as a consensus map.

Using entries in the column MARKER_ID of the table VIS_MAPPING_DATA connections to internal marker identifiers could be modelled and stored.

The column MARKER_TYPE codes the type of a marker. In the existing data set the following code is used:

MARKER_TYPEour marker type
1RFLP
2SSR
3SNP
0Public Domain Marker

Within the jnlp-File this definition could be rearranged, by editing the follwing line:

--markertypes=0,Public,0x808080;1,RFLP,0x0000FF;2,SSR,0x00FF00;3,SNP,0xFF0000

The columns CHROMOSOMEN_LOCATION and MAP_POSITION store the actual mapping information.

Database Dumps

Author: Uwe Scholz
Document: index.html, v 1.00 2005/09/23 12:00:58