Update Table: project

[Neecolaa]

Dependency

• Create Table: project_url #41

Overview

We need to update the project table model to update the drive and repo id fields to be foreign keys. Project_url will store the id values.

Details

• The initial model issue is Create Table: project #16

• Discussion leading to this change is here: ER: docs: project url fields vs project_url #78

• Previous update issue: Update Table: project #197

Action Items

• Update schema information
  • add/remove/alter given columns from Entity Relationship Diagram (ERD)
  • add/remove/alter given columns from PD: Table and Field definitions
  • make additional schema changes (if needed)
  • remove the ERD/SS update & db architect labels after these changes are made.
    • Permission is needed to edit the ERD and table spreadsheet.
• Update existing Django model
• Write a test for the new relationships this model will have with other models (e.g., creating a user and assigning them a set of permissions on a project) if any.
• Update API end point
• Update API unit tests
• Document the endpoint in Swagger

Changes Needed

Columns to Remove

• None

Columns to Add

• None

Columns to Alter

• (FK) github_primary_repo_id - int - no longer the repo id itself, will now be a foreign key to a row in project_url that corresponds to the primary repo
• (FK) github_org_id - int - 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
• (FK) google_drive_id - int - 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

Additional Changes

• None

Resources

• See People Depot Resources wiki page for links
  • ERD
  • Table and Field Definitions
  • API Endpoint