Update Table: PracticeArea

[ExperimentsInHonesty]

Overview

We need to update the Practice Area table model to include new fields.

Details

• The initial model issue: Create Table: practice_area #63

Action Items

Update existing Django model

• In the files indicated by Resource 1.01, Add the following items in the code

Name	Type	FK Table	FK Table Issue(s)
projectprogramareastatustype	int	projectprogramareastatustype	#46
leadership_type	int	leadershiptype	#42
icon	URLField

• update table name to PracticeArea
• 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
• generate a schema table description (see resources 1.04), post it in a comment below, and add a link to it in the Update Schema dependency issue
• Document the endpoint in ReDocs (see resources 1.05)

FK status

• Create Table: project_status (used to say project_program_area_status) #46
• Create Table: leadership_type 😄  #42

Resources

• 1.01 Code locations
  • 1.01.01 /app/core/models.py
  • 1.01.02 /app/core/admin.py
  • 1.01.03 /app/core/api/serializers.py
  • 1.01.04 /app/core/api/views.py
• 1.02 People Depot Resources wiki page for links
  • ERD
  • Table and Field Definitions
  • API Endpoint
• 1.03 Spreadsheet: PD: Table and field explanations, Current Field Permission tab
  -1.03.01 Practice Area filter
• 1.04 Instructions for how to generate a schema table description
• 1.05 Instructions for how to Document End point step 3