Diversity Collection

Enumeration tables

The following objects are not included:

  • Logging tables
  • System objects
  • Objects marked as obsolete
  • Previous versions of objects

Table

Column Data type Description
Code nvarchar (50) A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it.
ParentCode nvarchar (50) The code of the superior entry, if a hierarchy within the entries is necessary
ParentRelation nvarchar (50) Relation to parent entry, e.g. part of
Description nvarchar (500) Description of enumerated object, displayed in the user interface
DisplayText nvarchar (50) Short abbreviated description of the object, displayed in the user interface
DisplayOrder smallint The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.
DisplayEnable bit Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box)
URL varchar (500) A link to further information about the enumerated object
InternalNotes nvarchar (500) Internal development notes about usage, definition, etc. of an enumerated object
Icon image A symbol representing this entry in the user interface
ModuleName varchar (50) If the enumerated entry is related to a DiversityWorkbench module or a related webservice, the name of the DiversityWorkbench module, e.g. DiversityCollEventSeriess
RowGUID uniqueidentifier -Default value: newsequentialid()

Table AnnotationType_Enum

The types of an annotation as used in table Annotation

Dependent tables:

  • Annotation

Table CollCircumstances_Enum

Circumstances of the occurence of the organisms

Dependent tables:

  • IdentificationUnit

Content

Code Description
bred animal born in captivity (domestic, zoo, or farm animales)
captivity wild animal or plant raised in captivity
cultivated cultivated in enclosed conditions (greenhouse plants, fungi, bacteria, etc. in laboratory or biotechnology conditions)
experiment material cultivated or treated under experimental conditions (including, e.g., infection experiments)
imported imported material of uncertain provenence (e.g. food items)
natural occurrence under natural conditions
planted planted in open agriculture, horticulture, or silviculture
unknown unknown circumstances of occurrence

Table CollCollectionImageType_Enum

The types of a collection, e.g. cupboard, drawer, box, rack etc.

Dependent tables:

  • CollectionImage

Content

Code Description
area area resp. section within a collection, e.g. within a insect case
image image of a collection, e.g. a insect case
plan Old plan optional including geometry of a collection

Table CollCollectionType_Enum

The types of a collection, e.g. cupboard, drawer, box, rack etc.

Dependent tables:

  • Collection

  • Content

Code Description DisplayText
area An area within a collection, e.g. within an insect display case area
box box box
collection A collection of objects collection
container container container
cupboard cupboard cupboard
department department department
drawer drawer drawer
freezer freezer freezer
fridge fridge fridge
hardware hardware hardware e.g. for sensor network
institution institution institution
location location location
radioactive Place where radioactive objects are stored radioactive
room room room
sensor A sensor for e.g. temperature or pests sensor
steel locker steel locker steel locker
subdivided container A container subdivided into chambers subdivided container
trap A trap for monitoring pest e.g. for IPM trap

Table CollDateCategory_Enum

The categories for the collection date

Dependent tables:

  • CollectionSpecimen

Table CollEventDateCategory_Enum

The categoies of the collection date

Dependent tables:

  • CollectionEvent

Content

Code Description
actual The given date is the real date
estimated The given date was estimated by the user
system The given date was generated by the system

Table CollEventImageType_Enum

The types of the images taken from a collection event

Dependent tables:

  • CollectionEventImage

Content

Code Description DisplayText ParentCode
aerial photography photography from an elevated position e.g. an aerial drone aerial photography
audio audio file related to an event sound
audio (for transcription) audio file of spoken comments related to an event that might be deleted after transcription into the database sound /recorded speech audio
biotope photography photography of a whole biotope where the specimen are observed resp. collected biotope photography
documentation a still image of a document or paperwork associated with an event, e. g. field books documentation
drawing, painting original line or color drawing of an event drawing, painting
image still image of any raster or vector format without any further information regarding the content type, e. g. graphic designs, plans and maps, vector graphics 2D, 3D models image
landscape photography photography of the landscape where the specimen are observed resp. collected landscape photography
map image of a map where the specimen are observed resp. collected map image
photograph photographic still image of an event; e. g. trap, trawl net photograph
supporting files text-xml or text-WKT encoded files, assigned to multimedia objects supporting files
video e. g. video file related to an event moving image

Table CollEventSeriesDescriptorType_Enum

The type of the Descriptors

Dependent tables:

  • CollectionEventSeriesDescriptor

Table CollEventSeriesImageType_Enum

The types of the images taken from a collection event series

Dependent tables:

  • CollectionEventSeriesImage

Content

Code Description DisplayText ParentCode
aerial photography photography from an elevated position e.g. an aerial drone aerial photography
audio audio record of e.g. the song of an observed bird sound
audio (for transcription) audio file of spoken comments related to an event or event series that might be deleted after transcription into the database sound /recorded speech audio
documentation a still image of a document or paperwork associated with an event series, e. g. field books documentation
drawing, painting original line or color drawing of an event series drawing, painting
image still image of any raster or vector format without any further information regarding the content type, e. g. graphic designs, plans and maps, vector graphics 2D, 3D models image
landscape photography photography of the landscape where the specimen are observed resp. collected landscape photography
map image of a map where the specimen are observed resp. collected map image
moving image e. g. video file related to an event series moving image
photograph photographic still image of an event series; e. g. trap, trawl net photograph
supporting files text-xml or text-WKT encoded files, assigned to multimedia objects supporting files

Table CollIdentificationCategory_Enum

The categories of an identification, e.g. determination, confirmation etc.

Dependent tables:

  • Identification

Content

Code Description
absence When nomenclatural type material has been used up in previous studies, or if a mixed collection contains e.g. several fungi but none fits the protologue
confirmation The examination confirms a previous identification
correction Correction of a misidentification supposedly due to a typing error.
determination The determination of the material results in a new identification or correction
dubious The material is assumed as dubiously belonging to the identified taxon or the observation is assumed as dubiously belonging to the identified taxon
expert assignment The assignment of occurrence data to a new taxon following expert opinion, without study of material
implicit The identification can be logically deduced from the type material, e.g. in the case of Yes/No type specimens.
negative The material is identified as not belonging to the identified taxon or the observation is verified as not belonging to the identified taxon
preference Assigning preference to an older determination over the most recent one. Differs from a confirmation only in that the object has not been re-examined. The choice is based on the expertise of the person effecting the earlier identification
renaming e.g. assigning a species to a new genus or a purely nomenclatural change
revision The correction of a former determination of the material
type annotation annotated as original material (e. g. syntype, paratype), e.g. done by a scientist by adding type labels to the material as part of a curatorial process
type designation designated as type material (i. e. lectotype, neotype, epitype or their duplicates; ICBN 2006, Art. 7.5, 7.10-11 + N2, Art. 9.7-11, 9.20, 9A, Art. 37.3; nomenclatural action undertaken by the person who is treating the nomenclature of the taxon)
type indication indicated as type material (ICBN 2006, Art. 37.1-4, 37A, Art. 7.5, Art. 24.3; any nomenclatural action, e. g. by the person who described the taxon, other than type designation)

Table CollIdentificationDateCategory_Enum

The categories of the identification date

Dependent tables:

  • Identification

  • Content

Code Description
actual The given date is the real date
collection date The collection date has been taken as the identification date
estimated The given date was estimated by the user
system The given date was generated by the system

Table CollIdentificationQualifier_Enum

The identification qualifiers, e.g. cf. spec., s.l. etc.

Dependent tables:

  • Identification

Content

Code Description
(select this for identifications that are certain)
? unspecified doubtful identification (aff. or cf., or applicable taxonomic rank not known)
aff. forma ‘affinis’ = similar to, but probably not the named forma
aff. gen. ‘affinis’ = similar to, but probably not the named genus
aff. sp. ‘affinis’ = similar to, but probably not the named species
aff. subsp. ‘affinis’ = similar to, but probably not the named subspecies
aff. var. ‘affinis’ = similar to, but probably not the named variety
agg. aggregate
cf. forma doubtful identification of forma or forma specialis. Example: ‘Ech. ferruginea cf. f. rubra’
cf. gen. doubtful genus identification. Examples: ‘cf. Abies’, ‘?Abies’
cf. hybrid doubtful identification of hybrid. Example: cf. Salix alba x fragilis
cf. sp. doubtful species identification (genus identification certain). Example: ‘Abies cf. alba’
cf. subsp. doubtful identification of subspecies. Example: ‘Abies alba cf. ssp. alba’
cf. var. doubtful identification of variety. Example: ‘Echinonema ferruginea cf. var. campestris’
s. l. sensu lato
s. str. sensu stricto
sp. only the genus is given, the information relates to a single, unspecified species
sp. nov. only the genus is given, it is assumed that the unidentified species is new
spp. only the genus is given, the information covers several unspecified species

