copilot

please create a sssom mapping to darwincore (https://dwc.tdwg.org) in tsv format to include in a *.tsv file for the database table as defined below: 
### Table **CollectionEventRegulation**
Regulation applied to a collection event
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __CollectionEventID__| int| Part of primay key, refers to unique ID for the table CollectionEvent (= foreign key)| NO| Refers to table CollectionEvent|
| __Regulation__| nvarchar (400)| Regulation as defined in the table Regulation. Used to ensure, that user checked correct entry with authorized stuff| NO| -|
| TransactionID| int| Refers to unique TransactionID for the table Transaction (= foreign key)| YES| Refers to table Transaction|
| LogCreatedWhen| datetime| Point in time when this data set was createdDefault value: getdate()| YES| -|
| LogCreatedBy| nvarchar (50)| Name of the creator of this data setDefault value: suser_sname()| YES| -|
| LogUpdatedWhen| datetime| Point in time when this data set was updated lastDefault value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of the person to update this data set lastDefault value: suser_sname()| YES| -|
| RowGUID| uniqueidentifier| -Default value: newsequentialid()| NO| -|

please create a sssom mapping to abcd 3.0 (https://abcd.tdwg.org/3.0/) including a metadata block with a curie_map based on https://www.diversityworkbench.de/manual/dwb_latest/modules/diversitycollection/internals_dc/database_dc/database_structure_dc/database_tables_dc/index.html#table-analysis. Use the license https://creativecommons.org/licenses/by/4.0/. Include the columns subject_id, subject_label, predicate_id, object_id, object_label, mapping_justification, confidence, comment. Use tsv format to include in a *.tsv file for the database table as defined below: 
### Table **Analysis**
Analysis types used within the database
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __AnalysisID__| int| ID of the analysis (primary key)| NO| -|
| AnalysisParentID| int| Analysis ID of the parent analysis, if it belongs to a certain type documented in this table| YES| Refers to table Analysis|
| DisplayText| nvarchar (50)| Name of the analysis as e.g. shown in user interface| YES| -|
| Description| nvarchar (MAX)| Description of the analysis| YES| -|
| MeasurementUnit| nvarchar (50)| The measurement unit used for the analysis, e.g. mm, µmol, kg| YES| -|
| Notes| nvarchar (MAX)| Notes on this analysis| YES| -|
| AnalysisURI| varchar (255)| URI referring to an external documentation of the analysis| YES| -|
| OnlyHierarchy| bit| If the entry is only used for the hierarchical arrangement of the entriesDefault value: (0)| YES| -|
| LogCreatedWhen| datetime| Point in time when this data set was createdDefault value: getdate()| YES| -|
| LogCreatedBy| nvarchar (50)| Name of the creator of this data setDefault value: suser_sname()| YES| -|
| LogUpdatedWhen| datetime| Point in time when this data set was updated lastDefault value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of the person to update this data set lastDefault value: suser_sname()| YES| -|
| RowGUID| uniqueidentifier| -Default value: newsequentialid()| NO| -|


please create a sssom mapping to abcd 3.0 (https://abcd.tdwg.org/3.0/) including a metadata block with a curie_map based on https://www.diversityworkbench.de/manual/dwb_latest/modules/diversitycollection/internals_dc/database_dc/database_structure_dc/database_tables_dc/index.html#table-analysis. Use the license https://creativecommons.org/licenses/by/4.0/. Use tsv format to include in a *.tsv file for the database table as defined below: 
### Table **Analysis**
Analysis types used within the database
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __AnalysisID__| int| ID of the analysis (primary key)| NO| -|
| AnalysisParentID| int| Analysis ID of the parent analysis, if it belongs to a certain type documented in this table| YES| Refers to table Analysis|
| DisplayText| nvarchar (50)| Name of the analysis as e.g. shown in user interface| YES| -|
| Description| nvarchar (MAX)| Description of the analysis| YES| -|
| MeasurementUnit| nvarchar (50)| The measurement unit used for the analysis, e.g. mm, µmol, kg| YES| -|
| Notes| nvarchar (MAX)| Notes on this analysis| YES| -|
| AnalysisURI| varchar (255)| URI referring to an external documentation of the analysis| YES| -|
| OnlyHierarchy| bit| If the entry is only used for the hierarchical arrangement of the entriesDefault value: (0)| YES| -|
| LogCreatedWhen| datetime| Point in time when this data set was createdDefault value: getdate()| YES| -|
| LogCreatedBy| nvarchar (50)| Name of the creator of this data setDefault value: suser_sname()| YES| -|
| LogUpdatedWhen| datetime| Point in time when this data set was updated lastDefault value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of the person to update this data set lastDefault value: suser_sname()| YES| -|
| RowGUID| uniqueidentifier| -Default value: newsequentialid()| NO| -|

please create a sssom mapping to darwincore (https://dwc.tdwg.org) including a metadata block with a curie_map based on https://www.diversityworkbench.de/manual/dwb_latest/modules/diversitycollection/internals_dc/database_dc/database_structure_dc/database_tables_dc/index.html#table-CollectionEventSeries. Use the license https://creativecommons.org/licenses/by/4.0/. Include the metadata in the mapping file. Use tsv format to include in a *.tsv file for the database table as defined below: 
### Table **CollectionEventSeries**
The series whithin which collection events take place
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __SeriesID__| int| Primary key. The ID for this series of collection events (= primary key)| NO| -|
| SeriesParentID| int| The ID of the superior series of collection events| YES| Refers to table CollectionEventSeries|
| Description| nvarchar (MAX)| The description of the series of collection events as it will be printed on e.g. the label| NO| -|
| SeriesCode| nvarchar (50)| The user defined code for a series of collection events| YES| -|
| Notes| nvarchar (MAX)| Notes on this series of collection events| YES| -|
| Geography| geography| The geography of the series of collection events| YES| -|
| DateStart| datetime| Point in time when the series of collection events started| YES| -|
| DateEnd| datetime| Point in time when the series of collection events ended| YES| -|
| DateCache| datetime| The first date of the depending events, used for sorting the expeditions [controlled by the database]| YES| -|
| DateSupplement| 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 series comprises a period. The time of the event, if necessary.| YES| -|
| LogCreatedWhen| datetime| Point in time when this data set was createdDefault value: getdate()| YES| -|
| LogCreatedBy| nvarchar (50)| Name of the creator of this data setDefault value: suser_sname()| YES| -|
| LogUpdatedWhen| datetime| Point in time when this data set was updated lastDefault value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of the person to update this data set lastDefault value: suser_sname()| YES| -|
| RowGUID| uniqueidentifier| -Default value: newsequentialid()| NO| -|


please create a sssom mapping to darwincore (https://dwc.tdwg.org) including a metadata block with a curie_map based on https://www.diversityworkbench.de/manual/dwb_latest/modules/diversitycollection/internals_dc/database_dc/database_structure_dc/database_tables_dc/index.html#table-CollectionEventSeriesDescriptor. Use the license https://creativecommons.org/licenses/by/4.0/. Include the metadata in the mapping file. Use tsv format to include in a *.tsv file for the database table as defined below: 
### Table **CollectionEventSeriesDescriptor**
The Descriptors for the CollectionEventSeries
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __SeriesID__| int| Unique ID for the CollectionEventSeries  (foreign key + part of primary key)| NO| Refers to table CollectionEventSeries|
| __DescriptorID__| int| Unique ID for the descriptor, Part of PK| NO| -|
| Descriptor| nvarchar (200)| The DescriptorDefault value: ''| NO| -|
| URL| varchar (500)| URL of the Descriptor. In case of a module related Descriptor, the link to the module entry resp. the related webserviceDefault value: ''| YES| -|
| DescriptorType| nvarchar (50)| Type of the Descriptor as described in table CollectionEventSeriesDescriptorType_EnumDefault value: N'Descriptor'| YES| Refers to table CollEventSeriesDescriptorType_Enum|
| LogInsertedBy| nvarchar (50)| Name of user who first entered (typed or imported) the data.Default value: suser_sname()| YES| -|
| LogInsertedWhen| smalldatetime| Date and time when the data were first entered (typed or imported) into this database.Default value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of user who last updated the data.Default value: suser_sname()| YES| -|
| LogUpdatedWhen| smalldatetime| Date and time when the data were last updated.Default value: getdate()| YES| -|
| RowGUID| uniqueidentifier| -Default value: newsequentialid()| NO| -|




please create a sssom mapping to darwincore (https://dwc.tdwg.org) including a metadata block with a curie_map based on https://www.diversityworkbench.de/manual/dwb_latest/modules/diversitycollection/internals_dc/database_dc/database_structure_dc/database_tables_dc/index.html#table-CollectionImage. Use the license https://creativecommons.org/licenses/by/4.0/. Include the metadata in the mapping file. Use tsv format to include in a *.tsv file for the database table as defined below: 
### Table **CollectionImage**
The images showing the collection
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __CollectionID__| int| Refers to the ID of Collection (= foreign key and part of primary key)| NO| Refers to table Collection|
| __URI__| varchar (255)| The complete URI address of the image. | NO| -|
| ImageType| nvarchar (50)| Type of the image, e.g. label| YES| Refers to table CollCollectionImageType_Enum|
| Notes| nvarchar (MAX)| Notes on the collection image| YES| -|
| Description| xml (MAX)| Description of the image| YES| -|
| Title| nvarchar (500)| Title of the resource| YES| -|
| IPR| nvarchar (500)| Intellectual Property Rights; the rights given to persons for their intellectual property| YES| -|
| CreatorAgent| nvarchar (500)| Person or organization originally creating the resource| YES| -|
| CreatorAgentURI| varchar (255)| Link to the module DiversityAgents| YES| -|
| CopyrightStatement| nvarchar (500)| Notice on rights held in and for the resource| YES| -|
| LicenseType| nvarchar (500)| Type of an official or legal permission to do or own a specified thing, e.g. Creative Common licenses| YES| -|
| InternalNotes| nvarchar (500)| Internal notes which should not be published e.g. on websites| YES| -|
| LicenseHolder| nvarchar (500)| The person or institution holding the license| YES| -|
| LicenseHolderAgentURI| nvarchar (500)| The link to a module containing futher information on the person or institution holding the license| YES| -|
| LicenseYear| nvarchar (50)| The year of license declaration| YES| -|
| LocationGeometry| geometry (MAX)| Geometry of the collection e.g. within a floor plan| YES| -|
| RecordingDate| datetime| The recording date of the resource| YES| -|
| DataWithholdingReason| nvarchar (255)| If the data set is withhold, the reason for withholding the data, otherwise null| YES| -|
| LogInsertedWhen| datetime| Point in time when this data set was createdDefault value: getdate()| YES| -|
| LogInsertedBy| nvarchar (50)| Name of the creator of this data setDefault value: suser_sname()| YES| -|
| LogUpdatedWhen| datetime| Point in time when this data set was updated lastDefault value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of the person to update this data set lastDefault value: suser_sname()| YES| -|
| RowGUID| uniqueidentifier| -Default value: newsequentialid()| NO| -|



please create a sssom mapping to darwincore (https://dwc.tdwg.org) including a metadata block with a curie_map based on https://www.diversityworkbench.de/manual/dwb_latest/modules/diversitycollection/internals_dc/database_dc/database_structure_dc/database_tables_dc/index.html#table-CollectionProject. Use the license https://creativecommons.org/licenses/by/4.0/. Include the metadata in the mapping file. Use tsv format to include in a *.tsv file for the database table as defined below: 
### Table **CollectionProject**
The projects within which the collection specimen were placed
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __CollectionSpecimenID__| int| Refers to the ID of CollectionSpecimen (= foreign key and part of primary key)| NO| Refers to table CollectionSpecimen|
| __ProjectID__| int| ID of the project to which the specimen belongs (Projects are defined in DiversityProjects)| NO| Refers to table ProjectProxy|
| LogCreatedWhen| datetime| Point in time when this data set was createdDefault value: getdate()| YES| -|
| LogCreatedBy| nvarchar (50)| Name of the creator of this data setDefault value: suser_sname()| YES| -|
| LogUpdatedWhen| datetime| Point in time when this data set was updated lastDefault value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of the person to update this data set lastDefault value: suser_sname()| YES| -|
| RowGUID| uniqueidentifier| -Default value: newsequentialid()| NO| -|


please create a sssom mapping to darwincore (https://dwc.tdwg.org) including a metadata block with a curie_map based on https://www.diversityworkbench.de/manual/dwb_latest/modules/diversitycollection/internals_dc/database_dc/database_structure_dc/database_tables_dc/index.html#table-CollectionSpecimen. Use the license https://creativecommons.org/licenses/by/4.0/. Include the metadata in the mapping file. Use tsv format to include in a *.tsv file for the database table as defined below: 
### Table **CollectionSpecimen**
The data directly attributed to the collected specimen
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __CollectionSpecimenID__| int| Unique ID for the table CollectionSpecimen (primary key)| NO| -|
| Version| int| The version of the data setDefault value: (1)| NO| -|
| CollectionEventID| int| Refers to the ID of table CollectionEvent (= foreign key and part of primary key)| YES| Refers to table CollectionEvent|
| AccessionNumber| nvarchar (50)| Accession number of the specimen within the collection, e.g. "M-29834752"| YES| -|
| AccessionDate| datetime| The date of the accession calculated from the entries in AccessionDay, -Month and -Year| YES| -|
| AccessionDay| tinyint| The day of the date when the specimen was acquired in the collection| YES| -|
| AccessionMonth| tinyint| The month of the date when the specimen was acquired in the collection| YES| -|
| AccessionYear| smallint| The year of the date when the specimen was acquired in the collection| YES| -|
| AccessionDateSupplement| nvarchar (255)| Verbal or additional accession date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'| YES| -|
| AccessionDateCategory| nvarchar (50)| Category of the date of the accession e.g. "system", "estimated"  (= foreign key, see  in table CollDateCategory_Enum)| YES| Refers to table CollDateCategory_Enum|
| 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')| YES| -|
| DepositorsAgentURI| varchar (255)| The URI of the depositor(s) (person or organization responsible for deposition)| YES| -|
| DepositorsAccessionNumber| nvarchar (50)| Accession number of the specimen within the previous or original collection, e.g. 'D-23948'| YES| -|
| LabelTitle| nvarchar (MAX)| The title of the label e.g. for printing labels.| YES| -|
| LabelType| nvarchar (50)| Printed, typewritten, typewritten with handwriting added, entirely in handwriting, etc.| YES| Refers to table CollLabelType_Enum|
| LabelTranscriptionState| nvarchar (50)| The state of the transcription of a label into the database: 'Not started', 'incomplete', 'complete'| YES| Refers to table CollLabelTranscriptionState_Enum|
| LabelTranscriptionNotes| nvarchar (MAX)| User defined notes on the transcription of the label into the database| YES| -|
| ExsiccataURI| varchar (255)| If specimen is an exsiccata: The URI of the exsiccata series, e.g. as stored within the DiversityExsiccata module| YES| -|
| 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)| YES| -|
| OriginalNotes| nvarchar (MAX)| Notes found on the label of the specimen by the original collector or from a later revision| YES| -|
| AdditionalNotes| nvarchar (MAX)| Additional notes made by the editor of the specimen record, e.g. 'doubtful identification/locality'| YES| -|
| Problems| nvarchar (255)| Description of a problem which 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!| YES| -|
| DataWithholdingReason| nvarchar (255)| If the data set is withhold, the reason for withholding the data, otherwise nullDefault value: N'Withhold by default'| YES| -|
| InternalNotes| nvarchar (MAX)| Internal notes which should not be published e.g. on websites| YES| -|
| ExternalDatasourceID| int| An ID to identify an external data collection of the collected specimen (primary key, the ID has no meaning outside of the DiversityWorkbench system)| YES| Refers to table CollectionExternalDatasource|
| ExternalIdentifier| nvarchar (100)| The identifier of the external specimen as defined in the external data source| YES| -|
| LogCreatedWhen| datetime| Point in time when this data set was createdDefault value: getdate()| YES| -|
| LogCreatedBy| nvarchar (50)| Name of the creator of this data setDefault value: suser_sname()| YES| -|
| LogUpdatedWhen| datetime| Point in time when this data set was updated lastDefault value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of the person to update this data set lastDefault value: suser_sname()| YES| -|
| RowGUID| uniqueidentifier| -Default value: newsequentialid()| NO| -|


please create a sssom mapping to darwincore (https://dwc.tdwg.org) including a metadata block with a curie_map based on https://www.diversityworkbench.de/manual/dwb_latest/modules/diversitycollection/internals_dc/database_dc/database_structure_dc/database_tables_dc/index.html#table-CollectionSpecimenImage. Use the license https://creativecommons.org/licenses/by/4.0/. Include the metadata in the mapping file. Use tsv format to include in a *.tsv file for the database table as defined below: 
### Table **CollectionSpecimenImage**
The images of a collection specimen or of an organism (stored in table IdentificationUnit) within this specimen
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __CollectionSpecimenID__| int| Refers to the ID of CollectionSpecimen (= foreign key and part of primary key)| NO| Refers to table CollectionSpecimen and table IdentificationUnit|
| __URI__| varchar (255)| The complete URI address of the image. This is only a cached value, if ResourceID is available and referring to the module DiversityResources| NO| -|
| ResourceURI| varchar (255)| The URI of the image, e.g. as stored in the module DiversityResources. | YES| -|
| SpecimenPartID| int| Optional: If the data set is not related to a part of a specimen, the ID of a related part (= foreign key)| YES| Refers to table CollectionSpecimenPart|
| IdentificationUnitID| int| If image refers to only one out of several IdentificationUnits for a specimen, refers to the ID of an IdentificationUnit for a collection specimen (= foreign key)| YES| Refers to table IdentificationUnit|
| ImageType| nvarchar (50)| Type of the image, e.g. photograph| YES| Refers to table CollSpecimenImageType_Enum|
| Notes| nvarchar (MAX)| Notes on the specimen image| YES| -|
| Description| xml (MAX)| Description of the image| YES| -|
| Title| nvarchar (500)| Title of the resource| YES| -|
| IPR| nvarchar (500)| Intellectual Property Rights; the rights given to persons for their intellectual property| YES| -|
| CreatorAgent| nvarchar (500)| Person or organization originally creating the resource| YES| -|
| CreatorAgentURI| varchar (255)| Link to the module DiversityAgents| YES| -|
| CopyrightStatement| nvarchar (500)| Notice on rights held in and for the resource| YES| -|
| LicenseType| nvarchar (500)| Type of an official or legal permission to do or own a specified thing, e. g. Creative Common Licenses| YES| -|
| LicenseURI| varchar (500)| The URI of the license for the resource| YES| -|
| LicenseHolder| nvarchar (500)| The person or institution holding the license| YES| -|
| LicenseHolderAgentURI| nvarchar (500)| The link to a module containing futher information on the person or institution holding the license| YES| -|
| LicenseYear| nvarchar (50)| The year of license declaration| YES| -|
| LicenseNotes| nvarchar (500)| Notice on license for the resource| YES| -|
| DataWithholdingReason| nvarchar (255)| If the data set is withhold, the reason for withholding the data, otherwise null| YES| -|
| DisplayOrder| int| The order in which the images should be shown in a interface| YES| -|
| InternalNotes| nvarchar (500)| Internal notes which should not be published e.g. on websites| YES| -|
| LogCreatedWhen| datetime| Point in time when this data set was createdDefault value: getdate()| YES| -|
| LogCreatedBy| nvarchar (50)| Name of the creator of this data setDefault value: suser_sname()| YES| -|
| LogUpdatedWhen| datetime| Point in time when this data set was updated lastDefault value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of the person to update this data set lastDefault value: suser_sname()| YES| -|
| RowGUID| uniqueidentifier| -Default value: newsequentialid()| NO| -|


please create a sssom mapping to darwincore (https://dwc.tdwg.org) including a metadata block with a curie_map based on https://www.diversityworkbench.de/manual/dwb_latest/modules/diversitycollection/internals_dc/database_dc/database_structure_dc/database_tables_dc/index.html#table-CollectionSpecimenPart. Use the license https://creativecommons.org/licenses/by/4.0/. Include the metadata in the mapping file. Use tsv format to include in a *.tsv file for the database table as defined below: 
### Table **CollectionSpecimenPart**
Parts of a collected specimen. Includes a possible hierarchy of the parts
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __CollectionSpecimenID__| int| Refers to the ID of CollectionSpecimen (= foreign key and part of primary key)| NO| Refers to table CollectionSpecimen and table CollectionSpecimenPart|
| __SpecimenPartID__| int| Unique ID of the part of the collection specimen (= part of primary key). | NO| -|
| DerivedFromSpecimenPartID| int| SpecimenPartID of the specimen from which the current specimen is derived from| YES| Refers to table CollectionSpecimenPart|
| PreparationMethod| nvarchar (MAX)| The method used for the preparation of the part of the specimen, e.g. the inoculation method for cultures| YES| -|
| PreparationDate| datetime| Point in time when the part was preparated e.g when it was separated from the source object| YES| -|
| 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"| YES| -|
| PartSublabel| nvarchar (50)| The label for a part of a specimen, e.g. "cone", or a number attached to a duplicate of a specimen| YES| -|
| CollectionID| int| ID of the collection as stored in table Collection (= foreign key, see table Collection)| NO| Refers to table Collection|
| MaterialCategory| nvarchar (50)| Material category of specimen. Examples: 'herbarium sheets', 'drawings', 'microscopic slides' etc. (= foreign key, see table CollMaterialCategory_Enum)Default value: N'specimen'| NO| Refers to table CollMaterialCategory_Enum|
| 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.| YES| -|
| Stock| float| Number of stock units, if the specimen is stored in separated units e.g. several boxes or vessels (max. 255)| YES| -|
| 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.| YES| -|
| StorageContainer| nvarchar (500)| The container in which the part is stored| YES| -|
| ResponsibleName| nvarchar (255)| Name of the person or institution responsible for the preparation| YES| -|
| ResponsibleAgentURI| varchar (255)| URI of the person or institution responsible for the preparation (= foreign key) as stored in the module DiversityAgents| YES| -|
| Notes| nvarchar (MAX)| Notes on the storage of the sample| YES| -|
| DataWithholdingReason| nvarchar (255)| If the specimen part is withhold, the reason for withholding the data, otherwise null.| YES| -|
| LogCreatedWhen| datetime| Point in time when this data set was createdDefault value: getdate()| YES| -|
| LogCreatedBy| nvarchar (50)| Name of the creator of this data setDefault value: suser_sname()| YES| -|
| LogUpdatedWhen| datetime| Point in time when this data set was updated lastDefault value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of the person to update this data set lastDefault value: suser_sname()| YES| -|
| RowGUID| uniqueidentifier| -Default value: newsequentialid()| NO| -|




please create a sssom mapping to darwincore (https://dwc.tdwg.org) including a metadata block with a curie_map based on https://www.diversityworkbench.de/manual/dwb_latest/modules/diversitycollection/internals_dc/database_dc/database_structure_dc/database_tables_dc/index.html#table-CollectionSpecimenProcessing. Use the license https://creativecommons.org/licenses/by/4.0/. Include the metadata in the mapping file. Use tsv format to include in a *.tsv file for the database table as defined below: 
### Table **CollectionSpecimenProcessing**
The processing which was applied to a collected specimen
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __CollectionSpecimenID__| int| Refers to ID of CollectionSpecimen (= foreign key and part of primary key)| NO| Refers to table CollectionSpecimen and table CollectionSpecimenPart|
| __SpecimenProcessingID__| int| Unique ID of the processing of a specimen or part of a specimen, part of primary key| NO| -|
| ProcessingDate| datetime| Point in time of the start of the processing| YES| -|
| ProcessingID| int| ID of the processing method. Refers to ProcessingID in table Processing (foreign key)Default value: (1)| NO| Refers to table Processing|
| Protocoll| nvarchar (100)| The label of the processing protocol| YES| -|
| SpecimenPartID| int| Optional: If the data set is related to a part of a specimen, the ID of a related part (= foreign key, see table CollectionSpecimenPart)| YES| Refers to table CollectionSpecimenPart|
| ProcessingDuration| varchar (50)| The duration of the processing including the unit (e.g. 5 min) or the end of the processing starting at the processing date (e.g. 23.05.2008)| YES| -|
| ResponsibleName| nvarchar (255)| Name of the person or institution responsible for the determination| YES| -|
| ResponsibleAgentURI| varchar (255)| URI of the person or institution responsible for the determination (= foreign key) as stored in the module DiversityAgents.| YES| -|
| Notes| nvarchar (MAX)| Notes on the processing| YES| -|
| LogCreatedWhen| datetime| Point in time when this data set was createdDefault value: getdate()| YES| -|
| LogCreatedBy| nvarchar (50)| Name of the creator of this data setDefault value: suser_sname()| YES| -|
| LogUpdatedWhen| datetime| Point in time when this data set was updated lastDefault value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of the person to update this data set lastDefault value: suser_sname()| YES| -|
| RowGUID| uniqueidentifier| -Default value: newsequentialid()| NO| -|









please create a sssom mapping to darwincore (https://dwc.tdwg.org) including a metadata block with a curie_map based on https://www.diversityworkbench.de/manual/dwb_latest/modules/diversitycollection/internals_dc/database_dc/database_structure_dc/database_tables_dc/index.html#table-CollectionSpecimenReference. Use the license https://creativecommons.org/licenses/by/4.0/. Include the metadata in the mapping file. Use tsv format to include in a *.tsv file for the database table as defined below: 
### Table **CollectionSpecimenReference**
A reference related to the collection specimen
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __CollectionSpecimenID__| int| Refers to unique ID of collection specimen record (part of primary key)| NO| Refers to table CollectionSpecimen and table IdentificationUnit|
| __ReferenceID__| int| Unique reference ID for the reference record (part of primary key)| NO| -|
| ReferenceTitle| nvarchar (400)| The title of the publication related to the specimen or parts of it. Note that this is only a cached value where ReferenceURI is present| NO| -|
| ReferenceURI| varchar (500)| URI of the reference, e.g. a connection to the module DiversityReferences| YES| -|
| IdentificationUnitID| int| If relation refers to a certain organism within a specimen, the ID of an IdentificationUnit (= foreign key)| YES| Refers to table IdentificationUnit|
| IdentificationSequence| smallint| Referes to table Identification: The sequence of the identifications.| YES| -|
| SpecimenPartID| int| If the relation refers to a part of a specimen, the ID of a related part (= foreign key)| YES| Refers to table CollectionSpecimenPart|
| ReferenceDetails| nvarchar (500)| The exact location within the reference, e.g. pages, plates| YES| -|
| Notes| nvarchar (MAX)| Notes about the reference| YES| -|
| ResponsibleName| nvarchar (255)| The name of the agent (person or organization) responsible for this entry.| YES| -|
| ResponsibleAgentURI| varchar (255)| URI of the person or organisation responsible for the data (see e.g. module DiversityAgents)| YES| -|
| LogCreatedWhen| datetime| Point in time when this data set was createdDefault value: getdate()| YES| -|
| LogCreatedBy| nvarchar (50)| Name of the creator of this data setDefault value: suser_sname()| YES| -|
| LogUpdatedWhen| datetime| Point in time when this data set was updated lastDefault value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of the person to update this data set lastDefault value: suser_sname()| YES| -|
| RowGUID| uniqueidentifier| -Default value: newsequentialid()| NO| -|


please create a sssom mapping to darwincore (https://dwc.tdwg.org) including a metadata block with a curie_map based on https://www.diversityworkbench.de/manual/dwb_latest/modules/diversitycollection/internals_dc/database_dc/database_structure_dc/database_tables_dc/index.html#table-CollectionSpecimenRelation. Use the license https://creativecommons.org/licenses/by/4.0/. Include the metadata in the mapping file. Use tsv format to include in a *.tsv file for the database table as defined below: 
### Table **CollectionSpecimenRelation**
The relations of a collection specimen to other collection specimen
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __CollectionSpecimenID__| int| Unique reference ID for the collection specimen record (primary key)| NO| Refers to table CollectionSpecimen and table IdentificationUnit|
| __RelatedSpecimenURI__| varchar (255)| URI of the related specimen| NO| -|
| RelatedSpecimenDisplayText| varchar (255)| The name of a related specimen as shown e.g. in a user interface| NO| -|
| RelationType| nvarchar (50)| Type of the relation between the specimen (= foreign key, see table CollRelationType_Enum)| YES| Refers to table CollSpecimenRelationType_Enum|
| RelatedSpecimenCollectionID| int| ID of the Collection as stored in table Collection (= foreign key, see table Collection)| YES| Refers to table Collection|
| RelatedSpecimenDescription| nvarchar (MAX)| Description of the related specimen| YES| -|
| IdentificationUnitID| int| If relation refers to a certain organism within a specimen, the ID of an IdentificationUnit (= foreign key)| YES| Refers to table IdentificationUnit|
| SpecimenPartID| int| If the relation refers to a part of a specimen, the ID of a related part (= foreign key)| YES| Refers to table CollectionSpecimenPart|
| Notes| nvarchar (MAX)| Notes on the relation to the specimen| YES| -|
| IsInternalRelationCache| bit| If the relation represents a connection between specimen in this databaseDefault value: (1)| NO| -|
| LogCreatedWhen| datetime| Point in time when this data set was createdDefault value: getdate()| YES| -|
| LogCreatedBy| nvarchar (50)| Name of the creator of this data setDefault value: suser_sname()| YES| -|
| LogUpdatedWhen| datetime| Point in time when this data set was updated lastDefault value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of the person to update this data set lastDefault value: suser_sname()| YES| -|
| RowGUID| uniqueidentifier| -Default value: newsequentialid()| NO| -|




please create a sssom mapping to darwincore (https://dwc.tdwg.org) including a metadata block with a curie_map based on https://www.diversityworkbench.de/manual/dwb_latest/modules/diversitycollection/internals_dc/database_dc/database_structure_dc/database_tables_dc/index.html#table-CollectionSpecimenTransaction. Use the license https://creativecommons.org/licenses/by/4.0/. Include the metadata in the mapping file. Use tsv format to include in a *.tsv file for the database table as defined below: 
### Table **CollectionSpecimenTransaction**
The transactions in which a specimen was involved
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __CollectionSpecimenID__| int| Refers to ID of CollectionSpecimen (= foreign key and part of primary key)| NO| Refers to table CollectionSpecimenPart|
| __TransactionID__| int| Unique ID for the table Transaction (= foreign key and part of primary key)| NO| Refers to table Transaction|
| __SpecimenPartID__| int| Optional: If the data set is related to a part of a specimen, the ID of a related part (= foreign key, see table CollectionSpecimenPart)| NO| Refers to table CollectionSpecimenPart|
| AccessionNumber| nvarchar (255)| Accession number which has been assigen to the part of the specimen, e.g. in connection with a former inventory.| YES| -|
| TransactionReturnID| int| Unique ID for the table Transaction (= foreign key) for the return of a part that has been on loan| YES| -|
| TransactionTitle| nvarchar (200)| Title as in related table Transaction. Used for validation of correct entry of transaction with type regulation (see insert trigger)| YES| -|
| IsOnLoan| bit| True, if a specimen is on loan| YES| -|
| LogInsertedBy| nvarchar (50)| Name of user to first enter (typ or import) the data.Default value: suser_sname()| YES| -|
| LogInsertedWhen| smalldatetime| Point in time when the data was first entered (typed or imported) into this database.Default value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of the person to update this data set last.Default value: suser_sname()| YES| -|
| LogUpdatedWhen| smalldatetime| Point in time when this data set was updated last.Default value: getdate()| YES| -|
| RowGUID| uniqueidentifier| -Default value: newsequentialid()| NO| -|










please create a sssom mapping to darwincore (https://dwc.tdwg.org) including a metadata block with a curie_map based on https://www.diversityworkbench.de/manual/dwb_latest/modules/diversitycollection/internals_dc/database_dc/database_structure_dc/database_tables_dc/index.html#table-CollectionSpecimenTransaction. Use the license https://creativecommons.org/licenses/by/4.0/. Include the metadata in the mapping file. Use tsv format to include in a *.tsv file for the database table as defined below: 
### Table **CollectionSpecimenTransaction**
The transactions in which a specimen was involved
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __CollectionSpecimenID__| int| Refers to ID of CollectionSpecimen (= foreign key and part of primary key)| NO| Refers to table CollectionSpecimenPart|
| __TransactionID__| int| Unique ID for the table Transaction (= foreign key and part of primary key)| NO| Refers to table Transaction|
| __SpecimenPartID__| int| Optional: If the data set is related to a part of a specimen, the ID of a related part (= foreign key, see table CollectionSpecimenPart)| NO| Refers to table CollectionSpecimenPart|
| AccessionNumber| nvarchar (255)| Accession number which has been assigen to the part of the specimen, e.g. in connection with a former inventory.| YES| -|
| TransactionReturnID| int| Unique ID for the table Transaction (= foreign key) for the return of a part that has been on loan| YES| -|
| TransactionTitle| nvarchar (200)| Title as in related table Transaction. Used for validation of correct entry of transaction with type regulation (see insert trigger)| YES| -|
| IsOnLoan| bit| True, if a specimen is on loan| YES| -|
| LogInsertedBy| nvarchar (50)| Name of user to first enter (typ or import) the data.Default value: suser_sname()| YES| -|
| LogInsertedWhen| smalldatetime| Point in time when the data was first entered (typed or imported) into this database.Default value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of the person to update this data set last.Default value: suser_sname()| YES| -|
| LogUpdatedWhen| smalldatetime| Point in time when this data set was updated last.Default value: getdate()| YES| -|
| RowGUID| uniqueidentifier| -Default value: newsequentialid()| NO| -|



please create a sssom mapping to darwincore (https://dwc.tdwg.org) including a metadata block with a curie_map based on https://www.diversityworkbench.de/manual/dwb_latest/modules/diversitycollection/internals_dc/database_dc/database_structure_dc/database_tables_dc/index.html#table-ExternalIdentifier. Use the license https://creativecommons.org/licenses/by/4.0/. Include the metadata in the mapping file. Use tsv format to include in a *.tsv file for the database table as defined below: 
### Table **ExternalIdentifier**
An external identier related to a dataset, e.g. a DOI
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __ID__| int| ID of the identifier (Primary key)| NO| -|
| ReferencedTable| nvarchar (128)| The name of the table the external identifier refers to| NO| -|
| ReferencedID| int| The ID of the data set in the table the external identifier refers to| NO| -|
| Type| nvarchar (50)| The type of the identifier as defined in table ExternalIdentifierType| YES| Refers to table ExternalIdentifierType|
| Identifier| nvarchar (500)| The identifier| YES| -|
| URL| varchar (500)| A URL with further informations about the identifier| YES| -|
| Notes| nvarchar (MAX)| Notes about the identifier| YES| -|
| LogCreatedWhen| datetime| Point in time when this data set was createdDefault value: getdate()| YES| -|
| LogCreatedBy| nvarchar (50)| Name of the creator of this data setDefault value: suser_sname()| YES| -|
| LogUpdatedWhen| datetime| Point in time when this data set was updated lastDefault value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of the person to update this data set lastDefault value: suser_sname()| YES| -|
| RowGUID| uniqueidentifier| -Default value: newsequentialid()| NO| -|






please create a sssom mapping to darwincore (https://dwc.tdwg.org) including a metadata block with a curie_map based on https://www.diversityworkbench.de/manual/dwb_latest/modules/diversitycollection/internals_dc/database_dc/database_structure_dc/database_tables_dc/index.html#table-Identification. Use the license https://creativecommons.org/licenses/by/4.0/. Include the metadata in the mapping file. Use tsv format to include in a *.tsv file for the database table as defined below: 
### Table **Identification**
The identifications of the organisms within a specimen
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __CollectionSpecimenID__| int| Refers to the ID of CollectionSpecimen (= foreign key and part of primary key)| NO| Refers to table Identification and table IdentificationUnit|
| __IdentificationUnitID__| int| Refers to the ID of IdentficationUnit (= foreign key and part of primary key)| NO| Refers to table Identification and table IdentificationUnit|
| __IdentificationSequence__| smallint| The sequence of the identifications. The last identification (having the highest sequence) is regarded as validDefault value: (1)| NO| -|
| DependsOnIdentificationSequence| smallint| if the identification depends on another identification, e.g. for rocks where several terms from a terminology should be included| YES| Refers to table Identification|
| IdentificationDate| datetime| The date of the identification calculated from the entries in IdentificationDay, -Month and -Year| YES| -|
| IdentificationDay| tinyint| The day of the identification| YES| -|
| IdentificationMonth| tinyint| The month of the identification| YES| -|
| IdentificationYear| smallint| The year of the identification. The year may be empty if only the day or month are known.| YES| -|
| IdentificationDateSupplement| nvarchar (255)| Verbal or additional identification date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'| YES| -|
| IdentificationDateCategory| nvarchar (50)| Category of the date of the identification e.g. "system", "estimated"  (= foreign key, see  in table CollDateCategory_Enum)| YES| Refers to table CollIdentificationDateCategory_Enum|
| VernacularTerm| nvarchar (255)| Name or term other than a taxonomic (= scientific) name, e.g. 'pine', 'limestone', 'conifer', 'hardwood'| YES| -|
| TermURI| varchar (500)| The URI of the term, e.g. as provided by the module DiversityScientificTerms.| YES| -|
| TaxonomicName| nvarchar (255)| Valid name of the species (including the taxonomic author where available). Example: 'Rosa canina L.'| YES| -|
| NameURI| varchar (255)| The URI of the taxonomic name, e.g. as provided by the module DiversityTaxonNames.| YES| -|
| IdentificationCategory| nvarchar (50)| Category of the identification e.g. 'determination', 'confirmation', 'absence'  (= foreign key, see table CollIdentificationCategory_Enum)| YES| Refers to table CollIdentificationCategory_Enum|
| IdentificationQualifier| nvarchar (50)| Qualification of the identification e.g. "cf."," aff.", "sp. nov."  (= foreign key, see table CollIdentificationQualifier_Enum)| YES| Refers to table CollIdentificationQualifier_Enum|
| TypeStatus| nvarchar (50)| If identification unit is type of a taxonomic name: holotype, syntype, etc. (= foreign key, see table CollTypeStatus_Enum)| YES| Refers to table CollTypeStatus_Enum|
| TypeNotes| nvarchar (MAX)| Notes on the typification of this specimen| YES| -|
| Notes| nvarchar (MAX)| User defined notes, e.g. the reason for a re-determination / change of the name, etc.| YES| -|
| ResponsibleName| nvarchar (255)| Name of the person or institution responsible for the determination| YES| -|
| ResponsibleAgentURI| varchar (255)| URI of the person or institution responsible for the determination (= foreign key) as stored in the module DiversityAgents.| YES| -|
| LogCreatedWhen| datetime| Point in time when this data set was createdDefault value: getdate()| YES| -|
| LogCreatedBy| nvarchar (50)| Name of the creator of this data setDefault value: suser_sname()| YES| -|
| LogUpdatedWhen| datetime| Point in time when this data set was updated lastDefault value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of the person to update this data set lastDefault value: suser_sname()| YES| -|
| RowGUID| uniqueidentifier| -Default value: newsequentialid()| NO| -|














please create a sssom mapping to darwincore (https://dwc.tdwg.org) including a metadata block with a curie_map based on https://www.diversityworkbench.de/manual/dwb_latest/modules/diversitycollection/internals_dc/database_dc/database_structure_dc/database_tables_dc/index.html#table-IdentificationUnit. Use the license https://creativecommons.org/licenses/by/4.0/. Include the metadata in the mapping file. Use tsv format to include in a *.tsv file for the database table as defined below: 
### Table **IdentificationUnit**
Organism which is present in or on a collectied specimen
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __CollectionSpecimenID__| int| Refers to the ID of CollectionSpecimen (= foreign key and part of primary key)| NO| Refers to table CollectionSpecimen and table IdentificationUnit|
| __IdentificationUnitID__| int| ID of the IdentificationUnit (= part of primary key). Usually one of possibly several organisms present on the collected specimen. Example: parasite with hyperparasite on plant leaf = 3 units,| NO| -|
| LastIdentificationCache| nvarchar (255)| The last identification as entered in table Identification| NO| -|
| 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.| YES| -|
| 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.| YES| -|
| HierarchyCache| nvarchar (500)| A cached value fo the superior taxonomy of the last identification as derived from a taxonomic data provider| YES| -|
| TaxonomicGroup| nvarchar (50)| Taxonomic group the organism, identified by this unit, belongs to. Groups listed in table CollTaxonomicGroup_Enum (= foreign key)| NO| Refers to table CollTaxonomicGroup_Enum|
| 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.Default value: (0)| YES| -|
| RelatedUnitID| int| The IdentificationUnitID of the organism or substrate on which this organism is growing (= foreign key)| YES| Refers to table IdentificationUnit|
| RelationType| nvarchar (50)| The relation of a unit to its substrate, e.g. parasitism, symbiosis etc. as stored in CollRelationType_Enum (= foreign key)| YES| Refers to table CollUnitRelationType_Enum|
| ParentUnitID| int| The IdentificationUnitID of a parent organism of which this organism is a child of (= foreign key).| YES| Refers to table IdentificationUnit|
| ColonisedSubstratePart| nvarchar (255)| If a substrate association exists: part of the substrate which is affected in the interaction (e.g. 'leaves', if a fungus is growing on the leaves of an infected plant)| YES| -|
| LifeStage| nvarchar (255)| Examples: 'II, III' for spore generations of rusts or 'seed', 'seedling' etc. for higher plants| YES| -|
| Gender| nvarchar (50)| The sex of the organism, e.g. 'female'| YES| -|
| NumberOfUnits| smallint| The number of units of this organism, e.g. 400 beetles in a bottle| YES| -|
| NumberOfUnitsModifier| nvarchar (100)| A modifier for the number of units of this organism, e.g. ca. 400 beetles in a bottle| YES| -|
| ExsiccataNumber| nvarchar (50)| If specimen is an exsiccata: Number of current specimen within the exsiccata series| YES| -|
| ExsiccataIdentification| smallint| Refers to the IdentificationSequence in Identification (= foreign key). The name under which the collectied specimen or this organism is published within an exsiccata.| YES| -|
| UnitIdentifier| nvarchar (50)| An identifier for the identification of the unit, e.g. a number painted on a tree within an experimental plot| YES| -|
| UnitDescription| nvarchar (50)| Description of the unit, especially 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| YES| -|
| Circumstances| nvarchar (50)| Circumstances of the occurence of the organism| YES| Refers to table CollCircumstances_Enum|
| RetrievalType| nvarchar (50)| The way the data about the unit were retrieved, e.g. observation, literature| YES| Refers to table CollRetrievalType_Enum|
| 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.Default value: (1)| NO| -|
| DataWithholdingReason| nvarchar (255)| If the data set is withhold, the reason for withholding the data, otherwise null| YES| -|
| Notes| nvarchar (MAX)| Further information on the organism or interaction, e.g. infection symptoms like 'producing galls'| YES| -|
| LogCreatedWhen| datetime| Point in time when this data set was createdDefault value: getdate()| YES| -|
| LogCreatedBy| nvarchar (50)| Name of the creator of this data setDefault value: suser_sname()| YES| -|
| LogUpdatedWhen| datetime| Point in time when this data set was updated lastDefault value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of the person to update this data set lastDefault value: suser_sname()| YES| -|
| RowGUID| uniqueidentifier| -Default value: newsequentialid()| NO| -|















please create a sssom mapping to darwincore (https://dwc.tdwg.org) including a metadata block with a curie_map based on https://www.diversityworkbench.de/manual/dwb_latest/modules/diversitycollection/internals_dc/database_dc/database_structure_dc/database_tables_dc/index.html#table-IdentificationUnitAnalysis. Use the license https://creativecommons.org/licenses/by/4.0/. Include the metadata in the mapping file. Use tsv format to include in a *.tsv file for the database table as defined below: 
### Table **IdentificationUnitAnalysis**
The analysis values taken from an organism resp. object
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __CollectionSpecimenID__| int| Refers to the ID of CollectionSpecimen (= foreign key and part of primary key)| NO| Refers to table IdentificationUnit and table IdentificationUnitInPart|
| __IdentificationUnitID__| int| Refers to the ID of IdentficationUnit (= foreign key and part of primary key)| NO| Refers to table IdentificationUnit and table IdentificationUnitInPart|
| __AnalysisID__| int| Analysis ID, foreign key of table Analysis.| NO| Refers to table Analysis|
| __AnalysisNumber__| nvarchar (50)| Number of the analysis| NO| -|
| AnalysisResult| nvarchar (MAX)| The result of the analysis| YES| -|
| ExternalAnalysisURI| varchar (255)| An URI for an analysis as defined in an external datasoure| YES| -|
| ResponsibleName| nvarchar (255)| Name of the person or institution responsible for the determination| YES| -|
| ResponsibleAgentURI| varchar (255)| URI of the person or institution responsible for the determination (= foreign key) as stored in the module DiversityAgents.| YES| -|
| AnalysisDate| nvarchar (50)| The date of the analysis| YES| -|
| 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).| YES| Refers to table IdentificationUnitInPart|
| Notes| nvarchar (MAX)| Notes on this analysis| YES| -|
| LogCreatedWhen| datetime| Point in time when this data set was createdDefault value: getdate()| YES| -|
| LogCreatedBy| nvarchar (50)| Name of the creator of this data setDefault value: suser_sname()| YES| -|
| LogUpdatedWhen| datetime| Point in time when this data set was updated lastDefault value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of the person to update this data set lastDefault value: suser_sname()| YES| -|
| RowGUID| uniqueidentifier| -Default value: newsequentialid()| NO| -|
| ToolUsage| xml (MAX)| The tools used for the analysis and their usage or settings.| YES| -|



please create a sssom mapping to darwincore (https://dwc.tdwg.org) including a metadata block with a curie_map based on https://www.diversityworkbench.de/manual/dwb_latest/modules/diversitycollection/internals_dc/database_dc/database_structure_dc/database_tables_dc/index.html#table-Transaction. Use the license https://creativecommons.org/licenses/by/4.0/. Include the metadata in the mapping file. Use tsv format to include in a *.tsv file for the database table as defined below: 
### 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
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __TransactionID__| int| Unique ID for the transaction (= primary key)| NO| -|
| ParentTransactionID| int| The ID of a preceeding transaction of a superior transaction, if transactions are organized in a hierarchy| YES| Refers to table Transaction|
| TransactionType| nvarchar (50)| Type of the transaction, e.g. gift in or out, exchange in or out, purchase in or outDefault value: N'exchange'| NO| Refers to table CollTransactionType_Enum|
| TransactionTitle| nvarchar (200)| The title of the transaction as e.g. shown in an user interface| NO| -|
| ReportingCategory| nvarchar (50)| A group defined for the transaction, e.g. a taxonomic group as used for exchange balancing| YES| -|
| AdministratingCollectionID| int| ID of the collection which is responsible for the administration of the transaction.| NO| Refers to table Collection|
| MaterialDescription| nvarchar (MAX)| Description of the material of this transactionDefault value: ''| YES| -|
| MaterialCategory| nvarchar (50)| Material category of specimen. Examples: 'herbarium sheets', 'drawings', 'microscopic slides' etc.Default value: N'specimen'| YES| -|
| MaterialCollectors| nvarchar (MAX)| The collectors of the material| YES| -|
| MaterialSource| nvarchar (500)| The source of the material within a transaction, e.g. a excavation| YES| -|
| FromCollectionID| int| The ID of the collection from which the specimen were transfered, e.g. the donating collection of a gift| YES| Refers to table Collection|
| FromTransactionPartnerName| nvarchar (255)| Name of the person or institution from which the specimen were transfered, e.g. the donator of a gift| YES| -|
| FromTransactionPartnerAgentURI| varchar (255)| The URI of the transaction partner (see e.g. module DiversityAgents)| YES| -|
| 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| YES| -|
| ToCollectionID| int| The ID of the collection to which the specimen were transfered, e.g. the receiver of a gift| YES| Refers to table Collection|
| ToTransactionPartnerName| nvarchar (255)| Name of the person or institution to which the specimen were transfered, e.g. the receiver of a gift| YES| -|
| ToTransactionPartnerAgentURI| varchar (255)| The URI of the transaction partner (see e.g. module DiversityAgents)| YES| -|
| 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| YES| -|
| NumberOfUnits| int| The number of units which were (initially) included in the transaction| YES| -|
| Investigator| nvarchar (200)| The investigator for whose study a transacted material was sent| YES| -|
| TransactionComment| nvarchar (MAX)| Comments on the exchanged material addressed to the transaction partner| YES| -|
| BeginDate| datetime| Date when the transaction started| YES| -|
| AgreedEndDate| datetime| End of the transaction period, e.g. if the time for borrowing the specimen is restricted| YES| -|
| ActualEndDate| datetime| Actual end of the transaction after a prolonation when e.g. the date of return for a loan was prolonged by the owner| YES| -|
| DateSupplement| nvarchar (100)| Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'.| YES| -|
| InternalNotes| nvarchar (MAX)| Internal notes on this transaction not to be published e.g. on a web page| YES| -|
| ToRecipient| nvarchar (255)| The recipient receiving the transaction e.g. if not derived from the link to DiversityAgents| YES| -|
| ResponsibleName| nvarchar (255)| The person responsible for this transaction| YES| -|
| ResponsibleAgentURI| varchar (255)| The URI of the person, team or organisation responsible for the data (see e.g. module DiversityAgents)| YES| -|
| LogCreatedWhen| datetime| Point in time when this data set was createdDefault value: getdate()| YES| -|
| LogCreatedBy| nvarchar (50)| Name of the creator of this data setDefault value: user_name()| YES| -|
| LogUpdatedWhen| datetime| Point in time when this data set was updated lastDefault value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of the person to update this data set lastDefault value: user_name()| YES| -|
| RowGUID| uniqueidentifier| -Default value: newsequentialid()| NO| -|