[Biodevelopers] database schema of OMIM.

[Jeroen Van Goey]

Hi,
I want to put the OMIM databse locally on my computer.
I downloaded the file genemap from
ftp://ftp.ncbi.nih.gov/repository/OMIM/ It contains a
list of fields, separated by the '|' character. An
example is:

1.1|9|11|95|1pter-p36.13|CCV|P|Cataract, congenital,
Volkmann
type||115665|Fd|linked to Rh in Scottish
family||Cataract, congenital,
Volkmann type (2)| | ||
1.2|9|25|01|1pter-p36.13|ENO1, PPH, MPB1|C|Enolase-1,
alpha||172430|S,
F, R, REa|||Enolase deficiency (1)| | |4(Eno1)|
1.3|10|23|87|1pter-p36.13|GDH|C|Glucose
dehydrogenase||138090|S, F||||
| ||
...

The fields are, in order :

1  - Numbering system, in the format 
Chromosome.Map_Entry_Number
2  - Month entered
3  - Day     "
4  - Year    "
5  - Location
6  - Gene Symbol(s)
7  - Gene Status (see below for codes)
8  - Title
9  - 
10 - MIM Number
11 - Method (see below for codes)
12 - Comments
13 -
14 - Disorders
15 - Disorders, cont.
16 - Disorders, cont
17 - Mouse correlate
18 - Reference

I now want to 
CREATE TABLE genemap (
 Chromosome.Map_Entry_Number VARCHAR(??)
 Month_entered ????(?)
 ...
 )
but I'm a bit unsure as of what
parameters to use (VARCHAR, INTEGER,...), and what the
values are of these
parameters.

So, has anybody done this before, or can you point me
to a place where I can the database schema of OMIM?  A
visual representation (like the physical model of
dbSNP, see
http://www.ncbi.nlm.nih.gov/SNP/dbSNP_work000401_gif_frame.htm)
or table structure forms (like in the GoldenPath
database, see
http://genome.ucsc.edu/goldenPath/hg16/database/),
would be perfect.

Thanks in advance, Jeroen

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com