Table examples

Gene
number
INT
PRIMARY KEY
name
VARCHAR
NOT NULL
species
VARCHAR
NOT NULL
chromosome
VARCHAR
first
INT
last
INT
1 'Son of sevenless' 'Drosophila melanogaster' 'II' 123456 124891
24 'OB' 'Homo sapiens' '21' 900001 899023
11 'OB' 'Mus musculus' '6' NULL NULL
12 'Toll' 'Drosophila melanogaster' 'III' 3049580 3049952




Protein
number
INT
PRIMARY KEY
name
VARCHAR
NOT NULL
species
VARCHAR
gene
INT
FK*
seqlength
INT
seq
CLOB
3 'leptin' 'Homo sapiens' 24 301 ANCDTLKER...
25 'myoglobin' 'Mus musculus' NULL 158 MHAGBQWTT...
11 'peptide X341' NULL NULL 13 DFVLPQWDFGGGA

FK* = Foreign key: column 'gene' refers to column 'number' in table 'Gene'.


© 2001 Per Kraulis $Date: 2001/05/09 15:01:31 $