Re design table schema and foreign keys between Softwares and SoftwareExternalDatas

[guillermau]

There is no structured link between Softwares and SoftwareExternalDatas.

Proposal :

• Add foreign keys softwareId key from Softwares on SoftwareExternalDatas.
• Add field externalDataOriginType to save which connecter to use for example GitLab
• Migrate externalDataOrigin from string to URL of the endpoint to retrieve data

Old proposal

ExternalData table

• On rajoute le champ softwareId clefs étrangère vers l'index de la tablesoftwares
• On migre externalId en sourceSoftwareId
• On migre externalDataOrigin en sourceId clef étrangère vers l'index de la table source

Table source

• Création d'une table source avec id:number, nom:string, type:<TpeSource>, url:string et primacy:boolean
• Les sources types seront : HAL, SWH, Wikidata, GitHub, ComptoirDuLibre, GitLab ou encore Zenodo.

[guillermau]

Proposal

{
  "softwareId": 12,
  "externalId": "starpu/starpu",
  "externalDataOriginType": "GitLab",
  "externalDataOrigin": "https://gitlab.inria.fr/"
}

For a same software :

{
  "softwareId": 11,
  "externalId": "Q91312803",
  "externalDataOriginType": "WikiData",
  "externalDataOrigin": "https://www.wikidata.org"
}

{
  "softwareId": 11,
  "externalId": "380",
  "externalDataOriginType": "ComptoirDuLibre",
  "externalDataOrigin": "https://comptoir-du-libre.org/"
}