Update Schema: User model

[ExperimentsInHonesty]

Dependency

• Update Table issue: Update Table: User #429

Overview

Changes need to be made to the spreadsheet and the ERD to reflect the changes made to the User model (code), so that all three can be consistent.

Action Items

• Make changes listed below in the ERD (can be done before or after code updates)
  • Fields have been added (if needed)
  • Fields have been updated (if needed)
• (after the code has been changed) Make changes to spreadsheet so that the following columns are all the same (this should make the value in "Is the code the same as the plan?" have the value of TRUE
  • Called in code
  • New Field Name
  • Field Name

Changes Needed

Fields to Update

Current name in code	Updated Name	Updated Type (may already be this type)
first_name	name_first	varchar
last_name	name_last	varchar
created_date	created_at	DateTimeField
is_active	user_status_id	int
current_job_title	intake_job_title_current	varchar
target_job_title	intake_job_title_target	varchar

Fields to Add

Name	Type
practice_area_primary	int (practice_area_primary)
practice_area_secondary	int[] (practice_area_secondary)
intake_practice_area_target	int[] (intake_practice_area_target)
referred_by	int

Additional Changes

• List any changes that are not field changes here (ex: relationship changes, table name changes, additional information added to the ERD). Remove this section if unused

Resources

• ERD: Entity Relationship Diagram
• Spreadsheet: PD: Table and field explanations, Field Permissions