Restructure the cases_officers table

User Story

As a user who wants keep my data in the system accurate and up to date I want to be able to see fields I understand in my data table So that I am clear about my data in the system

Definition of Done

The following tasks have been completed:

[x] Rename the supervisor_officer_number column in cases_officers to supervisor_employee_id and reroute code references to the field to the new name. (note: also search for supervisorOfficerNumber and replace with supervisorEmployeeId)
[x] Rename the windows_username column in cases_officers to employee_id and reroute code references to the field to the new name. (note: also search for windowsUsername and replace with employeeId)
[x] Drop the supervisor_windows_username column in the cases_officers table & replace any code references to it with supervisor_employee_id.

Acceptance Criteria

Given I am in any client environment When I attach an officer to a case Then I am able to see their information (supervisor info will not work in non prod until story [#604] is completed)

Given I am in any database environment When I view the cases_officers table Then there's no mention of supervisor_officer_number in the codebase or in the cases_officers table And there's no mention of supervisor_windows_username in the codebase or in the cases_officers table And there's no mention of windows_username in the codebase or in the cases_officers table

PublicDataWorks / complaint-manager