Home
Manual
Fields are shown under each table.
Comments about future changes or unresolved design issues are shown in contrasting color.
Version specific features are noted by highlighted text.
tblImages
, images of specimens and other items
ImageID, integer, 4 bytes, identifier for the image. This is the base portion of the file name.
TrueID, integer, 4 bytes, original ImageID for this image content
TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID of the species. When a species and subspecies have the same name, use the TaxonNameID of the subspecies. If TaxonNameID = 0, this image is not associated with any taxon.
Status, integer, 1 byte, 0 = normal, 1 = hidden
ImageTypeID, integer, 2 bytes, = tblImageTypes.ImageTypeID
MIME, integer, 2 bytes, Multipurpose Internet Mail Extension code, = tblMIME.MIMEID. The file extension comes from this, also known as the image file type.
1 = "image/gif"
2 = "image/jpeg"
3 = "image/tiff"
4 = "image/bmp"
SexID, integer, 1 byte, = tblSexes.SexID
Description, text, 300 bytes maximum
SourceID, integer, 2 bytes = tblSources.SourceID
Figure, text, 50 bytes maximum, figure number or other identification for figures from publications
SpecimenID, integer, 4 bytes, = tblSpecimens.SpecimenID
Thumb, data type = OLE object, may be NULL
Xsize, integer, 2 bytes
Ysize, integer, 2 bytes
Image, data type = OLE object, may be NULL
AccessCode, integer, 2 bytes
LastUpdate, smalldatetime, date and time of last update
ModifiedBy, integer, 2 bytes, UserID of the signon that made the change
tblMIME
, Multipurpose Internet Mail Extension code
MIMEID, integer, 2 bytes
FileExtension, text, 4 bytes inclusive image description
ConnectionType, text, 29 bytes maximum
tblImageTypes
, type of image
ImageTypeID, integer, 2 bytes, identifier for the type of image
AboveID, integer, 2 bytes, = tblImageTypes.ImageTypeID for the next more inclusive image description
Description, text, 100 bytes maximum
tblSounds
, sound recordings
SoundID, integer, 2 bytes, identifier for the recording
TrueID, integer, 2 bytes, original SoundID for this recording content
TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID of the species. When a species and subspecies have the same name, use the TaxonNameID of the subspecies. If TaxonNameID = 0, this sound is not associated with any taxon.
Status, integer, 1 byte, 0 = normal, 1 = hidden
SoundTypeID, 1 byte,, 1 byte, 1 = calling, 2 = courtship, 3 = warning
Versions, integer, 1 byte, file types: 1 = .aif, 2 = .ra, 3 = both .aif and .ra.
This is obsolete. Every (?) file is recorded as .aiff, .wav and .mp3. The use of this field should be revised or eliminated. Probably will be cast as bit0 = MP3, 1 = wav, 2 = aiff.
SexID, integer, 1 byte, = tblSexes.SexID
Description, text, 300 bytes maximum
SourceID, integer, 2 bytes, = tblSources.SourceID
SpecimenID, integer, 4 bytes, = tblSpecimens.SpecimenID
SoundMP3 - compressed audio version, type = OLE object, may be NULL
SoundWAV - Windows uncompressed audio version, type = OLE object, may be NULL
SoundAIF - Apple uncompressed audio version, type = OLE object, may be NULL
AccessCode, integer, 2 bytes
LastUpdate, smalldatetime, date and time of last update
ModifiedBy, integer, 2 bytes, UserID of the signon that made the change
tblEcoRoles
, ecological roles
EcoRoleID, integer, 2 bytes, primary key, identifier for the ecological role
TaxonRole, text, 20 character maximum, role for the taxon in the primary scope
OtherRole, text, 20 character maximum, role for the other organism
EnableTypeHost, integer, 1 byte, 0 = not used, 1 = enable use of tblEcoRelationships.TypeHost
LastUpdate, smalldatetime, date and time of last update
ModifiedBy, integer, 2 bytes, UserID of the signon that made the change
tblEcoRelationships
, ecological relationships
TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID, identifier for a taxon within the primary scope
SeqNum, integer, 2 bytes. TaxonNameID and SeqNum provide the primary key
SpecimenID, integer, 4 bytes, = tblSpecimens.SpecimenID, 0 is an acceptable value meaning no specific specimen.
EcoRoleID, integer, 2 bytes, = tblEcoRoles.EcoRoleID, identifier for the ecological relationship
OtherEcoTaxonID, integer, 2 bytes, = tblOtherTaxa.OtherEcoTaxonID, identifier for the taxon not within the primary scope
NomenclatorID, integer, 4 bytes, = tblNomenclator.NomenclatorID, used only when SpecimenID = 0
TypeHost, integer, 1 byte, 0 = no, 1 = yes
Comment, text, 500 character maximum
SourceID, integer, 2 bytes, = tblSources.SourceID
LastUpdate, smalldatetime, date and time of last update
ModifiedBy, integer, 2 bytes, UserID of the signon that made the change
tblOtherEcoTaxa
, taxa in ecological relationships but outside the primary scope
OtherEcoTaxonID, integer, 2 bytes, primary key, identifier for a taxon outside the primary scope
OtherEcoTaxonStr, text, 150 character maximum, a string with OtherEcoTaxonIDs showing the ancestors and separated by "-". "g" is added at the end of OtherEcoTaxonID for a genus. "s" is added at the end of OtherEcoTaxonID for a subgenus.
ScientificName, text, 100 characters maximum
CommonName, text, 100 characters maximum (may include multiple common names separated by commas)
RankID, integer, 1 byte
30 = above genus
20 = genus
18 = subgenus
15 = below subgenus and above species
10 = species
5 = below species
AboveID, integer, 2 bytes, = OtherEcoTaxonID. A value of 0 indicates that no parent taxon is included in the table. There is no limit to the number of "top taxa" that have no parent taxa.
LastUpdate, smalldatetime, date and time of last update
ModifiedBy, integer, 2 bytes, UserID of the signon that made the change