Difference between revisions of "Internal - Modell for Monitoring"

From Diversitymobile Wiki
Jump to navigation Jump to search
Line 74: Line 74:
 
|bit
 
|bit
 
|If the entry is only used for the hierarchical arrangement of the entries<br />''DefaultValue: (0)''
 
|If the entry is only used for the hierarchical arrangement of the entries<br />''DefaultValue: (0)''
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: AnalysisResult===
 
Value lists for analysis types with predefined values, e.g. "0, 1, 2, 3, ..." for Red list category. Includes description etc. for the values in the list.
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>AnalysisID</u>
 
|int
 
|ID of the analysis (Primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>AnalysisResult</u>
 
|nvarchar (255)
 
|The categorized value of the analysis
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|Description
 
|nvarchar (500)
 
|Description of enumerated object, displayed in the user interface
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DisplayText
 
|nvarchar (50)
 
|Short abbreviated description of the object, displayed in the user interface
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DisplayOrder
 
|smallint
 
|The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Notes
 
|nvarchar (500)
 
|Internal development notes about usage, definition, etc. of an enumerated object
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogInsertedBy
 
|nvarchar (50)
 
|Name of user who first entered (typed or imported) the data.<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogInsertedWhen
 
|smalldatetime
 
|Date and time when the data were first entered (typed or imported) into this database.<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Name of user who last updated the data.<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|smalldatetime
 
|Date and time when the data were last updated.<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: AnalysisTaxonomicGroup===
 
The types of analysis that are available for a taxonomic group
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>AnalysisID</u>
 
|int
 
|Analysis ID, foreign key of table Analysis.
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>TaxonomicGroup</u>
 
|nvarchar (50)
 
|Taxonomic group the organism identified by this unit belongs to. Groups listed in table CollTaxonomicGroup_Enum  (= foreign key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: Annotation===
 
Annotations to datasets in the database
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>AnnotationID</u>
 
|int
 
|ID of the annotation (Primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|ReferencedAnnotationID
 
|int
 
|If an annotation refers to another annotation, the ID of the referred annotation
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|AnnotationType
 
|nvarchar (50)
 
|The type of the annotation as defined in AnnotationType_Enum, e.g. Reference<br />''DefaultValue: N'Annotation'''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Title
 
|nvarchar (50)
 
|Title of the annotation
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Annotation
 
|nvarchar (MAX)
 
|The annotation entered by the user
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|URI
 
|varchar (255)
 
|The complete URI address of a resource related to the annotation. May be link to a module, e.g. for the annotation type reference
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ReferenceDisplayText
 
|nvarchar (500)
 
|The title of the reference. If the entry is linked to an external module like DiversityReferences, the cached display text of the referenced dataset
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ReferenceURI
 
|varchar (255)
 
|If the entry is linked to an external module like DiversityReferences, the link to the referenced dataset
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|SourceDisplayText
 
|nvarchar (500)
 
|The name of the source. If the entry is linked to an external module like DiversityAgents, the cached display text of the referenced dataset
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|SourceURI
 
|varchar (255)
 
|If the entry is linked to an external module like DiversityAgents, the link to the referenced dataset
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|IsInternal
 
|bit
 
|If an annotation is restricted to authorized users of the database
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ReferencedID
 
|int
 
|The ID of the dataset in the table the annotation refers to
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ReferencedTable
 
|nvarchar (500)
 
|The name of the table the annotation refers to
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: Collection===
 
The collections where the specimen are stored
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>CollectionID</u>
 
|int
 
|Unique reference ID for the collection (= Primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|CollectionParentID
 
|int
 
|For a subcollection within another collection: CollectionID of the collection to which the subcollection belongs. Empty for an independent collection
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|CollectionName
 
|nvarchar (255)
 
|Name of the collection (e. g. 'Herbarium Kew') or subcollection (e. g. 'cone collection', 'alcohol preservations'). This text should be kept relatively short, use Description for additional information
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|CollectionAcronym
 
|nvarchar (10)
 
|A unique code for the Collection, e.g. the herbarium code from Index Herbariorum
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|AdministrativeContactName
 
|nvarchar (500)
 
|The name of the person or organisation responsible for this collection
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|AdministrativeContactAgentURI
 
|varchar (255)
 
|The URI of the person or organisation responsible for the Collection e.g. as provided by the module DiversityAgents
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Description
 
|nvarchar (MAX)
 
|A short description of the collection
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Location
 
|nvarchar (255)
 
|Optionally location of the collection, e.g. the number within a file system or a description of the room(s) housing the (sub)collection
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|CollectionOwner
 
|nvarchar (255)
 
|The owner of the collection as e.g. printed on a label, should be given if CollectionParentID is null
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DisplayOrder
 
|smallint
 
|The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: CollectionAgent===
 
The collector(s) of collection specimens
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>CollectionSpecimenID</u>
 
|int
 
|Refers to ID of CollectionEvent (= Foreign key and part of primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>CollectorsName</u>
 
|nvarchar (255)
 
|Name of the Collector<br />''Preset value: SELECT CombinedNameCache FROM UserProxy WHERE LoginName = USER_NAME()''
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|CollectorsAgentURI
 
|varchar (255)
 
|The URI of the Agent, e.g. as stored within the module DiversityAgents<br />''Preset value: SELECT UserURI FROM UserProxy WHERE LoginName = USER_NAME()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|CollectorsSequence
 
|datetime
 
|The order of collectors in a team. Automatically set by the database system<br />''DefaultValue: getdate()''<br />''Preset value: getdate()''
 
|&nbsp; - &nbsp;
 
|U
 
|-style="background:#FFFFFF;"
 
|CollectorsNumber
 
|nvarchar (50)
 
|Number assigned to a specimen or a batch of specimens by the collector during the collection event (= 'field number')<br />''Preset value: Übername der AccessionNumber''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Notes
 
|nvarchar (MAX)
 
|Notes about the collector, e.g. if the name is uncertain
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DataWithholdingReason
 
|nvarchar (255)
 
|If the dataset is withhold, the reason for withholding the data, otherwise null
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: CollectionEvent===
 
The collection event where the specimen was collected
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>CollectionEventID</u>
 
|int
 
|Unique ID for the collection event  (= Primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|Version
 
|int
 
|The version of the dataset. Automatically set by the system.<br />''DefaultValue: (1)''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|SeriesID
 
|int
 
|The ID of the related expedition. Relates to the PK of the table CollectionExpedition (Foreign key).
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|CollectorsEventNumber
 
|nvarchar (50)
 
|Number assigned to a collection event  by the collector (= 'field number')
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|CollectionDate
 
|datetime
 
|The date of the event calulated from the entries in CollectionDay, -Month and -Year.<br />''Preset value: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|CollectionDay
 
|tinyint
 
|The day of the date of the event or when the collection event started<br />''Preset value: DAY(getdate())''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|CollectionMonth
 
|tinyint
 
|The month of the date  of the event or when the collection event started<br />''Preset value: MONTH(getdate())''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|CollectionYear
 
|smallint
 
|The year of the date  of the event or when the collection event started<br />''Preset value: YEAR(getdate())''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|CollectionDateSupplement
 
|nvarchar (100)
 
|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.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|CollectionDateCategory
 
|nvarchar (50)
 
|Category of the date of the identification e.g. "system", "estimated"  (= foreign key, see  in table CollEventDateCategory_Enum)<br />''Preset value: 'actual'''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|CollectionTime
 
|varchar (50)
 
|The time of the event or when the collection event started
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|CollectionTimeSpan
 
|varchar (50)
 
|The time span e.g. in seconds of the collection event
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LocalityDescription
 
|nvarchar (MAX)
 
|Locality description of the locality, exactly as written on the original label (i.e. without corrections during data entry)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|HabitatDescription
 
|nvarchar (MAX)
 
|Geo-ecological description of the locality, exactly as written on the original label (i.e. without corrections during data entry)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ReferenceTitle
 
|nvarchar (255)
 
|The title of the publication where the collection event was published. Note this is only a cached value where ReferenceURI is present
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ReferenceURI
 
|varchar (255)
 
|URI (e.g. LSID) of the source publication where the collection event is published, may e.g. refer to the module DiversityReferences
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|CollectingMethod
 
|nvarchar (MAX)
 
|Description of the method used for collecting the samples, e.g. traps, moist chambers, drag net
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Notes
 
|nvarchar (MAX)
 
|Notes about the collection event
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|CountryCache
 
|nvarchar (50)
 
|The country where the collection event took place. Cached value derived from an entry in CollectionEventLocalisation
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DataWithholdingReason
 
|nvarchar (255)
 
|If the dataset is withhold, the reason for withholding the data, otherwise null
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ReferenceDetails
 
|nvarchar (50)
 
|The exact location within the reference, e.g. pages, plates
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: CollectionEventImage===
 
The images showing the site of the collection event or other media like a voice recording
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>CollectionEventID</u>
 
|int
 
|Unique ID for the collection event  (= Primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>URI</u>
 
|varchar (255)
 
|The complete URI address of the image. This is only a cached value if ResourceID is available referring to the module DiversityResources
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|ResourceURI
 
|varchar (255)
 
|The URI of the resource (e.g. see module DiversityResources)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ImageType
 
|nvarchar (50)
 
|Type of the image, e.g. map<br />''Preset value: 'photography'''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Notes
 
|nvarchar (MAX)
 
|Notes to this image concerning the collection event
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DataWithholdingReason
 
|nvarchar (255)
 
|If the dataset is withhold, the reason for withholding the data, otherwise null
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Description
 
|xml (MAX)
 
|Description of the image
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: CollectionEventLocalisation===
 
The geographic localisation of a collection event
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>CollectionEventID</u>
 
|int
 
|Refers to the ID of CollectionEvent (= Foreign key and part of primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>LocalisationSystemID</u>
 
|int
 
|Refers to the ID of LocalisationSystem (= Foreign key and part of primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|Location1
 
|nvarchar (255)
 
|Either a named location selected from a thesaurus (e. g. 'Germany, Bavaria, Kleindingharting') or altitude range or other values (e. g. 100-200 m)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Location2
 
|nvarchar (255)
 
|Corresponding value to Location1 e.g. ID or URI of gazetteer or thesaurus
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LocationAccuracy
 
|nvarchar (50)
 
|The accuracy of the determination of this locality
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LocationNotes
 
|nvarchar (MAX)
 
|Notes on the location
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DeterminationDate
 
|smalldatetime
 
|Date of the determination of the geographical localisation<br />''Preset value: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DistanceToLocation
 
|varchar (50)
 
|Distance from the specified place to the real location of the collection event (m)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DirectionToLocation
 
|varchar (50)
 
|Direction from the specified place to the real location of the collection event (Degrees rel. to north)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ResponsibleName
 
|nvarchar (255)
 
|The name of the agent (person or organization) responsible for this entry.<br />''Preset value: dbo.CurrentUserName()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ResponsibleAgentURI
 
|varchar (255)
 
|URI of the person or organisation responsible for the data (see e.g. module DiversityAgents)<br />''Preset value: SELECT AgentURI FROM UserProxy WHERE LoginName = USER_NAME()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|AverageAltitudeCache
 
|float
 
|Calculated altitude as parsed from the location fields
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|AverageLatitudeCache
 
|float
 
|Calculated latitude as parsed from the location fields
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|AverageLongitudeCache
 
|float
 
|Calculated longitude as parsed from the location fields
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Geography
 
|geography
 
|The geography of the localisation
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RecordingMethod
 
|nvarchar (500)
 
|The method or device used for the recording of the localisation
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: CollectionEventProperty===
 
A property of a collection site, e.g. exposition, slope, vegetation. May refer to Diversity Workbench module DiversityScientificTerms
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>CollectionEventID</u>
 
|int
 
|Refers to the ID of CollectionEvent (= Foreign key and part of primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>PropertyID</u>
 
|int
 
|The ID of the descriptor of the collection event, foreign key, see table Descriptor
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|DisplayText
 
|nvarchar (255)
 
|The text for the property as shown e.g. in a user interface
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|PropertyURI
 
|varchar (255)
 
|URI referring to an external datasource e.g. DiversityTerminology
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|PropertyHierarchyCache
 
|nvarchar (MAX)
 
|A cached text of the complete name of the descriptor including superior categories if present
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|PropertyValue
 
|nvarchar (255)
 
|The value of a captured feature  e.g. temperature, pH, vegetation etc. If there is a range this is the lower or first value
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ResponsibleName
 
|nvarchar (255)
 
|The name of the agent (person or organization) responsible for this entry.<br />''Preset value: dbo.CurrentUserName()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ResponsibleAgentURI
 
|varchar (255)
 
|URI of the person or organisation responsible for the data (see e.g. module DiversityAgents)<br />''Preset value: SELECT AgentURI FROM UserProxy WHERE LoginName = USER_NAME()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Notes
 
|nvarchar (MAX)
 
|Notes about the property of the colletion site.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|AverageValueCache
 
|float
 
|For numeric values - a cached average value according to the
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: CollectionEventSeries===
 
The series within which collection events take place
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>SeriesID</u>
 
|int
 
|Primary key. The ID for this expedition  (= Primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|SeriesParentID
 
|int
 
|The ID of the superior expedition
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Description
 
|nvarchar (MAX)
 
|The description of the expedition as it will be printed on e.g. the label
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|SeriesCode
 
|nvarchar (50)
 
|The user defined code for an expedition
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Notes
 
|nvarchar (MAX)
 
|Notes about this expedition
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Geography
 
|geography
 
|The geography of the collection event series
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DateStart
 
|datetime
 
|The date and time when the collection event series started<br />''Preset value: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DateEnd
 
|datetime
 
|The date and time when the collection event series ended
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DateCache
 
|datetime
 
|Obsolete, use fields for start and end of the collection event series instead
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: CollectionEventSeriesImage===
 
The images showing the sites of a collection event series or other media like a voice recording
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>SeriesID</u>
 
|int
 
|Unique ID for the collection event series  (= Foreign key and part of primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>URI</u>
 
|varchar (255)
 
|The complete URI address of the image. This is only a cached value if ResourceID is available referring to the module DiversityResources
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|ResourceURI
 
|varchar (255)
 
|The URI of the resource (e.g. see module DiversityResources)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ImageType
 
|nvarchar (50)
 
|Type of the image, e.g. map<br />''Preset value: 'photography'''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Notes
 
|nvarchar (MAX)
 
|Notes to this image concerning the collection event
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DataWithholdingReason
 
|nvarchar (255)
 
|If the dataset is withhold, the reason for withholding the data, otherwise null
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Description
 
|xml (MAX)
 
|Description of the image
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: CollectionExternalDatasource===
 
CollectionExternalDatasource document the sources of the names.
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>ExternalDatasourceID</u>
 
|int
 
|An ID to identify an external data collection of collection specimen (primary key, the ID has no meaning outside of the DiversityWorkbench system)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|ExternalDatasourceName
 
|nvarchar (255)
 
|The name of the data collection that has been integrated or can be linked to for further analysis
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ExternalDatasourceVersion
 
|nvarchar (255)
 
|The version of this data collection (either official version number, or dates when the collection was integrated)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Rights
 
|nvarchar (500)
 
|A description of copyright agreements or permission to use data from the external database
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ExternalDatasourceAuthors
 
|nvarchar (200)
 
|The persons or institutions responsible for the external database
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ExternalDatasourceURI
 
|nvarchar (300)
 
|The URI of the database provider resp. the external database
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ExternalDatasourceInstitution
 
|nvarchar (300)
 
|The institution responsible for the external database
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|InternalNotes
 
|nvarchar (1500)
 
|Additional notes concerning this data collection
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ExternalAttribute_NameID
 
|nvarchar (255)
 
|The table and field name in the external data collection to which CollectionExternalID refers
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|PreferredSequence
 
|tinyint
 
|For selection in e.g. picklists: of several equal names only the name from the source with the lowest preferred sequence will be provided.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Disabled
 
|bit
 
|If this source should be disabled for selection of names e.g. in picklists
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: CollectionImage===
 
The images showing the collection
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>CollectionID</u>
 
|int
 
|Refers to the ID of Collection (= Foreign key and part of primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>URI</u>
 
|varchar (255)
 
|The complete URI address of the image.
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|ImageType
 
|nvarchar (50)
 
|Type of the image, e.g. label
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Notes
 
|nvarchar (MAX)
 
|Notes about the collection image
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DataWithholdingReason
 
|nvarchar (255)
 
|If the dataset is withhold, the reason for withholding the data, otherwise null
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogInsertedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogInsertedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Description
 
|xml (MAX)
 
|Description of the image
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: CollectionManager===
 
Collection managers within DiversityCollection, responsible of specimen transactions
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>LoginName</u>
 
|nvarchar (50)
 
|A login name which the user uses  for access the DivesityWorkbench, Microsoft domains, etc..
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>AdministratingCollectionID</u>
 
|int
 
|ID for the collection for which the Manager has the right to administrate the transaction. Corresponds to AdministratingCollectionID in table Transaction.
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: CollectionProject===
 
The projects within which the collection specimen were placed
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>CollectionSpecimenID</u>
 
|int
 
|Refers to the ID of CollectionSpecimen (= Foreign key and part of primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>ProjectID</u>
 
|int
 
|ID of the project to which the specimen belongs (Projects are defined in DiversityProjects)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: CollectionRequester===
 
Requesters within DiversityCollection, responsible of specimen transactions
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>LoginName</u>
 
|nvarchar (50)
 
|A login name which the user uses  for access to the DivesityWorkbench, Microsoft domains, etc..
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>AdministratingCollectionID</u>
 
|int
 
|ID for the collection for which the Requester has the right to request specimen. Corresponds to AdministratingCollectionID in table Transaction.
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|IncludeSubcollections
 
|bit
 
|If the subcollections of the administrating collection are accessible for a request
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: CollectionSpecimen===
 
The data directly attributed to the collection specimen
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>CollectionSpecimenID</u>
 
|int
 
|Unique reference ID for the collection specimen record (primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|Version
 
|int
 
|The version of the dataset<br />''DefaultValue: (1)''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|CollectionEventID
 
|int
 
|Refers to the ID of CollectionEvent (= Foreign key and part of primary key)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|CollectionID
 
|int
 
|ID of the Collection as stored in table Collection (= foreign key, see table Collection)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|AccessionNumber
 
|nvarchar (50)
 
|Accession number of the specimen within the collection, e.g. "M-29834752"
 
|&nbsp; - &nbsp;
 
|&nbsp;
 
|-style="background:#FFFFFF;"
 
|AccessionDate
 
|datetime
 
|The date of the accession calculated from the entries in AccessionDay, -Month and -Year
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|AccessionDay
 
|tinyint
 
|The day of the date  when the specimen was acquired in the collection
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|AccessionMonth
 
|tinyint
 
|The month of the date  when the specimen was acquired in the collection
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|AccessionYear
 
|smallint
 
|The year of the date  when the specimen was acquired in the collection
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|AccessionDateSupplement
 
|nvarchar (255)
 
|Verbal or additional accession date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|AccessionDateCategory
 
|nvarchar (50)
 
|Category of the date of the identification e.g. "system", "estimated"  (= foreign key, see  in table xColl_DateCategory_Enum)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DepositorsName
 
|nvarchar (255)
 
|The name of the depositor(s) (person or organization responsible for deposition). Where entire collections are deposited, this should also contain the collection name (e.g. 'Herbarium P. Döbbler')
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DepositorsAgentURI
 
|varchar (255)
 
|The URI of the depositor(s) (person or organization responsible for deposition)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DepositorsAccessionNumber
 
|nvarchar (50)
 
|Accession number of the specimen within the previous or original collection, e.g. 'D-23948'
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LabelTitle
 
|nvarchar (255)
 
|The title of the label e.g. for printing labels.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LabelType
 
|nvarchar (50)
 
|Printed, typewritten, typewritten with handwriting added, entirely in handwriting, etc.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LabelTranscriptionState
 
|nvarchar (50)
 
|The state of the transcription of a label into the database: 'Not started', 'incomplete', 'complete'
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LabelTranscriptionNotes
 
|nvarchar (255)
 
|User defined notes concerning the transcription of the label into the database
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ExsiccataURI
 
|varchar (255)
 
|If specimen is an exsiccata: The URI of the Exsiccata series, e.g. as stored within the DiversityExsiccata module
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ExsiccataAbbreviation
 
|nvarchar (255)
 
|If specimen is an exsiccata: Standard abbreviation of the exsiccata (not necessarily a unique identifier; editors or publication places may change over time)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|OriginalNotes
 
|nvarchar (MAX)
 
|Notes found on the label of the specimen, by the original collector or from a later revision
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|AdditionalNotes
 
|nvarchar (MAX)
 
|Additional notes made by the editor of the specimen record, e. g. 'doubtful identification/locality'
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ReferenceTitle
 
|nvarchar (255)
 
|The title of the publication where the specimen was published. Note this is only a cached value where ReferenceURI is present
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ReferenceURI
 
|varchar (255)
 
|URI (e.g. LSID) of reference where specimen is published, e.g. referring to the module DiversityReferences
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Problems
 
|nvarchar (255)
 
|Description of a problem that occurred during data editing. Typically these entries should be deleted after help has been obtained. Do not enter scientific problems here; use AdditionalNotes for such permanent problems!
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DataWithholdingReason
 
|nvarchar (255)
 
|If the dataset is withhold, the reason for withholding the data, otherwise null
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|InternalNotes
 
|nvarchar (MAX)
 
|Internal notes that should not be published e.g. on websites
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ExternalDatasourceID
 
|int
 
|An ID to identify an external data collection of collection specimen (primary key, the ID has no meaning outside of the DiversityWorkbench system)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ExternalIdentifier
 
|nvarchar (100)
 
|The identifier of the external specimen as defined in the external datasource
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ReferenceDetails
 
|nvarchar (50)
 
|The exact location within the reference, e.g. pages, plates
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: CollectionSpecimenImage===
 
The images, voice recording or other medium of a collection specimen, an identification unit or part within this specimen
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>CollectionSpecimenID</u>
 
|int
 
|Refers to the ID of CollectionSpecimen (= Foreign key and part of primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>URI</u>
 
|varchar (255)
 
|The complete URI address of the image. This is only a cached value if ResourceID is available referring to the module DiversityResources
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|ResourceURI
 
|varchar (255)
 
|The URI of the image, e.g. as stored in the module DiversityResources.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|SpecimenPartID
 
|int
 
|Optional: If the dataset is not related to a part of a specimen, the ID of a related part (= foreign key)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|IdentificationUnitID
 
|int
 
|If image refers to only on out of several identification units for a specimen, refers to the ID of an IdentificationUnit for a CollectionSpecimen (= foreign key)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ImageType
 
|nvarchar (50)
 
|Type of the image, e.g. photograph<br />''Preset value: 'photography'''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Notes
 
|nvarchar (MAX)
 
|Notes about the specimen image
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DataWithholdingReason
 
|nvarchar (255)
 
|If the dataset is withhold, the reason for withholding the data, otherwise null
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Description
 
|xml (MAX)
 
|Description of the image
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: CollectionSpecimenPart===
 
Parts of a collection specimen. Includes a possible hierarchy of the parts
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>CollectionSpecimenID</u>
 
|int
 
|Refers to the ID of CollectionSpecimen (= Foreign key and part of primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|DerivedFromSpecimenPartID
 
|int
 
|SpecimenPartID of the specimen from which the current specimen is derived from
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|PreparationMethod
 
|nvarchar (MAX)
 
|The method used for the preparation of the part of the specimen, e.g. the inoculation method for cultures
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|PreparationDate
 
|datetime
 
|The date and time when the part was preparated e.g when it was separated from the source object
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|AccessionNumber
 
|nvarchar (50)
 
|Accession number of the part of the specimen within the collection if it is different from the accession number of the specimen as stored in the table CollectionSpecimen, e.g. "M-29834752"
 
|&nbsp; - &nbsp;
 
|&nbsp;
 
|-style="background:#FFFFFF;"
 
|PartSublabel
 
|nvarchar (50)
 
|The label for a part of a specimen, e.g. "cone", or a number attached to a duplicate of a specimen
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|CollectionID
 
|int
 
|ID of the Collection as stored in table Collection (= foreign key, see table Collection)<br />''Preset value: -1''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|MaterialCategory
 
|nvarchar (50)
 
|Material category of specimen. Examples: 'herbarium sheets', 'drawings', 'microscopic slides' etc. (= foreign key, see table CollMaterialCategory_Enum)<br />''DefaultValue: N'specimen'''<br />''Preset value: specimen''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|StorageLocation
 
|nvarchar (255)
 
|A code identifying the place where the specimen is stored within the collection. Frequently the accepted scientific name is used as storage location code.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Stock
 
|float
 
|Number of stock units if the specimen is stored in separated units e.g. several boxes or vessels (max. 255)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Notes
 
|nvarchar (MAX)
 
|Notes concerning the storage of the sample
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|<u>SpecimenPartID</u>
 
|int
 
|ID of the collection specimen part (= part of Primary key).
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|StorageContainer
 
|nvarchar (500)
 
|The container in which the part is stored
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|StockUnit
 
|nvarchar (50)
 
|If empty the stock is given as a count, else it contains the unit in which stock is expressed, e.g. µl, ml, kg etc.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ResponsibleName
 
|nvarchar (255)
 
|Name of the person or institution responsible for the preparation
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ResponsibleAgentURI
 
|varchar (255)
 
|URI of the person or institution responsible for the preparation (= foreign key) as stored in the module DiversityAgents
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DataWithholdingReason
 
|nvarchar (255)
 
|If the specimen part is withhold, the reason for withholding the data, otherwise null.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: CollectionSpecimenProcessing===
 
The processing that was applied to a collection specimen
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>CollectionSpecimenID</u>
 
|int
 
|Refers to ID of CollectionSpecimen (= Foreign key and part of primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>ProcessingDate</u>
 
|datetime
 
|Date and time of the start of the processing<br />''DefaultValue: getdate()''
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|ProcessingID
 
|int
 
|ID of the processing method. Refers to ProcessingID in table Processing (foreign key)<br />''DefaultValue: (1)''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Protocoll
 
|nvarchar (100)
 
|The label of the processing protocoll
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|SpecimenPartID
 
|int
 
|Optional: If the dataset is related to a part of a specimen, the ID of a related part (= foreign key, see table CollectionSpecimenPart)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ProcessingDuration
 
|varchar (50)
 
|The duration of the processing including the unit (e.g. 5 min) or the end of the processing starting at the processingDate (e.g. 23.05.2008)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ResponsibleName
 
|nvarchar (255)
 
|Name of the person or institution responsible for the determination
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ResponsibleAgentURI
 
|varchar (255)
 
|URI of the person or institution responsible for the determination (= foreign key) as stored in the module DiversityAgents.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Notes
 
|nvarchar (MAX)
 
|Notes about the processing
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ToolUsage
 
|xml (MAX)
 
|The tools used for the processing and their usage or settings.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: CollectionSpecimenRelation===
 
The relations of a collection specimen to other collection specimen
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>CollectionSpecimenID</u>
 
|int
 
|Unique reference ID for the collection specimen record (primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>RelatedSpecimenURI</u>
 
|varchar (255)
 
|URI of the related specimen
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|RelatedSpecimenDisplayText
 
|varchar (255)
 
|The name of a related specimen as shown e.g. in a user interface
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RelationType
 
|nvarchar (50)
 
|Type of the relation between the specimen (= foreign key, see table CollRelationType_Enum)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RelatedSpecimenCollectionID
 
|int
 
|ID of the Collection as stored in table Collection (= foreign key, see table Collection)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RelatedSpecimenDescription
 
|nvarchar (MAX)
 
|Description of the related specimen
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Notes
 
|nvarchar (MAX)
 
|Notes on the relation to the specimen
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|IsInternalRelationCache
 
|bit
 
|If the relation represents a connection between specimen in this database<br />''DefaultValue: (1)''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: CollectionSpecimenTransaction===
 
The transactions in which a specimen was involved
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>CollectionSpecimenID</u>
 
|int
 
|Refers to ID of CollectionSpecimen (= Foreign key and part of primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>TransactionID</u>
 
|int
 
|Unique ID for the transaction (= Foreign key and part of primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>SpecimenPartID</u>
 
|int
 
|Optional: If the dataset is related to a part of a specimen, the ID of a related part (= foreign key, see table CollectionSpecimenPart)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|IsOnLoan
 
|bit
 
|True if a specimen is on loan
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogInsertedBy
 
|nvarchar (50)
 
|Name of user who first entered (typed or imported) the data.<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogInsertedWhen
 
|smalldatetime
 
|Date and time when the data were first entered (typed or imported) into this database.<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Name of user who last updated the data.<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|smalldatetime
 
|Date and time when the data were last updated.<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|AccessionNumber
 
|nvarchar (255)
 
|Accession number that has been assigen to the part of the specimen e.g. in connection with a former inventory.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: CollectionUser===
 
Users of collections within DiversityCollection
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>LoginName</u>
 
|nvarchar (50)
 
|A login name which the user uses  for access the DivesityWorkbench, Microsoft domains, etc..
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>CollectionID</u>
 
|int
 
|ID for the collection for the User has access to administrate the transaction.
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: Identification===
 
The identifications of the organisms within a specimen
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>CollectionSpecimenID</u>
 
|int
 
|Refers to the ID of CollectionSpecimen (= Foreign key and part of primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>IdentificationUnitID</u>
 
|int
 
|Refers to the ID of IdentficationUnit (= foreign key and part of primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>IdentificationSequence</u>
 
|smallint
 
|The sequence of the identifications. The last identification (having the highest sequence) is regarded as valid<br />''DefaultValue: (1)''<br />''Preset value: 1''
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|IdentificationDate
 
|datetime
 
|The date of the identification calculated from the entries in IdentificationDay, -Month and -Year
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|IdentificationDay
 
|tinyint
 
|The day of the identification event<br />''Preset value: DAY(getdate())''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|IdentificationMonth
 
|tinyint
 
|The month of the identification event<br />''Preset value: MONTH(getdate())''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|IdentificationYear
 
|smallint
 
|The year of the identification event. The year may be empty if only the day or month are known.<br />''Preset value: YEAR(getdate())''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|IdentificationDateSupplement
 
|nvarchar (255)
 
|Verbal or additional identification date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|IdentificationDateCategory
 
|nvarchar (50)
 
|Category of the date of the identification e.g. "system", "estimated"  (= foreign key, see  in table CollDateCategory_Enum)<br />''Preset value: 'actual'''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|VernacularTerm
 
|nvarchar (255)
 
|Name or term other than a taxonomic (= scientific) name, e.g. 'pine', 'limestone', 'conifer', 'hardwood'
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|TaxonomicName
 
|nvarchar (255)
 
|Valid name of the species (including the taxonomic author where available). Example: 'Rosa canina L.'
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|NameURI
 
|varchar (255)
 
|The URI of the taxonomic name, e.g. as provided by the module DiversityTaxonNames.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|IdentificationCategory
 
|nvarchar (50)
 
|Category of the identification e.g. 'determination', 'confirmation', 'absence'  (= foreign key, see table CollIdentificationCategory_Enum)<br />''Preset value: 'determination'''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|IdentificationQualifier
 
|nvarchar (50)
 
|Qualification of the identification e.g. "cf."," aff.", "sp. nov."  (= foreign key, see table CollIdentificationQualifier_Enum)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|TypeStatus
 
|nvarchar (50)
 
|If identification unit is type of a taxonomic name: holotype, syntype, etc. (= foreign key, see table CollTypeStatus_Enum)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|TypeNotes
 
|nvarchar (MAX)
 
|Notes concerning the typification of this specimen
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ReferenceTitle
 
|nvarchar (255)
 
|Publications or authoritative opinions of scientist used during the identification process. Example: enter 'Schmeil-Fitschen 1995' if this field flora was used.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ReferenceURI
 
|varchar (255)
 
|The URI of the reference e.g. as provided by the module DiversityReferences
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Notes
 
|nvarchar (MAX)
 
|User defined notes, e.g. the reason for a re-determination / change of the name, etc.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ResponsibleName
 
|nvarchar (255)
 
|Name of the person or institution responsible for the determination<br />''Preset value: dbo.CurrentUserName()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ResponsibleAgentURI
 
|varchar (255)
 
|URI of the person or institution responsible for the determination (= foreign key) as stored in the module DiversityAgents.<br />''Preset value: SELECT AgentURI FROM UserProxy WHERE LoginName = USER_NAME()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|Date and time when the dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Login of the user who created the dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|Date and time when the dataset was changed<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Login of the user who changed the dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ReferenceDetails
 
|nvarchar (50)
 
|The exact location within the reference, e.g. pages, plates
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: IdentificationUnit===
 
Organism that is present in or on a collection specimen
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>CollectionSpecimenID</u>
 
|int
 
|Refers to the ID of CollectionSpecimen (= Foreign key and part of primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>IdentificationUnitID</u>
 
|int
 
|ID of the identification unit (= part of Primary key). Usually one of possibly several organisms present on the collection specimen. Example: parasite with hyperparasite on plant leaf = 3 units,
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|LastIdentificationCache
 
|nvarchar (255)
 
|The last identification as entered in table Identification
 
|R
 
|&nbsp;
 
|-style="background:#FFFFFF;"
 
|FamilyCache
 
|nvarchar (255)
 
|A cached value of the family of the taxon of the last identification. Can be set by the editor if NameURI  in table Identification is NULL, otherwise set by the system.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|OrderCache
 
|nvarchar (255)
 
|A cached value of the order of the taxon of the last identification. Can be set by the editor if NameURI in table Identification is NULL, otherwise set by the system.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|TaxonomicGroup
 
|nvarchar (50)
 
|Taxonomic group the organism identified by this unit belongs to. Groups listed in table CollTaxonomicGroup_Enum  (= foreign key)
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|OnlyObserved
 
|bit
 
|True if the organism was only observed rather than collected. It is therefore not present on the preserved specimen. Example: Tree under which the collected mycorrhizal fungus grew.<br />''DefaultValue: (0)''<br />''Preset value: True''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RelatedUnitID
 
|int
 
|The IdentificationUnitID of the organism or substrate, on which this organism is growing (= foreign key)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RelationType
 
|nvarchar (50)
 
|The relation of an unit to its substrate, e.g. parasitism, symbiosis etc. as stored in CollRelationType_Enum  (= foreign key)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ColonisedSubstratePart
 
|nvarchar (255)
 
|If a substrate association exists: part of the substrate that is affected in the interaction (e.g. 'leaves' if a fungus is growing on the leaves of an infected plant)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LifeStage
 
|nvarchar (255)
 
|Examples: 'II, III' for spore generations of rusts or 'seed', 'seedling' etc. for higher plants
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Gender
 
|nvarchar (50)
 
|The gender of the identification unit, e.g. 'male'
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|NumberOfUnits
 
|smallint
 
|The number of units of this identification unit, e.g. 400 beetle in a bottle
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ExsiccataNumber
 
|nvarchar (50)
 
|If specimen is an exsiccata: Number of current specimen within the exsiccata series
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ExsiccataIdentification
 
|smallint
 
|Refers to the IdentificationSequence in Identification (= foreign key). The name under which the collection specimen resp. this unit is published within an exsiccata.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|UnitIdentifier
 
|nvarchar (50)
 
|An identifier for the identification of the unit e.g. a number painted on a tree within an experimental plot
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|UnitDescription
 
|nvarchar (50)
 
|Description of the unit, esp. if not an organism but parts or remnants of it were present or observed, e.g. a nest of an insect or a song of a bird
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Circumstances
 
|nvarchar (50)
 
|Circumstances of the occurence of the organism
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DisplayOrder
 
|smallint
 
|The sequence in which the units within this specimen will appear on e.g. a label where the first unit may be printed in the header and others  in the text below. 0 means the unit should not appear on a label.<br />''DefaultValue: (1)''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Notes
 
|nvarchar (MAX)
 
|Further information on the identification unit or interaction, e. g. infection symptoms like 'producing galls'
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|HierarchyCache
 
|nvarchar (500)
 
|&nbsp;
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ParentUnitID
 
|int
 
|The IdentificationUnitID of a parent organism of which this organism is a child of (= foreign key).
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: IdentificationUnitAnalysis===
 
The analysis values taken from an identification unit
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>CollectionSpecimenID</u>
 
|int
 
|Refers to the ID of CollectionSpecimen (= Foreign key and part of primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>IdentificationUnitID</u>
 
|int
 
|Refers to the ID of IdentficationUnit (= foreign key and part of primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>AnalysisID</u>
 
|int
 
|Analysis ID, foreign key of table Analysis.
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>AnalysisNumber</u>
 
|nvarchar (50)
 
|Number of the analysis<br />''Preset value: 1''
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|AnalysisResult
 
|nvarchar (MAX)
 
|The result of the analysis
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ExternalAnalysisURI
 
|varchar (255)
 
|An URI for an analysis as defined in an external datasoure
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ResponsibleName
 
|nvarchar (255)
 
|Name of the person or institution responsible for the determination<br />''DefaultValue: [dbo].[CurrentUserName]()''<br />''Preset value: dbo.CurrentUserName()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ResponsibleAgentURI
 
|varchar (255)
 
|URI of the person or institution responsible for the determination (= foreign key) as stored in the module DiversityAgents.<br />''Preset value: SELECT AgentURI FROM UserProxy WHERE LoginName = USER_NAME()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|AnalysisDate
 
|nvarchar (50)
 
|The date of the analysis<br />''Preset value: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|SpecimenPartID
 
|int
 
|ID of the part of a specimen (optional, Foreign key) if the analysis was done with a part of the specimen (see table CollectionSpecimenPart).
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Notes
 
|nvarchar (MAX)
 
|Notes concerning this analysis
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ToolUsage
 
|xml (MAX)
 
|The tools used for the analysis and their usage or settings.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: IdentificationUnitGeoAnalysis===
 
The geographical position or region of an organism at a certain time
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>CollectionSpecimenID</u>
 
|int
 
|Refers to the ID of CollectionSpecimen (= Foreign key and part of primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>IdentificationUnitID</u>
 
|int
 
|Refers to the ID of IdentficationUnit (= foreign key and part of primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>AnalysisDate</u>
 
|datetime
 
|The date of the analysis
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|Geography
 
|geography
 
|The geography of the identification unit according to WGS84, e.g. a point (latitide, longitude and altitude)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Geometry
 
|geometry (MAX)
 
|The geometry of the identifiction unit, e.g. an area
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ResponsibleName
 
|nvarchar (255)
 
|Name of the person or institution responsible for the determination
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ResponsibleAgentURI
 
|varchar (255)
 
|URI of the person or institution responsible for the determination (= foreign key) as stored in the module DiversityAgents.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Notes
 
|nvarchar (MAX)
 
|Notes concerning this analysis
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: IdentificationUnitInPart===
 
The list of the organisms that are found in a part of the specimen
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>CollectionSpecimenID</u>
 
|int
 
|Refers to the ID of CollectionSpecimen (= Foreign key and part of primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>IdentificationUnitID</u>
 
|int
 
|ID of the identification unit (= part of Primary key). Usually one of possibly several organisms present on the collection specimen. Example: parasite with hyperparasite on plant leaf = 3 units,
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>SpecimenPartID</u>
 
|int
 
|ID of the part of a specimen (optional, Foreign key) if the identification unit is located on a part of the specimen (see table CollectionSpecimenPart).
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|DisplayOrder
 
|smallint
 
|The sequence in which the units within this part will appear on e.g. a label where the first unit may be printed in the header and others  in the text below. 0 means the unit should not appear on a label.<br />''DefaultValue: (1)''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Description
 
|nvarchar (500)
 
|A description of the unit, esp. if not a whole unit but e.g. parts of it are stored in the collection, e.g. a nest of a bird
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogInsertedBy
 
|nvarchar (50)
 
|Name of user who first entered (typed or imported) the data.<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogInsertedWhen
 
|smalldatetime
 
|Date and time when the data were first entered (typed or imported) into this database.<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Name of user who last updated the data.<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|smalldatetime
 
|Date and time when the data were last updated.<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: LocalisationSystem===
 
The geographic localisation systems, e.g. coordinates
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>LocalisationSystemID</u>
 
|int
 
|Unique ID for the localisation system (= Primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|LocalisationSystemParentID
 
|int
 
|LocalisationSystemID of the superior LocalisationSystem
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LocalisationSystemName
 
|nvarchar (100)
 
|Name of the system used for the determination of the place of the collection, e. g. Gauss-Krüger, MTB, GIS
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DefaultAccuracyOfLocalisation
 
|nvarchar (50)
 
|The default for the accuracy of values that can be reached with this method
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DefaultMeasurementUnit
 
|nvarchar (50)
 
|The default measurement unit for the localisation system, e.g. m, geograpic coordinates
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ParsingMethodName
 
|nvarchar (50)
 
|Internal value, specifying a programming method used for parsing text in fields Location1/Location2 in table CollectionLocalisation
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DisplayText
 
|nvarchar (50)
 
|Short abbreviated description of the localisation system as displayed in the user interface
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DisplayEnable
 
|bit
 
|Specifies if this item is enabled to be used within the database. LocalisationSystems can be disabled to avoid seeing them, but to keep the definition for the future.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DisplayOrder
 
|smallint
 
|The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Description
 
|nvarchar (255)
 
|Description of the localisation method
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DisplayTextLocation1
 
|nvarchar (50)
 
|Short abbreviated description of the attribute Location1 in the table CollectionGeography as displayed in the user interface
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DescriptionLocation1
 
|nvarchar (255)
 
|Description of the attribute Location1 in the table CollectionGeography as displayed in the user interface
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DisplayTextLocation2
 
|nvarchar (50)
 
|Short abbreviated description of the attribute Location2 in the table CollectionGeography as displayed in the user interface
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DescriptionLocation2
 
|nvarchar (255)
 
|Description of the attribute Location2 in the table CollectionGeography as displayed in the user interface
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: Processing===
 
The processings of the specimen
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>ProcessingID</u>
 
|int
 
|ID of the processing (Primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|ProcessingParentID
 
|int
 
|The ID of the superior type of the processing
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DisplayText
 
|nvarchar (50)
 
|The display text of the processing as shown e.g. in a user interface
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Description
 
|nvarchar (MAX)
 
|Description of the processing
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Notes
 
|nvarchar (MAX)
 
|Notes about the processing
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ProcessingURI
 
|varchar (255)
 
|An URI for a processing as defined in an external datasource
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|OnlyHierarchy
 
|bit
 
|If the entry is only used for the hierarchical arrangement of the entries<br />''DefaultValue: (0)''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: ProcessingMaterialCategory===
 
The processings that are possible for a certain material category
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>ProcessingID</u>
 
|int
 
|ID of the processing. Refers to ProcessingID in table Processing (foreign key)<br />''DefaultValue: (1)''
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>MaterialCategory</u>
 
|nvarchar (50)
 
|Material category of specimen. Examples: 'herbarium sheets', 'drawings', 'microscopic slides' etc.<br />''DefaultValue: N'specimen'''
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: ProjectAnalysis===
 
The types of the analysis that are available for a project
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>AnalysisID</u>
 
|int
 
|ID of the analysis (Primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>ProjectID</u>
 
|int
 
|ID of the project to which the specimen belongs (Projects are defined in DiversityProjects)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: ProjectProcessing===
 
The types of processing available within a project
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>ProcessingID</u>
 
|int
 
|ID of the Processing (Primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>ProjectID</u>
 
|int
 
|ID of the project to which the specimen belongs (Projects are defined in DiversityProjects)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: Property===
 
The list of the properties that can be specified for the collection site
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>PropertyID</u>
 
|int
 
|Unique ID for the property (= Primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|PropertyParentID
 
|int
 
|PropertyID of the superior Property
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|PropertyName
 
|nvarchar (100)
 
|Name of the system used for the characterisation of the collection site, e. g. Lithostratigraphy
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DefaultAccuracyOfProperty
 
|nvarchar (50)
 
|The default for the accuracy of values that can be reached with this method
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DefaultMeasurementUnit
 
|nvarchar (50)
 
|The default measurement unit for the characterisation system, e.g. pH
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ParsingMethodName
 
|nvarchar (50)
 
|Internal value, specifying a programming method used for parsing the contents in table CollectionEventProperty
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DisplayText
 
|nvarchar (50)
 
|Short abbreviated description of the characterisation system as displayed in the user interface
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DisplayEnabled
 
|bit
 
|Specifies if this item is enabled to be used within the database. Properties can be disabled to avoid seeing them, but to keep the definition for the future.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|DisplayOrder
 
|smallint
 
|The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Description
 
|nvarchar (255)
 
|Description of the characterisation method
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: Transaction===
 
Transactions like loan, borrow, gift, exchange etc. of specimen if they are e.g. permanently or temporary transfered from one collection to another
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>TransactionID</u>
 
|int
 
|Unique ID for the transaction (= Primary key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|ParentTransactionID
 
|int
 
|The ID of a preceeding transaction of a superior transaction if transactions are organized in a hierarchy
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|TransactionType
 
|nvarchar (50)
 
|Type of the transaction e.g. gift in or out, exchange in or out, purchase in or out<br />''DefaultValue: N'exchange'''
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|TransactionTitle
 
|nvarchar (200)
 
|The title of the transaction as e.g. shown in an user interface
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ReportingCategory
 
|nvarchar (50)
 
|A group defined for the transaction, e. g. a taxonomic group as used for exchange balancing
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|AdministratingCollectionID
 
|int
 
|ID of the collection thas is responsible for the administration of the transaction.
 
|R
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|MaterialDescription
 
|nvarchar (MAX)
 
|ID of the project to which the transaction belongs (Projects are defined in DiversityProjects)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|MaterialCategory
 
|nvarchar (50)
 
|Material category of specimen. Examples: 'herbarium sheets', 'drawings', 'microscopic slides' etc.<br />''DefaultValue: N'specimen'''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|MaterialCollectors
 
|nvarchar (MAX)
 
|The collectors of the material
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|FromCollectionID
 
|int
 
|The ID of the collection from which the specimen were transfered, e.g. the donating collection of a gift
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|FromTransactionPartnerName
 
|nvarchar (255)
 
|Name of  the person or institution  from which the specimen were transfered, e.g. the donator of a gift
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|FromTransactionPartnerAgentURI
 
|varchar (255)
 
|The URI of the transaction partner (see e.g. module DiversityAgents)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|FromTransactionNumber
 
|nvarchar (50)
 
|Number or code by which a transaction may be recorded by the administration of the source of the specimen, e.g. the donating collection of a gift
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ToCollectionID
 
|int
 
|The ID of the collection to which the specimen were transfered, e.g. the receiver of a gift
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ToTransactionPartnerName
 
|nvarchar (255)
 
|Name of  the person or institution  to which the specimen were transfered, e.g. the receiver of a gift
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ToTransactionPartnerAgentURI
 
|varchar (255)
 
|The URI of the transaction partner (see e.g. module DiversityAgents)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ToTransactionNumber
 
|nvarchar (50)
 
|Number or code by which a transaction may be recorded by the administration of the destination of the specimen, e.g. the receiving collection of a gift
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|NumberOfUnits
 
|smallint
 
|The number of units that were (initially) included in the transaction
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|Investigator
 
|nvarchar (50)
 
|The investigator for whose study a transacted material was sent
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|TransactionComment
 
|nvarchar (MAX)
 
|Comments about the exchanged material addressed to the transaction partner
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|BeginDate
 
|datetime
 
|Date when the transaction started
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|AgreedEndDate
 
|datetime
 
|End of the transaction period, e.g. if the time for borrowing the specimen is restricted
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ActualEndDate
 
|datetime
 
|Actual end of the transaction when e.g. the borrowed specimen were returned to the owner
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|InternalNotes
 
|nvarchar (MAX)
 
|Internal notes about this transaction, not to be published e.g. on a web page
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ResponsibleName
 
|nvarchar (255)
 
|The person responsible for this transaction
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|ResponsibleAgentURI
 
|varchar (255)
 
|The URI of the person, team or organisation responsible for the data (see e.g. module DiversityAgents)
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedWhen
 
|datetime
 
|The time when this dataset was created<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogCreatedBy
 
|nvarchar (50)
 
|Who created this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedWhen
 
|datetime
 
|The last time when this dataset was updated<br />''DefaultValue: getdate()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|LogUpdatedBy
 
|nvarchar (50)
 
|Who was the last to update this dataset<br />''DefaultValue: user_name()''
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|R
 
|&nbsp; - &nbsp;
 
|}
 
 
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''Columns'''
 
|'''Related table'''
 
|'''Columns in related table'''
 
|'''Update rule'''
 
|'''Delete rule'''
 
|-
 
|AnalysisParentID
 
|Analysis
 
|AnalysisID
 
|NO ACTION
 
|NO ACTION
 
|-
 
|}
 
 
===Table: TransactionDocument===
 
The history of transactions resp. the documents connected to the transactions
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#FFFFFF;"
 
!Column
 
!Data type
 
!Description
 
!Requ.
 
!Ind.
 
|-style="background:#FFFFFF;"
 
|<u>TransactionID</u>
 
|int
 
|Unique ID for the Transaction, refers to table Transaction  (= Part of primary key and foreign key)
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|<u>Date</u>
 
|datetime
 
|The date of the event of a transaction
 
|R
 
|U
 
|-style="background:#FFFFFF;"
 
|TransactionText
 
|nvarchar (MAX)
 
|The text of a transaction document
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|TransactionDocument
 
|image (2147483647)
 
|A scanned document connected to this transaction event
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|-style="background:#FFFFFF;"
 
|InternalNotes
 
|nvarchar (MAX)
 
|Internal notes about this transaction event
 
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;

Revision as of 08:19, 11 September 2013

Color code

no restrictions The value of this entity has no restriction
read only The access to this entity is restricted to read only
hidden The entity is hidden from a user interface
inapplicable This entity is not applicable in the given context
preset The value of this entity is set by the program, not by the user


Table: Analysis

Analysis types used within the database

Column Data type Description Requ. Ind.
AnalysisID int ID of the analysis (Primary key) R U
AnalysisParentID int Analysis ID of the parent analysis if it belongs to a certain type documented in this table   -     -  
DisplayText nvarchar (50) Name of the analysis as e.g. shown in user interface   -     -  
Description nvarchar (MAX) Description of the analysis   -     -  
MeasurementUnit nvarchar (50) The measurement unit used for the analysis, e.g. mm, µmol, kg   -     -  
Notes nvarchar (MAX) Notes concerning this analysis   -     -  
AnalysisURI varchar (255) URI referring to an external documentation of the analysis   -     -  
OnlyHierarchy bit If the entry is only used for the hierarchical arrangement of the entries
DefaultValue: (0)
  -     -  
LogCreatedWhen datetime The time when this dataset was created
DefaultValue: getdate()
  -     -  
LogCreatedBy nvarchar (50) Who created this dataset
DefaultValue: user_name()
  -     -  
LogUpdatedWhen datetime The last time when this dataset was updated
DefaultValue: getdate()
  -     -  
LogUpdatedBy nvarchar (50) Who was the last to update this dataset
DefaultValue: user_name()
  -     -  
RowGUID uniqueidentifier
DefaultValue: newsequentialid()
R   -  


Relations to other tables

Columns Related table Columns in related table Update rule Delete rule
AnalysisParentID Analysis AnalysisID NO ACTION NO ACTION


Footnotes: The following conventions and abbreviations have been used in the tables: Columns of primary key:underlined R: It is required to enter data in this field. I: The field is indexed to enable faster searching. U: unique index