update github_primary_repo_id field: no longer the repo id itself, will now be a foreign key to a row in project_url that corresponds to the primary repo
update github_org_id: no longer the org id itself, will now be a foreign key to a row in project_url that corresponds to the org repo link
update google_drive_id: no longer the google drive id itself, will now be a foreign key to a row in project_url that corresponds to the google drive
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 existResources/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 drive