Search by property

This page provides a simple browsing interface for finding entities described by a property and a named value. Other available search interfaces include the page property search, and the ask query builder.

List of results

• dwbC:CollectionSpecimen.CollectionSpecimenID  + (Unique ID for the table CollectionSpecimen (primary key))
• dwbC:CollectionSpecimenTransaction.TransactionID  + (Unique ID for the table Transaction (= foreign key and part of primary key))
• dwbC:CollectionSpecimenTransaction.TransactionReturnID  + (Unique ID for the table Transaction (= foreign key) for the return of a part that has been on loan)
• dwbC:Transaction.TransactionID  + (Unique ID for the transaction (= primary key))
• dwbC:TransactionAgent.TransactionID  + (Unique ID for the transaction, refers to table Transaction (= part of primary key and foreign key))
• dwbC:TransactionDocument.TransactionID  + (Unique ID for the transaction, refers to table Transaction (= part of primary key and foreign key))
• dwbC:TransactionPayment.TransactionID  + (Unique ID for the transaction, refers to table Transaction (= part of primary key and foreign key))
• dwbC:CollectionSpecimenPart.SpecimenPartID  + (Unique ID of the part of the collection specimen (= part of primary key).)
• dwbC:CollectionSpecimenProcessing.SpecimenProcessingID  + (Unique ID of the processing of a specimen or part of a specimen, part of primary key)
• dwbTN:TaxonNameListAnalysis.TaxonNameListRefID  + (Unique ID of the reference within the list, refers to table TaxonNameListReference, part of primary key<br />''DefaultValue: (-1) '')
• dwbTN:TaxonNameListDistribution.TaxonNameListRefID  + (Unique ID of the reference within the list, refers to table TaxonNameListReference, part of primary key<br />''DefaultValue: (-1) '')
• dwbTN:TaxonNameListReference.TaxonNameListRefID  + (Unique ID of the reference within the list, part of primary key)
• dwbTN:TaxonNameReference.TaxonNameRefID  + (Unique ID of the reference, part of primary key)
• dwbTN:TaxonHierarchy.NameID  + (Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key).)
• dwbR:ReferenceAvailability.RecordID  + (Unique random ID (see trigger) to identify …
  Unique random ID (see trigger) to identify the availability record. (Technical note: to improve reliability of database replication, the primary key is formed in combination with the RefID. Note that FilingCode is optional and not suitable.)<br />''DefaultValue: CONVERT([int],rand()*(2147483647.1),(0)) ''
  ONVERT([int],rand()*(2147483647.1),(0)) '')
• dwbR:ReferenceTitle.RefID  + (Unique reference ID code for the reference …
  Unique reference ID code for the reference record. Currently supporting only integer numbers. Note that RefMan in principle supports 20 char., but uses only integers. //[RefMan 02: ID]<br />''DefaultValue: CONVERT([int],rand()*(2147483647.1),(0)) ''
  ONVERT([int],rand()*(2147483647.1),(0)) '')
• dwbC:Collection.CollectionID  + (Unique reference ID for the collection (= primary key))
• dwbC:CollectionSpecimenRelation.CollectionSpecimenID  + (Unique reference ID for the collection specimen record (primary key))
• dwbC:CollectionSpecimenReference.ReferenceID  + (Unique reference ID for the reference record (part of primary key))
• dwbR:ReferenceTitle.UserDef4  + (User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. //[RefMan 21: U4])
• dwbR:ReferenceTitle.UserDef3  + (User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. //[RefMan 20: U3])
• dwbR:ReferenceTitle.UserDef1  + (User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. //[RefMan 18: U1])
• dwbR:ReferenceTitle.UserDef2  + (User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. //[RefMan 19: U2])
• dwbR:ReferenceTitle.UserDef5  + (User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. //[RefMan 22: U5])
• dwbC:CollectionSpecimen.LabelTranscriptionNotes  + (User defined notes on the transcription of the label into the database)
• dwbC:Identification.Notes  + (User defined notes, e.g. the reason for a re-determination / change of the name, etc.)

• dwbA020123:AgentContactInformation.Streetaddress  + (Usually street name and number, but may also contain post office box)
• dwbA:AgentContactInformation.Streetaddress  + (Usually street name and number, but may also contain post office box)

• dwbC:Identification.TaxonomicName  + (Valid name of the species (including the taxonomic author where available). Example: 'Rosa canina L.')
• dwbA:Agent.InheritedNamePrefix  + (Variable part of name, correctly placed at the beginning of the inherited names)
• dwbA020123:Agent.InheritedNamePrefix  + (Variable part of name, correctly placed at the beginning of the inherited names)
• dwbA:Agent.GivenNamePostfix  + (Variable part of name, correctly placed at end of given names)
• dwbA020123:Agent.GivenNamePostfix  + (Variable part of name, correctly placed at end of given names)
• dwbR:ReferenceTitle.Miscellaneous1  + (Various reference type dependent information; e.g. the total number of volumes for books //[RefMan 29: M1])
• dwbR:ReferenceTitle.Miscellaneous3  + (Various reference type dependent information //[RefMan 31: M3])
• dwbR:ReferenceTitle.Miscellaneous2  + (Various reference type dependent information //[RefMan 30: M2])
• dwbA:Agent.ValidDateSupplement  + (Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter'. The time of the valid date if necessary.)
• dwbA020123:Agent.ValidDateSupplement  + (Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter'. The time of the valid date if necessary.)
• dwbC:CollectionSpecimen.AccessionDateSupplement  + (Verbal or additional accession date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892')
• dwbC:CollectionEvent.CollectionDateSupplement  + (Verbal or additional collection date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'. The end date, if the collection event comprises a period. The time of the event, if necessary.)
• dwbTN:TaxonName.DateOfPublSupplement  + (Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892')
• dwbTN:TaxonName.DateOnPublSupplement  + (Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892')
• dwbC:Transaction.DateSupplement  + (Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'.)
• dwbC:Identification.IdentificationDateSupplement  + (Verbal or additional identification date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892')
• dwbP:Project.ProjectVersion  + (Version number (refers to the database content of this project, not to application development))
• dwbD:ResourceVariant.duration  + (Where applicable (sound or moving image): the duration in seconds)
• dwbD030307:ResourceVariant.duration  + (Where applicable (sound or moving image): the duration in seconds)
• dwbD:ResourceVariant.pixel height  + (Where applicable (still- or moving image): the height in pixel)
• dwbD030307:ResourceVariant.pixel height  + (Where applicable (still- or moving image): the height in pixel)
• dwbD:ResourceVariant.pixel width  + (Where applicable (still- or moving image): the width in pixel)
• dwbD030307:ResourceVariant.pixel width  + (Where applicable (still- or moving image): the width in pixel)
• dwbP:ProjectDescriptorElement.DisplayEnabled  + (Whether this DescriptorElement is to be displayed in the user interface.)