Add is_deleted to moped_department table (default = false)
Soft delete existing Austin Transportation and Public Works rows in this table
Create a new row called Austin Transportation and Public Works
abbreviation = TPW
organization_id = 1
Update existing moped_workgroup records that have department_id set to either the ids for ATD or Public Works to be the id for the new Austin Transportation and Public Works department id
Update existing moped_entity records that have department_id set to either the ids for ATD or Public Works to be the id for the new Austin Transportation and Public Works department id
Filter soft-deleted departments in the app if needed
To reflect the reorganization in the department table, we need to update the lookups to show that ATD and Public Works merged to create TPW. Here is the SchemaSpy page to see the table relationships - https://db-docs.austinmobility.io/atd-moped-production/tables/moped_department.html.
In Scope
Add
is_deletedtomoped_departmenttable (default = false)Soft delete existing Austin Transportation and Public Works rows in this table
Create a new row called Austin Transportation and Public Works
Update existing
moped_workgrouprecords that havedepartment_idset to either the ids for ATD or Public Works to be the id for the new Austin Transportation and Public Works department idUpdate existing
moped_entityrecords that havedepartment_idset to either the ids for ATD or Public Works to be the id for the new Austin Transportation and Public Works department idFilter soft-deleted departments in the app if needed