Download "user manual"

APPENDIX 3: List of PALEO tables & fields
·*speciesno
phylum
elass
subclass
superorder
ordername
suborder
superfamily
family
subfamily
othercategory
-genus
subgenus
·species
subspecies
speciesauth
conodontel
remarks
...-
·*refno
speciesno
identdate
identby
taxon
abundpct
abund
populJitionno
coiling
-..
ECOLOGY
·*refno
tpct
AGE
SPECIMEN
IDENTIFICATION
SPECIES
·*refno
era
periodl
peri0d2
epochl
epochZ
seriesl
seriesZ
stagel
stageZ
substagel
substageZ
zone
datum
letter_stage
remarks
·*refno
acronym
num
suffix
·specimenno
·usernante
-
,-..
mpct
rpct
ppct
bpct
no_individuals
no_species
livesp
deadsp
oenlTy_date
fieldno
type_status
no_specimens
taxa_studied
configuration
fieldrefno
coUdnrno
oldrefno
cbfno
ecology
maturity
tail
tai2
cHiI
002
radiom
remarks
~
FORMATION
I-- ·*refno
salinity
basin
supergroup
groupname
subgroup
formation
member
beds
lithology
remarks
fraction
remarks
FIELDNOTES
PUBUCATION
·*pubno
authors
year
title
source
.
PUBUSHEDIN
14-
·*refno
·pubno
illustration
pageno
LOCATION
·*refno
counlTy_ocean
..
f--
·*fieldrefno
year
reference
map_ref
coUdnrno
I--
ACQUISmON
I-- ·*coUdnrno
collector
collyear
donor
accnyear
~
area
altitude
depth
welLbore
dlat
MAP
·*maprefno
-name
·scale
mapno
remarks
~
..
ns
dlong
ew
utmzone
gridref
oldgridref
details
maprefno
lowdepth
STORE
4
·*refno
coUdnrno
building
room
cabineCdrawer
area
last_checked
remarks
micropaLbox
walletno
-
PREPARATION
i-- ·*refno
oprepdate
oprepby
coreno
weight
residue
hcll
hf
helZ
sg
oxy
koh
sieve
yom
slides
code
description
samptype
fieldname --- numeric field
• --- NOT NULL field
* --- primary key field
continuous lines show links between tables; arrow-head indicates a one-to-many relationship
(i.e. one record in one table links to many records in another)
PALTABL2.WPD
© Australian Geological SUlVey Organisation 1995
47
PALEO DATABASE -
USER'SMANUAL