Table CollLabelTranscriptionState_Enum

The states of the transcription of a label

Dependent tables:

  • CollectionSpecimen

Content

Code Description
complete all data from label transferred in database
curator review required curator for transcription / review required
extern review required extern curator for transcription / review required
final curator review specimen has been finally reviewed by curator
first curator review specimen has been reviewed by curator for first time
incomplete transcription started by technical staff
not started transcription not started

Table CollLabelType_Enum

The types of a label, e.g. handwritten, typed etc.

Dependent tables:

  • CollectionSpecimen

Content

Code Description DisplayText
handwriting all data in handwriting handwriting
mixed data typed with handwriting comments mixed
typed all data typed typed

Table CollMaterialCategory_Enum

The material categories of the specimen, e.g. slide, culture etc.

Dependent tables:

  • CollectionSpecimenPart
  • ProjectMaterialCategory

Content

Code Description DisplayText ParentCode
bones bones or skeleton from vertebrates bones preserved specimen
complete skeleton complete skeleton complete skeleton bones
cones cones of e.g. Gymnospermae, not stored together with the herbarium sheet cones preserved specimen
cultures living cultures of organisms cultures living specimen
DNA lyophilised DNA lyophilised DNA lyophilised DNA sample
DNA sample DNA sample DNA sample other specimen
drawing original line or color drawing drawing drawing or photograph
drawing or photograph A record describing a static visual representation (digital or physical) drawing or photograph medium
dried specimen dried specimen dried specimen preserved specimen
earth science specimen A record describing a geo-scientific object which is no pure mineral, rock or fossil specimen (but a mixture), or a geo-scientific specimen with unknown traits earth science specimen other specimen
egg egg, e.g. of a bird or insect egg other specimen
fossil bones fossil bones or skeleton from vertebrates fossil bones fossil specimen
fossil complete skeleton fossil complete skeleton of a vertrebrate fossil complete skeleton fossil bones
fossil incomplete skeleton fossil incomplete skeleton of a vertrebrate fossil incomplete skeleton fossil bones
fossil otolith fossil otolith of fishes fossil otolith fossil bones
fossil postcranial skeleton fossil postcranial skeleton of a vertrebrate fossil postcranial skeleton fossil bones
fossil scales fossil scales of fish fossil scales fossil specimen
fossil shell fossil shell of animal fossil shell fossil specimen
fossil single bones fossil single bones of a vertrebrate fossil single bones fossil bones
fossil skull fossil skull of a vertrebrate fossil skull fossil bones
fossil specimen A record describing a preserved specimen that is a fossil fossil specimen specimen
fossil tooth fossil tooth of an animal fossil tooth fossil bones
herbarium sheets capsules or sheets as stored in a botanical collection herbarium sheets dried specimen
human observation A record describing an output of a human observation process human observation observation
icones icones, images etc. stored in a biological collection icones drawing or photograph
incomplete skeleton incomplete skeleton incomplete skeleton bones
living specimen A record describing a specimen which is alive (not preserved) living specimen specimen
machine observation A record describing an output of a machine observation process machine observation observation
material sample A record describing the physical result of a sampling (or subsampling) event (sample either preserved or destructively processed) material sample other specimen
medium medium like sound recordings, videos, images and the like medium
micr. slide glass plate with specimen for microscopic study micr. slide other specimen
mineral specimen A record describing a preserved specimen which is a mineral mineral specimen other specimen
mould mould of animal mould fossil specimen
nest nest, e.g. of a bird or insect nest other specimen
observation observation observation
other specimen A record describing a specimen which is not indicated as preserved, living, fossil or mineral other specimen specimen
otolith otolith of fishes otolith bones
pelt pelt, skin or fur of an animal pelt preserved specimen
photogr. print photographic print (color or black/white) photogr. print drawing or photograph
photogr. slide image in the form of a photographic slide for projection photogr. slide drawing or photograph
pinned specimen pinned specimen, e.g. insects in a insect case pinned specimen dried specimen
postcranial skeleton postcranial skeleton postcranial skeleton bones
preserved specimen A record describing a preserved specimen (not living) preserved specimen specimen
SEM table table with specimen for Scanning electron microscopy SEM table other specimen
shell shell e.g. of a snail shell preserved specimen
single bones single bones single bones bones
skull skull of a vertebrate skull bones
sound sound recoding sound medium
specimen specimen stored in a collection specimen
TEM specimen specimen preparation for Transmission electron microscopy TEM specimen other specimen
thin section thin section thin section other specimen
tissue sample tissue sample tissue sample other specimen
tooth tooth of an animal tooth bones
trace trace e.g. footprints of an animal trace other specimen
trace fossil trace fossil of animal trace fossil fossil specimen
vial vial, flask or similar container vial preserved specimen

