Update Table: project

[Neecolaa]

Overview

We need to update the project table model to remove the url fields (and move the types to the url_type table).

Details

The initial model issue is #16

Discussion leading to this change is here: #78

Action Items

• [x] Update schema information
  • [x] add/remove given columns from Entity Relationship Diagram (ERD)
  • [x] add/remove 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

• [x] github_primary_url - URLField
• [x] slack_url - URLField
• [x] google_drive_url - URLField
• [x] hfla_website_url - URLField
• [x] readme_url - URLField
• [x] wiki_url - URLField

Columns to Add

• None

Additional Changes

• [x] Add url types to the url_type data tab in the spreadsheet if they are not already included.
  • [x] github
  • [x] slack
  • [x] google drive
  • [x] hfla website
  • [x] readme
  • [x] wiki

    Resources

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

[Neecolaa]

ERD and Spreadsheet adjustments done, ready for Django work.