Skip to content
GitLab
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Register
  • Sign in
  • S swh-provenance
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 7
    • Issues 7
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 0
    • Merge requests 0
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • Platform
  • Development
  • swh-provenance
  • Issues
  • #4707
Closed
Open
Issue created Nov 28, 2022 by Nicolas Dandrimont@olasdMaintainer

provenance: add (revision) dates to the relation tables

To be able to effectively answer the "first occurrence" query in the provenance db, we need to add an indexed column with the date of the revision in the content_in_revision (that is, turn it into (content_id, revision_date, revision_id, location_id)).

We should consider whether we need to do that for directory_in_revision as well.


Migrated from T4707 (view on Phabricator)

Assignee
Assign to
Time tracking