Table CollRetrievalType_Enum

The types data about organisms were retrieved

Dependent tables:

  • IdentificationUnit

Content

Code Description
human observation A record describing an output of a human observation process
literature A record describing an output of a literature research
machine observation A record describing an output of a machine observation process

Table CollSpecimenImageType_Enum

The type of an image of a specimen, e.g. label

Dependent tables:

  • CollectionSpecimenImage

Content

Code Description DisplayText ParentCode
audio e. g. audio file related to a specimen, observation or unit sound
audio (for transcription) e. g. audio file of spoken comments related to a specimen, observation or unit that might be deleted after transcription into the database sound /recorded speech audio
drawing original line or color drawing and painting of a specimen, observation or unit drawing, painting image
image still image of any raster or vector format without any further information regarding the content type, e. g. graphic designs, plans and maps, vector graphics 2D, 3D models image
label a still image of a document or paperwork associated with a specimen, observation or unit, e. g. herbarium label, file card documentation image
LM photograph photographic still image of a specimen, observation or unit from light microscopy LM photograph image
photograph photographic still image of a specimen, observation or unit; e. g. macro images of an object photograph
SEM image photographic still image of a specimen, observation or unit from scanning electron microscopy SEM photograph image
supporting files text-xml or text-WKT encoded files, assigned to multimedia objects supporting files
TEM image photographic still image of a specimen, observation or unit from transmission electron microscopy TEM photograph image
video e. g. video file related to an specimen, observation or unit moving image

Table CollSpecimenRelationType_Enum

Types of the relation between specimen

Dependent tables:

  • CollectionSpecimenRelation

Content

Code Description
Duplicate specimen or specimen part from the same location and time, designated by the same collector as such (may be one organism or not)
public database public database
Same location different specimens from the same location, but potentially different time and collector
Specimen part material originated from one specimen, e.g. dried material + cultured material or wet material + DNA or tissue sample

Table CollTaskMetricAggregation_Enum

The aggregation applied for retrieval of values, e.g. avg, max etc.

Dependent tables:

  • CollectionTaskMetric

Content

Code Description
avg the average value of a period
max the maximal value within a period
min the minimal value within a period
none no aggregation applied
range the difference between the maximal and minimal value within a period
sum the sum of values within a period

Table CollTaxonomicGroup_Enum

The taxonomic groups of the organisms

Dependent tables:

  • IdentificationUnit
  • ProjectTaxonomicGroup

Content

Code Description DisplayText ParentCode
alga alga alga
amphibian amphibian amphibian vertebrate
animal Animalia (= Metazoa) animal
artefact An item made or given shape by humans, such as a tool or a work of art artefact
arthropod Arthropoda: insects, spiders, crabs etc. arthropod evertebrate
bacterium bacteria/prokaryotic bacterium
bird bird bird vertebrate
bryophyte Marchantiomorpha (liverworts), Anthocerotophyta (hornworts) and Bryophyta (mosses) bryophyte
cnidaria Cnidaria: sea anemones, corals, jellyfish, sea pens, hydra cnidaria evertebrate
Coleoptera Coleoptera Coleoptera insect
Diptera Diptera Diptera insect
echinoderm Echinodermata: sea urchins, starfish, and their allies echinoderm evertebrate
evertebrate Animalia (= Metazoa) excl. Chordata evertebrate animal
fish fish fish vertebrate
fungus Eumycota: mushrooms, sac fungi, yeast, molds, rusts, smuts, etc. fungus
gall growth modification or deformation of plant tissue or fungal plectenchyma, induced by a different organism gall
Heteroptera Heteroptera Heteroptera insect
Hymenoptera Hymenoptera Hymenoptera insect
insect Hexapoda: insects, springtails, diplurans, and proturans insect arthropod
Lepidoptera Lepidoptera Lepidoptera insect
lichen Lichenized Eumycota lichen
mammal mammal mammal vertebrate
mineral A record describing a preserved specimen which is a mineral mineral
mollusc Mollusca: Snails, clams, mussels, squids, octopi, chitons, and tusk shells mollusc evertebrate
myxomycete Myxomycota slime mould
other other/anorganic other
plant Lycophytes, ferns and seedplants plant
reptile reptile reptile vertebrate
rock A record describing a preserved specimen which is a rock rock
soil soil soil
soil horizon soil horizon soil horizon soil
spider Spider: Including Araneae (Mesothelae, Mygalomorphae and Araneomorphae) spider arthropod
unknown unknown group unknown
vertebrate Chordata vertebrate animal
virus virus virus

