Investigation to DataPublication ICAT5 Mappings

Why:

A New Data publication must be inserted for every new DOI created.

When:

Investigation.releaseDate will be used to determine when the data should be opened (a doi and dataPublication created)

What:

A lot of information needed to populate this table is derived from the associated Investigation.

The DataPublicationUser and DataPublicationDate both take a DataPublication as a mandatory field. These fields, however, are not mandatory in the DataPublication .

This means:

The DataPublication will need to be created first.
Then the DataPublicationUser and DataPublicationDate created with the ref to the DataPublication.
Then the DataPublication updated with the DataPublicationUser & DataPublicationDate

* Denotes a Relationship

DataPublication field	Populated with	Notes

DataPublication field	Populated with	Notes
*DataPublicationUser	Need to create a new one	create one for each user in InvestigationUser in the investigation. Search for the Afflication, if none then create fill in names from InvestigationUser contributorType = `Creator`
*DataCollection	Need to create a new one	This field is mandatory Copy across the dataCollectionInvestigations from investigation leave `doi`
*Facility	Investigation.facility	Copy accross from Investigation
*DataPublicationType	Need to create a new one	Name: This can be created as a one-off, in ICAT manager as `Investigation`, then added. `description = "Data Publication for a whole Visit` Once this has been created, search for it and attach to DP
*DataPublicationDate	Need to create a new one	`dateType` = recommended by Datacite to be `Created` `date` = the minted date in the appropriate ISO 8601 format.
*DataPublicationFunding	none
*RelatedIdentifier	none
publicationDate	Investigation.releaseDate
createId	auto generated
createTime	auto generated
modTime	auto generated
title	Investigation.title
description	Investigation.summary
modId	auto generated
pid	DOI	not the long URL, just the DIO, for example: `10.5286/isis.e/isis.e.89943820`
subject	none