Update project's external id fields to point to project_url entries #290
Labels
complexity: small
All steps are laid out in detail so that someone new to the project can work on it
Feature: ERD/SS Adjustment
Requires adjustments to be made to the ERD & Spreadsheet
p-feature: projects
project and projects
role: back end
role: db architect
s: PD team
stakeholder: People Depot Team
size: 1pt
Can be done in 4-6 hours
Milestone
Overview
We need to update project's external id fields to point to project_url entries, as decided here.
Action Items
github_primary_repo_id
,github_org_id
,google_drive_id
to be FK toproject_url
rowsURLType - Data
sheet if they don't existurl fields
vsproject_url
#78 from ice boxResources/Instructions
github_primary_repo_id
field: no longer the repo id itself, will now be a foreign key to a row inproject_url
that corresponds to the primary repogithub_org_id
: no longer the org id itself, will now be a foreign key to a row inproject_url
that corresponds to the org repo linkgoogle_drive_id
: no longer the google drive id itself, will now be a foreign key to a row inproject_url
that corresponds to the google driveThe text was updated successfully, but these errors were encountered: