Update Table: project

[Neecolaa]

Dependency

• 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 #16

• Discussion leading to this change is here: #78

• Previous update issue: #197

Action Items

• [x] Update schema information
  • [x] add/remove/alter given columns from Entity Relationship Diagram (ERD)
  • [x] add/remove/alter given columns from PD: Table and Field definitions
  • [x] make additional schema changes (if needed)
  • [x] 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