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| -|