Table CollTransactionType_Enum

The types of the transactions of the specimen, e.g. loan, exchange

Dependent tables:

  • Transaction

Content

Code Description
embargo Temporary data embargo for specimen that should not be published within the specified period
exchange Exchange of specimens between e.g. collections
forwarding a forwarding of specimens of a loan to another institution
gift A gift of specimens to e.g. a collection
inventory An inventory of e.g. a collection
loan A temporary loan of specimens of a collection to e.g. another collection
permanent loan A permanent loan of specimens of a collection to e.g. another collection
permit permit or certificate for the collection of specimen
purchase A purchase of specimens by a collection
regulation a regulation, provisio or stipulation e.g. in the context of the Nagoya protocoll
removal the removal of specimens from an institution, e.g. by damage, loss etc.
return a partial return of a loan
transaction group the superior dataset for a group of transactions
warning A warning e.g. against biocides in samples

Table CollTypeStatus_Enum

The type statuses of the identifications, e.g. Isotype

Dependent tables:

  • Identification

Content

Code Description
allolectotype A paralectotype specimen that is the opposite sex of the lectotype. The term is not regulated by the ICZN. [Zoo.]
alloneotype A paraneotype specimen that is the opposite sex of the neotype. The term is not regulated by the ICZN. [Zoo.]
allotype A paratype specimen designated from the type series by the original author that is the opposite sex of the holotype. The term is not regulated by the ICZN. [Zoo.]
conserved type The one specimen or other element conserved as type for a name of a subdivision of a genus or of an infraspecific taxonand listed in ICN, App. III and IV (typ. cons.)
cotype A deprecated term no longer recognized in the ICZN; formerly used for either syntype or paratype [see ICZN Recommendation 73E]. [Zoo.]
epitype An epitype is a specimen or illustration selected to serve as an interpretative type when any kind of holotype, lectotype, etc. is demonstrably ambiguous and cannot be critically identified for purposes of the precise application of the name of a taxon (see Art. ICBN 9.7, 9.18). An epitype supplements, rather than replaces existing types. [Bot./Bio.]
ex-Epitype A strain or cultivation derived from epitype material. Ex-types are not regulated by the botanical or zoological code. [Bot.]
ex-Holotype A strain or cultivation derived from holotype material. Ex-types are not regulated by the botanical or zoological code. [Zoo./Bot.]
ex-Isotype A strain or cultivation derived from isotype material. Ex-types are not regulated by the botanical or zoological code. [Zoo./Bot.]
ex-Lectotype A strain or cultivation derived from lectotype material. Ex-types are not regulated by the botanical or zoological code. [Zoo./Bot.]
ex-Neotype A strain or cultivation derived from neotype material. Ex-types are not regulated by the botanical or zoological code. [Zoo./Bot.]
ex-Paratype A strain or cultivation derived from paratype material. Ex-types are not regulated by the botanical or zoological code. [Zoo./Bot.]
ex-Syntype A strain or cultivation derived from neotype material. Ex-types are not regulated by the botanical or zoological code. [Zoo./Bot.]
ex-Type A strain or cultivation derived from some kind of type material. Ex-types are not regulated by the botanical or zoological code. [Zoo./Bot.]
hapantotype One or more preparations of directly related individuals representing distinct stages in the life cycle, which together form the type in an extant species of protistan [ICZN Article 72.5.4]. A hapantotype, while a series of individuals, is a holotype that must not be restricted by lectotype selection. If a hapantotype is found to contain individuals of more than one species, however, components may be excluded until it contains individuals of only one species [ICZN Article 73.3.2]. [Zoo.]
holotype The one specimen or other element used or designated by the original author at the time of publication of the original description as the nomenclatural type of a species or infraspecific taxon. A holotype may be ’explicit’ if it is clearly stated in the originating publication or ‘implicit’ if it is the single specimen proved to have been in the hands of the originating author when the description was published. [Zoo./Bot./Bio.]
iconotype A drawing or photograph (also called ‘phototype’) of a type specimen. Note: the term “iconotype” is not used in the ICBN, but implicit in, e. g., ICBN Art. 7 and 38. [Zoo./Bot.]
isoepitype a duplicate of an epitype
isolectotype A duplicate of a lectotype, compare lectotype. [Bot.]
isoneotype A duplicate of a neotype, compare neotype. [Bot.]
isoparatype A duplicate of a paratype
isosyntype A duplicate of a syntype, compare isotype = duplicate of holotype. [Bot.]
isotype An isotype is any duplicate of the holotype (i. e. part of a single gathering made by a collector at one time, from which the holotype was derived); it is always a specimen (ICBN Art. 7). [Bot.]
lectotype A specimen or other element designated subsequent to the publication of the original description from the original material (syntypes or paratypes) to serve as nomenclatural type. Lectotype designation can occur only where no holotype was designated at the time of publication or if it is missing (ICBN Art. 7, ICZN Art. 74). [Zoo./Bot.] – Note: the BioCode defines lectotype as selection from holotype material in cases where the holotype material contains more than one taxon [Bio.].
neotype A specimen designated as nomenclatural type subsequent to the publication of the original description in cases where the original holotype, lectotype, all paratypes and syntypes are lost or destroyed, or suppressed by the (botanical or zoological) commission on nomenclature. In zoology also called “Standard specimen” or “Representative specimen”. [Zoo./Bot./Bio.]
not a type For specimens erroneously labelled as types an explicit negative statement may be desirable. [General]
original material Specimens and illustrations indicated in the protologue of a name (see ICBN Art. 9 Note 2 for details)
paralectotype All of the specimens in the syntype series of a species or infraspecific taxon other than the lectotype itself. Also called “lectoparatype”. [Zoo.]
paraneotype All of the specimens in the syntype series of a species or infraspecific taxon other than the neotype itself. Also called “neoparatype”. [Zoo.]
paratype All of the specimens in the type series of a species or infraspecific taxon other than the holotype (and, in botany, isotypes). Paratypes must have been at the disposition of the author at the time when the original description was created and must have been designated and indicated in the publication. Judgment must be exercised on paratype status, for only rarely are specimens explicitly cited as paratypes, but usually as “specimens examined,” “other material seen”, etc. [Zoo./Bot.]
plastoholotype A copy or cast of holotype material (compare Plastotype).
plastoisotype A copy or cast of isotype material (compare Plastotype).
plastolectotype A copy or cast of lectotype material (compare Plastotype).
plastoneotype A copy or cast of neotype material (compare Plastotype).
plastoparatype A copy or cast of paratype material (compare Plastotype).
plastosyntype A copy or cast of syntype material (compare Plastotype).
plastotype A copy or cast of type material, esp. relevant for fossil types. Not regulated by the botanical or zoological code (?). [Zoo./Bot.]
secondary type A referred, described, measured or figured specimen in the original publication (including a neo/lectotypification publication) that is not a primary type.
supplementary type A referred, described, measured or figured specimen in a revision of a previously described taxon.
syntype One of the series of specimens used to describe a species or infraspecific taxon when neither a single holotype by the original author, nor a lectotype in a subsequent publication has been designated. The syntypes collectively constitute the name-bearing type. [Zoo./Bot.]
topotype One or more specimens collected at the same location as the type series (type locality), regardless of whether they are part of the type series. Topotypes are not regulated by the botanical or zoological code. Also called “locotype”. [Zoo./Bot.]
type a) A specimen designated or indicated any kind of type of a species or infraspecific taxon. If possible more specific type terms (holotype, syntype, etc.) should be applied. b) the type name of a name of higher rank for taxa above the species rank. [General]
typotype the specimen used to prepare an illustration where the latter is the type

