8000 Re design table schema and foreign keys between `Softwares` and `SoftwareExternalDatas` · Issue #298 · codegouvfr/catalogi · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content
Re design table schema and foreign keys between Softwares and SoftwareExternalDatas #298
New issue
New issue
Closed
Feature
1 of 1 issue completed
#361
Closed
Re design table schema and foreign keys between Softwares and SoftwareExternalDatas#298
Feature
1 of 1 issue completed
#361
Assignees
guillermau
Labels
enhancementNew feature or requestgenericityto discussIssue to discuss
Milestone
 
Multi Source
@guillermau

Description

@guillermau
guillermau
opened on Feb 18, 2025

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.

Sub-issues

Metadata

Metadata

Assignees

Labels

enhancementNew feature or requestgenericityto discussIssue to discuss

Type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions
    0