DATABASE RELATIONS SSS.doc (Word Document)

 

 

taxonomy.xls

 

genus.dbf

 

record.dbf

1

2

3

genus

 

genus

 

colno

x

x

x

nofam

 

nofam

 

genus

x

x

x

familia

 

familia

 

species

x

x

x

nosupfam

 

nosupfam

 

author

x

x

x

superfam

 

superfam

 

nofam

x

x

x

 

classis

 

familia

x

x

x

 

page

 

nosupfam

x

 

 

 

 

 

superfam

x

x

x

 

superfam.dbf

 

classis

x

 

 

 

 

nosupfam

 

n

x

x

x

 

 

superfam

 

nature

x

x

 

locality.dbf

 

classis

 

dim

x

x

x

locality

 

 

 

quality

x

 

 

number

 

 

 

locality

x

x

x

longname

 

 

 

region

x

x

x

region

 

 

 

country

x

x

x

depart

 

 

 

subformat

x

 

 

country

 

 

 

formation

x

x

x

coord

 

 

 

epoch

x

x

x

subformat

 

 

 

period

x

x

x

formation

 

 

 

label

x

 

 

epoch

 

 

 

intake

x

x

x

period

 

 

 

source

x

x

x

topog

 

literat.dbf

 

coldate

x

x

 

map

 

 

ident

x

 

 

norec

 

 

litno

x

x

x

descript

 

libr

 

libr

x

x

 

remarks

 

 

value

x

 

 

visited

 

 

col

x

 

 

 

 

                taxonomical data                 automatic via collect.exe on genus for Phylum  Mollusca

                taxonomical data                 automatic via collect.exe on nosupfam for other Phyla and Miscellaneous

automatic via collect.exe on locality

 
                topographical data

                geological data

1 =          inputscreen

2 =          form

3 =          label