Table CollUnitRelationType_Enum

The type of relation between organisms within one specimen, e.g. growing on

Dependent tables:

  • IdentificationUnit

Content

Code Description
Association in association with (unspecific statement if no further information about interaction b/w 2 organisms is available)
Child of child association (i.e. in the literal genetical sense, not in an abstract sense)
Endophytic in endophytic organism growing in plants without causing symptoms (possibly mutualistic or opportunistic parasite)
Found on Organism found on 2nd organism
Gall inducing Growth movement or swelling growth of (pseudo-)tissue or organ of a host organism caused by an organism.
Growing on substrate statement: organism growing on 2nd organism, living stages directly observed (i.e. assoc. not due to diaspores alone)
Isolated from substrate statement: organism isolated from 2nd organism, no living stages observed (i.e. possibly due to surface contamination)
Lichenization mutualistic symbiosis between a fungus and algae (= 2nd organism)
Mutant of A mutant of the parent organism
Mutualism mutualistic symbiosis, both partners profit from each other
Mycorrhiza of mycorrhizal association of a fungus with a plant (= 2nd organism)
Parasitic (accid.) parasitic on an ‘accidential host’ (in the sense of Nannfeldt): with strong infection pressure, another organism growing between infected organisms may become infected.
Parasitic (facul.) facultatively parasitic on host (= 2nd organism)
Parasitic (oblig.) obligately parasitic on host (= 2nd organism)
Parasitic (quest.) questionably parasitic on host (= 2nd organism), parasitic interaction is presumed, but doubtful/unverified
Parasitic on the taxon is parasitizing its host (regardless of type, i.e. holo-/meta-/hemi-biotrophic, or pertho-/necrotrophic)
Parent/Child parent/child association (i.e. in the literal genetical sense, not in an abstract sense)
Part of belongs to the same organism resp. unit, e.g. a branch is part of a tree
Pollinator of organism 1 is the pollinator of a plant (organism 2)
Predator/Food organism 1 is the predator of organism 2 (i. e. 2 is food of 1)
Saprophytic on organism growing saprophytic on 2nd organism, living stages directly observed (i.e. assoc. not due to diaspores alone)
Sibling both organisms are siblings (have the same parents)

