Database Scheme

The data written on the labels were put into a "Preparation" table. The "Relating Names" table contains the alternative scientific name (synonyms, current name), which makes the preparation searchable using its alternative name. The "Image" table possesses data of still images, the rotating movies and document images, with relations to both the "Preparation" and to the "Document" tables. The "Document" table contains document data in which each page (each image) is assigned as unit data. The "dLink" table is the table for the N-by-N relations between the "Document" and the "Preparation".

Data tables

Preparation
prep_id
image_id
map_id
CatalogNumber
SznNumber
Cabinet
Row
maintenance
DateOfModification
ScientificNameShort
ScientificName
YearOnLabel
MonthOnLabel
DayOnLabel
IdentifiedBy
Locality
Sex
LifeStage
OtherLabelInformation
TypeStatus
Remarks
YearCollected
MonthCollected
DayCollected
YearAccession
MonthAccession
DayAccession

Kingdom
Phylum
Subphylum
Class
Order
Family
Relating Names
altname_id
prep_id
CatalogNumber
altScientificNameShort
altScientificName
altReferences
DateOfModification
Image
image_id
prep_id
CatalogNumber
DocNumber
ImageKind
ImagePath
CapturedBy
CaptureDate
Note
height
width
mheight
mwidth
Document
doc_id
docNumber
image_id
page_count
page_name
page_contents
modifiedDate
bind_id
bind_nameshort
bind_name
bind_author
bind_type
bind_yearStart
bind_yearEnd
bind_otherinfo
Remarks

dLink
dLink_id
Name_link
SZN_link
DocNumber
SZNnumber
ScientificNameShort
YearDoc
MonthDoc
DayDoc

© 2006 - 2007 Stazione Zoologica "Anton Dohrn" di Napoli

Supported by Hosei Science Center, Italian-Japanese Biological Society and Stazione Zoologica di Napoli.