Investigation to a DataPublication

A New Data publication must be inserted for every new DOI created.
A lot of information needed to populate the DataPublication table is derived from the associated Investigation.

Below is a mapping of an Investigation to a DataPublication

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

DataPublication field	Source	Notes
*DataPublicationUser	Need to create a new one	create one for each user in InvestigationUser in the investigation. Search for the Afilliation, 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