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

[Neecolaa]

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 #15

Discussion leading to this change is here: https://github.com/hackforla/peopledepot/discussions/170

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 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

• [x] desired_roles - varchar
• [x] practice_area_current - int (practice_area_id)

Columns to Add

• [ ] practice_area_primary - FK int (practice_area_id)
• [ ] practice_areas_secondary - FK int (practice_area_id)

Additional Changes

• [x] Remove relationship between user and role tables (table spreadsheet & ERD)
• [x] 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.

[drakeredwind01]

@Neecolaa -[ ]Columns to Add -[ ]practice_area_primary - int (practice_area_id) # add to which model -[ ]practice_areas_secondary - int[] (practice_area_id) # add to which model nicole will decide if we are keeping this in this issue or adding it to a join table

[Neecolaa]

We're going to add a join table. Issues will be created to add the new table to the schema. This issue is fine otherwise