Update Table: User

[ExperimentsInHonesty]

Overview

We need to update the User table model to include new fields and have the correct names for fields.

Details

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

Action Items

Update existing Django model

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

Current name in code	Updated Name	Updated Type (may already be this type)
current_job_title	job_title_current_intake	varchar
email	email_intake	EmailField
first_name	name_first	varchar
gmail	email_gmail	EmailField
is_active	user_status_id	int
last_name	name_last	varchar
preferred_email	email_preferred	EmailField
target_job_title	job_title_target_intake	varchar

• Add the following items in the code

Name	Type
practice_area_primary	int (practice_area_primary)
practice_area_secondary	int[] (practice_area_secondary)
practice_area_target_intake	int[] (practice_area_target_intake)
referred_by	int
email_cognito	EmailField

• 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 definition and post it in a comment below and add a link to it in the Update Schema dependency issue.
• Document the endpoint in ReDocs

After PR has been approved

• Release the dependency and move the issue out of the icebox for Update Schema: User model #436

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/migrations/0002_user_current_job_title_user_current_skills_and_more.py
• 1.02 People Depot Resources wiki page for links
  • ERD
  • Table and Field Definitions
  • API Endpoint
• 1.03 Spreadsheet, User view filter