Add is_deleted to moped_entity table (default = false)
Soft delete existing Sidewalks and Urban Trails rows in this table
[ ] TODO: Capture other entity changes @mddilley
Make rename-only updates (For example, COA ATD Active Transportation & Street Design -> COA TPW Active Transportation & Street Design)
Create a new row called Sidewalks and Urban Trails
abbreviation = SUTD
department_id = 11
Update existing moped_project records that have project_sponsor or project_lead set to either the ids for Sidewalks or Urban Trails to be the id for the new Sidewalks and Urban Trails entity id
Update existing moped_project_partners table with new entity values too based on existing values
[ ] TODO: Capture other entity record changes @mddilley
To reflect the reorganization in the workgroup 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_entity.html.
In Scope
is_deletedtomoped_entitytable (default = false)COA ATD Active Transportation & Street Design->COA TPW Active Transportation & Street Design)moped_projectrecords that haveproject_sponsororproject_leadset to either the ids for Sidewalks or Urban Trails to be the id for the new Sidewalks and Urban Trails entity idmoped_project_partnerstable with new entity values too based on existing values