To reflect the reorganization in the workgroup table, we need to update the lookups to reflect the changes like Sidewalks and Special Projects merging with Urban Trails. Here is the SchemaSpy page to see the table relationships - https://db-docs.austinmobility.io/atd-moped-production/tables/moped_workgroup.html.

In Scope

• Add is_deleted to moped_workgroup table (default = false)
• Soft delete existing Sidewalks and Urban Trails rows in this table
• Create a new row called Sidewalks and Urban Trails
  • abbreviation = SUTD
  • department_id is the id that has name Austin Transportation and Public Works in moped_department
• Update existing moped_users records that have workgroup_id set to either the ids for Sidewalks or Urban Trails to be the id for the new Sidewalks and Urban Trails workgroup id
• Filter soft-deleted workgroups in the app (Staff view and any other views)