Update Table: user (replace role association with practice area)

[Neecolaa]

Dependency

• Epic: Audit differences between code and documented field names #432 (comment) - this dependency should be replaced by the epic issue # when it's made

Overview

We need to update the user table model to utilize the practice area table instead of the outdated role table.

Details

• The initial model issue is Create Table: User #15

Discussion leading to this change is here: #170

Action Items

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

• desired_roles - varchar
• practice_area_current - int (practice_area_id)

Columns to Add

• practice_area_primary - FK int (practice_area_id) - see Create Table: practice_area #63
• practice_areas_secondary - FK int (practice_area_id) - see Create Table: practice_area #63

Additional Changes

• Remove relationship between user and role tables (table spreadsheet & ERD)
• Add relationship between user and practice_area (table spreadsheet & ERD)

Resources

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

[fyliu]

This looks ready to be worked on to me.