|
|
| 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)'' |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DisplayText
| |
| |nvarchar (50)
| |
| |Short abbreviated description of the object, displayed in the user interface
| |
| | -
| |
| | -
| |
| |-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.
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Notes
| |
| |nvarchar (500)
| |
| |Internal development notes about usage, definition, etc. of an enumerated object
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogInsertedBy
| |
| |nvarchar (50)
| |
| |Name of user who first entered (typed or imported) the data.<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogInsertedWhen
| |
| |smalldatetime
| |
| |Date and time when the data were first entered (typed or imported) into this database.<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Name of user who last updated the data.<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |smalldatetime
| |
| |Date and time when the data were last updated.<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |AnnotationType
| |
| |nvarchar (50)
| |
| |The type of the annotation as defined in AnnotationType_Enum, e.g. Reference<br />''DefaultValue: N'Annotation'''
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Title
| |
| |nvarchar (50)
| |
| |Title of the annotation
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Annotation
| |
| |nvarchar (MAX)
| |
| |The annotation entered by the user
| |
| |R
| |
| | -
| |
| |-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
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ReferenceURI
| |
| |varchar (255)
| |
| |If the entry is linked to an external module like DiversityReferences, the link to the referenced dataset
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |SourceURI
| |
| |varchar (255)
| |
| |If the entry is linked to an external module like DiversityAgents, the link to the referenced dataset
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |IsInternal
| |
| |bit
| |
| |If an annotation is restricted to authorized users of the database
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ReferencedID
| |
| |int
| |
| |The ID of the dataset in the table the annotation refers to
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ReferencedTable
| |
| |nvarchar (500)
| |
| |The name of the table the annotation refers to
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |CollectionAcronym
| |
| |nvarchar (10)
| |
| |A unique code for the Collection, e.g. the herbarium code from Index Herbariorum
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |AdministrativeContactName
| |
| |nvarchar (500)
| |
| |The name of the person or organisation responsible for this collection
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Description
| |
| |nvarchar (MAX)
| |
| |A short description of the collection
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| | -
| |
| |-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.
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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()''
| |
| | -
| |
| | -
| |
| |-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()''
| |
| | -
| |
| |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''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Notes
| |
| |nvarchar (MAX)
| |
| |Notes about the collector, e.g. if the name is uncertain
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DataWithholdingReason
| |
| |nvarchar (255)
| |
| |If the dataset is withhold, the reason for withholding the data, otherwise null
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |SeriesID
| |
| |int
| |
| |The ID of the related expedition. Relates to the PK of the table CollectionExpedition (Foreign key).
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |CollectorsEventNumber
| |
| |nvarchar (50)
| |
| |Number assigned to a collection event by the collector (= 'field number')
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |CollectionDate
| |
| |datetime
| |
| |The date of the event calulated from the entries in CollectionDay, -Month and -Year.<br />''Preset value: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |CollectionDay
| |
| |tinyint
| |
| |The day of the date of the event or when the collection event started<br />''Preset value: DAY(getdate())''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |CollectionMonth
| |
| |tinyint
| |
| |The month of the date of the event or when the collection event started<br />''Preset value: MONTH(getdate())''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |CollectionYear
| |
| |smallint
| |
| |The year of the date of the event or when the collection event started<br />''Preset value: YEAR(getdate())''
| |
| | -
| |
| | -
| |
| |-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.
| |
| | -
| |
| | -
| |
| |-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'''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |CollectionTime
| |
| |varchar (50)
| |
| |The time of the event or when the collection event started
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |CollectionTimeSpan
| |
| |varchar (50)
| |
| |The time span e.g. in seconds of the collection event
| |
| | -
| |
| | -
| |
| |-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)
| |
| | -
| |
| | -
| |
| |-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)
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |CollectingMethod
| |
| |nvarchar (MAX)
| |
| |Description of the method used for collecting the samples, e.g. traps, moist chambers, drag net
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Notes
| |
| |nvarchar (MAX)
| |
| |Notes about the collection event
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |CountryCache
| |
| |nvarchar (50)
| |
| |The country where the collection event took place. Cached value derived from an entry in CollectionEventLocalisation
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DataWithholdingReason
| |
| |nvarchar (255)
| |
| |If the dataset is withhold, the reason for withholding the data, otherwise null
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ReferenceDetails
| |
| |nvarchar (50)
| |
| |The exact location within the reference, e.g. pages, plates
| |
| | -
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ImageType
| |
| |nvarchar (50)
| |
| |Type of the image, e.g. map<br />''Preset value: 'photography'''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Notes
| |
| |nvarchar (MAX)
| |
| |Notes to this image concerning the collection event
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DataWithholdingReason
| |
| |nvarchar (255)
| |
| |If the dataset is withhold, the reason for withholding the data, otherwise null
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Description
| |
| |xml (MAX)
| |
| |Description of the image
| |
| | -
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Location2
| |
| |nvarchar (255)
| |
| |Corresponding value to Location1 e.g. ID or URI of gazetteer or thesaurus
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LocationAccuracy
| |
| |nvarchar (50)
| |
| |The accuracy of the determination of this locality
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LocationNotes
| |
| |nvarchar (MAX)
| |
| |Notes on the location
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DeterminationDate
| |
| |smalldatetime
| |
| |Date of the determination of the geographical localisation<br />''Preset value: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DistanceToLocation
| |
| |varchar (50)
| |
| |Distance from the specified place to the real location of the collection event (m)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DirectionToLocation
| |
| |varchar (50)
| |
| |Direction from the specified place to the real location of the collection event (Degrees rel. to north)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ResponsibleName
| |
| |nvarchar (255)
| |
| |The name of the agent (person or organization) responsible for this entry.<br />''Preset value: dbo.CurrentUserName()''
| |
| | -
| |
| | -
| |
| |-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()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |AverageAltitudeCache
| |
| |float
| |
| |Calculated altitude as parsed from the location fields
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |AverageLatitudeCache
| |
| |float
| |
| |Calculated latitude as parsed from the location fields
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |AverageLongitudeCache
| |
| |float
| |
| |Calculated longitude as parsed from the location fields
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Geography
| |
| |geography
| |
| |The geography of the localisation
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RecordingMethod
| |
| |nvarchar (500)
| |
| |The method or device used for the recording of the localisation
| |
| | -
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |PropertyURI
| |
| |varchar (255)
| |
| |URI referring to an external datasource e.g. DiversityTerminology
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |PropertyHierarchyCache
| |
| |nvarchar (MAX)
| |
| |A cached text of the complete name of the descriptor including superior categories if present
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ResponsibleName
| |
| |nvarchar (255)
| |
| |The name of the agent (person or organization) responsible for this entry.<br />''Preset value: dbo.CurrentUserName()''
| |
| | -
| |
| | -
| |
| |-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()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Notes
| |
| |nvarchar (MAX)
| |
| |Notes about the property of the colletion site.
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |AverageValueCache
| |
| |float
| |
| |For numeric values - a cached average value according to the
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Description
| |
| |nvarchar (MAX)
| |
| |The description of the expedition as it will be printed on e.g. the label
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |SeriesCode
| |
| |nvarchar (50)
| |
| |The user defined code for an expedition
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Notes
| |
| |nvarchar (MAX)
| |
| |Notes about this expedition
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Geography
| |
| |geography
| |
| |The geography of the collection event series
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DateStart
| |
| |datetime
| |
| |The date and time when the collection event series started<br />''Preset value: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DateEnd
| |
| |datetime
| |
| |The date and time when the collection event series ended
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DateCache
| |
| |datetime
| |
| |Obsolete, use fields for start and end of the collection event series instead
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ImageType
| |
| |nvarchar (50)
| |
| |Type of the image, e.g. map<br />''Preset value: 'photography'''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Notes
| |
| |nvarchar (MAX)
| |
| |Notes to this image concerning the collection event
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DataWithholdingReason
| |
| |nvarchar (255)
| |
| |If the dataset is withhold, the reason for withholding the data, otherwise null
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Description
| |
| |xml (MAX)
| |
| |Description of the image
| |
| | -
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ExternalDatasourceVersion
| |
| |nvarchar (255)
| |
| |The version of this data collection (either official version number, or dates when the collection was integrated)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Rights
| |
| |nvarchar (500)
| |
| |A description of copyright agreements or permission to use data from the external database
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ExternalDatasourceAuthors
| |
| |nvarchar (200)
| |
| |The persons or institutions responsible for the external database
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ExternalDatasourceURI
| |
| |nvarchar (300)
| |
| |The URI of the database provider resp. the external database
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ExternalDatasourceInstitution
| |
| |nvarchar (300)
| |
| |The institution responsible for the external database
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |InternalNotes
| |
| |nvarchar (1500)
| |
| |Additional notes concerning this data collection
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ExternalAttribute_NameID
| |
| |nvarchar (255)
| |
| |The table and field name in the external data collection to which CollectionExternalID refers
| |
| | -
| |
| | -
| |
| |-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.
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Disabled
| |
| |bit
| |
| |If this source should be disabled for selection of names e.g. in picklists
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Notes
| |
| |nvarchar (MAX)
| |
| |Notes about the collection image
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DataWithholdingReason
| |
| |nvarchar (255)
| |
| |If the dataset is withhold, the reason for withholding the data, otherwise null
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogInsertedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogInsertedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Description
| |
| |xml (MAX)
| |
| |Description of the image
| |
| | -
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |CollectionEventID
| |
| |int
| |
| |Refers to the ID of CollectionEvent (= Foreign key and part of primary key)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |CollectionID
| |
| |int
| |
| |ID of the Collection as stored in table Collection (= foreign key, see table Collection)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |AccessionNumber
| |
| |nvarchar (50)
| |
| |Accession number of the specimen within the collection, e.g. "M-29834752"
| |
| | -
| |
| |
| |
| |-style="background:#FFFFFF;"
| |
| |AccessionDate
| |
| |datetime
| |
| |The date of the accession calculated from the entries in AccessionDay, -Month and -Year
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |AccessionDay
| |
| |tinyint
| |
| |The day of the date when the specimen was acquired in the collection
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |AccessionMonth
| |
| |tinyint
| |
| |The month of the date when the specimen was acquired in the collection
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |AccessionYear
| |
| |smallint
| |
| |The year of the date when the specimen was acquired in the collection
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |AccessionDateSupplement
| |
| |nvarchar (255)
| |
| |Verbal or additional accession date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'
| |
| | -
| |
| | -
| |
| |-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)
| |
| | -
| |
| | -
| |
| |-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')
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DepositorsAgentURI
| |
| |varchar (255)
| |
| |The URI of the depositor(s) (person or organization responsible for deposition)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DepositorsAccessionNumber
| |
| |nvarchar (50)
| |
| |Accession number of the specimen within the previous or original collection, e.g. 'D-23948'
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LabelTitle
| |
| |nvarchar (255)
| |
| |The title of the label e.g. for printing labels.
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LabelType
| |
| |nvarchar (50)
| |
| |Printed, typewritten, typewritten with handwriting added, entirely in handwriting, etc.
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LabelTranscriptionState
| |
| |nvarchar (50)
| |
| |The state of the transcription of a label into the database: 'Not started', 'incomplete', 'complete'
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LabelTranscriptionNotes
| |
| |nvarchar (255)
| |
| |User defined notes concerning the transcription of the label into the database
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| | -
| |
| |-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)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |OriginalNotes
| |
| |nvarchar (MAX)
| |
| |Notes found on the label of the specimen, by the original collector or from a later revision
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |AdditionalNotes
| |
| |nvarchar (MAX)
| |
| |Additional notes made by the editor of the specimen record, e. g. 'doubtful identification/locality'
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ReferenceURI
| |
| |varchar (255)
| |
| |URI (e.g. LSID) of reference where specimen is published, e.g. referring to the module DiversityReferences
| |
| | -
| |
| | -
| |
| |-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!
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DataWithholdingReason
| |
| |nvarchar (255)
| |
| |If the dataset is withhold, the reason for withholding the data, otherwise null
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |InternalNotes
| |
| |nvarchar (MAX)
| |
| |Internal notes that should not be published e.g. on websites
| |
| | -
| |
| | -
| |
| |-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)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ExternalIdentifier
| |
| |nvarchar (100)
| |
| |The identifier of the external specimen as defined in the external datasource
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ReferenceDetails
| |
| |nvarchar (50)
| |
| |The exact location within the reference, e.g. pages, plates
| |
| | -
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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.
| |
| | -
| |
| | -
| |
| |-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)
| |
| | -
| |
| | -
| |
| |-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)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ImageType
| |
| |nvarchar (50)
| |
| |Type of the image, e.g. photograph<br />''Preset value: 'photography'''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Notes
| |
| |nvarchar (MAX)
| |
| |Notes about the specimen image
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DataWithholdingReason
| |
| |nvarchar (255)
| |
| |If the dataset is withhold, the reason for withholding the data, otherwise null
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Description
| |
| |xml (MAX)
| |
| |Description of the image
| |
| | -
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |PreparationDate
| |
| |datetime
| |
| |The date and time when the part was preparated e.g when it was separated from the source object
| |
| | -
| |
| | -
| |
| |-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"
| |
| | -
| |
| |
| |
| |-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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |CollectionID
| |
| |int
| |
| |ID of the Collection as stored in table Collection (= foreign key, see table Collection)<br />''Preset value: -1''
| |
| |R
| |
| | -
| |
| |-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
| |
| | -
| |
| |-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.
| |
| | -
| |
| | -
| |
| |-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)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Notes
| |
| |nvarchar (MAX)
| |
| |Notes concerning the storage of the sample
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |-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
| |
| | -
| |
| | -
| |
| |-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.
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ResponsibleName
| |
| |nvarchar (255)
| |
| |Name of the person or institution responsible for the preparation
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ResponsibleAgentURI
| |
| |varchar (255)
| |
| |URI of the person or institution responsible for the preparation (= foreign key) as stored in the module DiversityAgents
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DataWithholdingReason
| |
| |nvarchar (255)
| |
| |If the specimen part is withhold, the reason for withholding the data, otherwise null.
| |
| | -
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Protocoll
| |
| |nvarchar (100)
| |
| |The label of the processing protocoll
| |
| | -
| |
| | -
| |
| |-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)
| |
| | -
| |
| | -
| |
| |-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)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ResponsibleName
| |
| |nvarchar (255)
| |
| |Name of the person or institution responsible for the determination
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ResponsibleAgentURI
| |
| |varchar (255)
| |
| |URI of the person or institution responsible for the determination (= foreign key) as stored in the module DiversityAgents.
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Notes
| |
| |nvarchar (MAX)
| |
| |Notes about the processing
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ToolUsage
| |
| |xml (MAX)
| |
| |The tools used for the processing and their usage or settings.
| |
| | -
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RelationType
| |
| |nvarchar (50)
| |
| |Type of the relation between the specimen (= foreign key, see table CollRelationType_Enum)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RelatedSpecimenCollectionID
| |
| |int
| |
| |ID of the Collection as stored in table Collection (= foreign key, see table Collection)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RelatedSpecimenDescription
| |
| |nvarchar (MAX)
| |
| |Description of the related specimen
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Notes
| |
| |nvarchar (MAX)
| |
| |Notes on the relation to the specimen
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |IsInternalRelationCache
| |
| |bit
| |
| |If the relation represents a connection between specimen in this database<br />''DefaultValue: (1)''
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogInsertedBy
| |
| |nvarchar (50)
| |
| |Name of user who first entered (typed or imported) the data.<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogInsertedWhen
| |
| |smalldatetime
| |
| |Date and time when the data were first entered (typed or imported) into this database.<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Name of user who last updated the data.<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |smalldatetime
| |
| |Date and time when the data were last updated.<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |-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.
| |
| | -
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |IdentificationDay
| |
| |tinyint
| |
| |The day of the identification event<br />''Preset value: DAY(getdate())''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |IdentificationMonth
| |
| |tinyint
| |
| |The month of the identification event<br />''Preset value: MONTH(getdate())''
| |
| | -
| |
| | -
| |
| |-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())''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |IdentificationDateSupplement
| |
| |nvarchar (255)
| |
| |Verbal or additional identification date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'
| |
| | -
| |
| | -
| |
| |-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'''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |VernacularTerm
| |
| |nvarchar (255)
| |
| |Name or term other than a taxonomic (= scientific) name, e.g. 'pine', 'limestone', 'conifer', 'hardwood'
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |TaxonomicName
| |
| |nvarchar (255)
| |
| |Valid name of the species (including the taxonomic author where available). Example: 'Rosa canina L.'
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |NameURI
| |
| |varchar (255)
| |
| |The URI of the taxonomic name, e.g. as provided by the module DiversityTaxonNames.
| |
| | -
| |
| | -
| |
| |-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'''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |IdentificationQualifier
| |
| |nvarchar (50)
| |
| |Qualification of the identification e.g. "cf."," aff.", "sp. nov." (= foreign key, see table CollIdentificationQualifier_Enum)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |TypeStatus
| |
| |nvarchar (50)
| |
| |If identification unit is type of a taxonomic name: holotype, syntype, etc. (= foreign key, see table CollTypeStatus_Enum)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |TypeNotes
| |
| |nvarchar (MAX)
| |
| |Notes concerning the typification of this specimen
| |
| | -
| |
| | -
| |
| |-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.
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ReferenceURI
| |
| |varchar (255)
| |
| |The URI of the reference e.g. as provided by the module DiversityReferences
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Notes
| |
| |nvarchar (MAX)
| |
| |User defined notes, e.g. the reason for a re-determination / change of the name, etc.
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ResponsibleName
| |
| |nvarchar (255)
| |
| |Name of the person or institution responsible for the determination<br />''Preset value: dbo.CurrentUserName()''
| |
| | -
| |
| | -
| |
| |-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()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |Date and time when the dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Login of the user who created the dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |Date and time when the dataset was changed<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Login of the user who changed the dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ReferenceDetails
| |
| |nvarchar (50)
| |
| |The exact location within the reference, e.g. pages, plates
| |
| | -
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| |
| |
| |-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.
| |
| | -
| |
| | -
| |
| |-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.
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| |-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''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RelatedUnitID
| |
| |int
| |
| |The IdentificationUnitID of the organism or substrate, on which this organism is growing (= foreign key)
| |
| | -
| |
| | -
| |
| |-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)
| |
| | -
| |
| | -
| |
| |-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)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LifeStage
| |
| |nvarchar (255)
| |
| |Examples: 'II, III' for spore generations of rusts or 'seed', 'seedling' etc. for higher plants
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Gender
| |
| |nvarchar (50)
| |
| |The gender of the identification unit, e.g. 'male'
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |NumberOfUnits
| |
| |smallint
| |
| |The number of units of this identification unit, e.g. 400 beetle in a bottle
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ExsiccataNumber
| |
| |nvarchar (50)
| |
| |If specimen is an exsiccata: Number of current specimen within the exsiccata series
| |
| | -
| |
| | -
| |
| |-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.
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Circumstances
| |
| |nvarchar (50)
| |
| |Circumstances of the occurence of the organism
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Notes
| |
| |nvarchar (MAX)
| |
| |Further information on the identification unit or interaction, e. g. infection symptoms like 'producing galls'
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |HierarchyCache
| |
| |nvarchar (500)
| |
| |
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ParentUnitID
| |
| |int
| |
| |The IdentificationUnitID of a parent organism of which this organism is a child of (= foreign key).
| |
| | -
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ExternalAnalysisURI
| |
| |varchar (255)
| |
| |An URI for an analysis as defined in an external datasoure
| |
| | -
| |
| | -
| |
| |-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()''
| |
| | -
| |
| | -
| |
| |-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()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |AnalysisDate
| |
| |nvarchar (50)
| |
| |The date of the analysis<br />''Preset value: getdate()''
| |
| | -
| |
| | -
| |
| |-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).
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Notes
| |
| |nvarchar (MAX)
| |
| |Notes concerning this analysis
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ToolUsage
| |
| |xml (MAX)
| |
| |The tools used for the analysis and their usage or settings.
| |
| | -
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Geometry
| |
| |geometry (MAX)
| |
| |The geometry of the identifiction unit, e.g. an area
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ResponsibleName
| |
| |nvarchar (255)
| |
| |Name of the person or institution responsible for the determination
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ResponsibleAgentURI
| |
| |varchar (255)
| |
| |URI of the person or institution responsible for the determination (= foreign key) as stored in the module DiversityAgents.
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Notes
| |
| |nvarchar (MAX)
| |
| |Notes concerning this analysis
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| |-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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogInsertedBy
| |
| |nvarchar (50)
| |
| |Name of user who first entered (typed or imported) the data.<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogInsertedWhen
| |
| |smalldatetime
| |
| |Date and time when the data were first entered (typed or imported) into this database.<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Name of user who last updated the data.<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |smalldatetime
| |
| |Date and time when the data were last updated.<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DefaultAccuracyOfLocalisation
| |
| |nvarchar (50)
| |
| |The default for the accuracy of values that can be reached with this method
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DefaultMeasurementUnit
| |
| |nvarchar (50)
| |
| |The default measurement unit for the localisation system, e.g. m, geograpic coordinates
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ParsingMethodName
| |
| |nvarchar (50)
| |
| |Internal value, specifying a programming method used for parsing text in fields Location1/Location2 in table CollectionLocalisation
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DisplayText
| |
| |nvarchar (50)
| |
| |Short abbreviated description of the localisation system as displayed in the user interface
| |
| | -
| |
| | -
| |
| |-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.
| |
| | -
| |
| | -
| |
| |-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.
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Description
| |
| |nvarchar (255)
| |
| |Description of the localisation method
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DisplayTextLocation1
| |
| |nvarchar (50)
| |
| |Short abbreviated description of the attribute Location1 in the table CollectionGeography as displayed in the user interface
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DescriptionLocation1
| |
| |nvarchar (255)
| |
| |Description of the attribute Location1 in the table CollectionGeography as displayed in the user interface
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DisplayTextLocation2
| |
| |nvarchar (50)
| |
| |Short abbreviated description of the attribute Location2 in the table CollectionGeography as displayed in the user interface
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DescriptionLocation2
| |
| |nvarchar (255)
| |
| |Description of the attribute Location2 in the table CollectionGeography as displayed in the user interface
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DisplayText
| |
| |nvarchar (50)
| |
| |The display text of the processing as shown e.g. in a user interface
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Description
| |
| |nvarchar (MAX)
| |
| |Description of the processing
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Notes
| |
| |nvarchar (MAX)
| |
| |Notes about the processing
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ProcessingURI
| |
| |varchar (255)
| |
| |An URI for a processing as defined in an external datasource
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |OnlyHierarchy
| |
| |bit
| |
| |If the entry is only used for the hierarchical arrangement of the entries<br />''DefaultValue: (0)''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |PropertyName
| |
| |nvarchar (100)
| |
| |Name of the system used for the characterisation of the collection site, e. g. Lithostratigraphy
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DefaultAccuracyOfProperty
| |
| |nvarchar (50)
| |
| |The default for the accuracy of values that can be reached with this method
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DefaultMeasurementUnit
| |
| |nvarchar (50)
| |
| |The default measurement unit for the characterisation system, e.g. pH
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ParsingMethodName
| |
| |nvarchar (50)
| |
| |Internal value, specifying a programming method used for parsing the contents in table CollectionEventProperty
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |DisplayText
| |
| |nvarchar (50)
| |
| |Short abbreviated description of the characterisation system as displayed in the user interface
| |
| | -
| |
| | -
| |
| |-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.
| |
| | -
| |
| | -
| |
| |-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.
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Description
| |
| |nvarchar (255)
| |
| |Description of the characterisation method
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |TransactionTitle
| |
| |nvarchar (200)
| |
| |The title of the transaction as e.g. shown in an user interface
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ReportingCategory
| |
| |nvarchar (50)
| |
| |A group defined for the transaction, e. g. a taxonomic group as used for exchange balancing
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |AdministratingCollectionID
| |
| |int
| |
| |ID of the collection thas is responsible for the administration of the transaction.
| |
| |R
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |MaterialDescription
| |
| |nvarchar (MAX)
| |
| |ID of the project to which the transaction belongs (Projects are defined in DiversityProjects)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |MaterialCategory
| |
| |nvarchar (50)
| |
| |Material category of specimen. Examples: 'herbarium sheets', 'drawings', 'microscopic slides' etc.<br />''DefaultValue: N'specimen'''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |MaterialCollectors
| |
| |nvarchar (MAX)
| |
| |The collectors of the material
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |FromCollectionID
| |
| |int
| |
| |The ID of the collection from which the specimen were transfered, e.g. the donating collection of a gift
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |FromTransactionPartnerAgentURI
| |
| |varchar (255)
| |
| |The URI of the transaction partner (see e.g. module DiversityAgents)
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ToCollectionID
| |
| |int
| |
| |The ID of the collection to which the specimen were transfered, e.g. the receiver of a gift
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ToTransactionPartnerAgentURI
| |
| |varchar (255)
| |
| |The URI of the transaction partner (see e.g. module DiversityAgents)
| |
| | -
| |
| | -
| |
| |-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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |NumberOfUnits
| |
| |smallint
| |
| |The number of units that were (initially) included in the transaction
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |Investigator
| |
| |nvarchar (50)
| |
| |The investigator for whose study a transacted material was sent
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |TransactionComment
| |
| |nvarchar (MAX)
| |
| |Comments about the exchanged material addressed to the transaction partner
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |BeginDate
| |
| |datetime
| |
| |Date when the transaction started
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |AgreedEndDate
| |
| |datetime
| |
| |End of the transaction period, e.g. if the time for borrowing the specimen is restricted
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ActualEndDate
| |
| |datetime
| |
| |Actual end of the transaction when e.g. the borrowed specimen were returned to the owner
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |InternalNotes
| |
| |nvarchar (MAX)
| |
| |Internal notes about this transaction, not to be published e.g. on a web page
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ResponsibleName
| |
| |nvarchar (255)
| |
| |The person responsible for this transaction
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |ResponsibleAgentURI
| |
| |varchar (255)
| |
| |The URI of the person, team or organisation responsible for the data (see e.g. module DiversityAgents)
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |R
| |
| | -
| |
| |}
| |
|
| |
|
| |
|
| |
| <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
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |TransactionDocument
| |
| |image (2147483647)
| |
| |A scanned document connected to this transaction event
| |
| | -
| |
| | -
| |
| |-style="background:#FFFFFF;"
| |
| |InternalNotes
| |
| |nvarchar (MAX)
| |
| |Internal notes about this transaction event
| |
| | - | | | - |
| | - | | | - |