Table EntityAccessibility_Enum

The type of accessibility of database objects within a certain context

Dependent tables:

  • EntityUsage

Table EntityContext_Enum

The context in which the application is used, e.g. collection - administration, field-mapping

Dependent tables:

  • EntityRepresentation
  • EntityUsage

Table EntityDetermination_Enum

The way a value of an entry is determined, e.g. calculated, defined by the user etc.

Dependent tables:

  • EntityUsage

Table EntityLanguageCode_Enum

The codes for the languages used for the entities

Dependent tables:

  • EntityRepresentation

Table EntityUsage_Enum

The usage of an entity, e.g. hidden, readonly

Table EntityVisibility_Enum

Type of visibility of an entity as used in table EntityUsage

Dependent tables:

  • EntityUsage

Table LanguageCode_Enum

The codes for the languages

Content

Code DisplayText
af Afrikaans
ar Arabisch
az Aserbaidschanisch
be Belarussisch
bg Bulgarisch
ca Katalanisch
cs Tschechisch
da Dänisch
de Deutsch
el Griechisch
en Englisch
es Spanisch
et Estnisch
eu Baskisch
fa Farsi
fi Finnisch
fo Färingisch
fr Französisch
gl Galizisch
gu Gujarati
he Hebräisch
hi Hindi
hr Kroatisch
hu Ungarisch
hy Armenisch
id Indonesisch
is Isländisch
it Italienisch
ja Japanisch
ka Georgisch
kk Kasachisch
kn Kannada
ko Koreanisch
ky Kirgisisch
lt Litauisch
lv Lettisch
mk Mazedonisch
mn Mongolisch
mr Marathi
ms Malaiisch
nl Niederländisch
no Norwegisch
pa Punjabi
pl Polnisch
pt Portugiesisch
ro Rumänisch
ru Russisch
sa Sanskrit
sk Slowakisch
sl Slowenisch
sq Albanisch
sv Schwedisch
sw Swahili
ta Tamil
te Telugu
th Thai
tr Türkisch
tt Tatarisch
uk Ukrainisch
ur Urdu
uz Usbekisch
vi Vietnamesisch

Table MeasurementUnit_Enum

The measurement units, e.g. m

Table ParameterValue_Enum

Distinct values for a parameter of a method

Depending on:

  • Parameter

Table PropertyType_Enum

The types of a Property, e.g. Chronostratigraphy

Dependent tables:

  • Property

Table TaskDateType_Enum

The type of a task, e.g. freezing etc.

Dependent tables:

  • Task

Table TaskModuleType_Enum

The type of a task, e.g. freezing etc.

Dependent tables:

  • Task

Table TaskType_Enum

The type of a task, e.g. freezing etc.

Dependent tables:

  • Task