-
Notifications
You must be signed in to change notification settings - Fork 4
Plan for dropping unpreserved nma_pk_* columns after transfers are permanently complete #636
Copy link
Copy link
Open
Labels
technical debtTechnical debt and cleanup tasksTechnical debt and cleanup tasks
Description
Once legacy transfers from NM_Aquifer are permanently complete, the following columns are only used for transfer/audit and can be dropped after the prerequisites below. No application business logic depends on them.
Columns that can be dropped (unpreserved elsewhere):
Observation.nma_pk_waterlevelsSample.nma_pk_waterlevelsThing.nma_pk_welldata(after removing from OGC views)Thing.nma_pk_wellscreensContact.nma_pk_owners(after removing from search vector)Contact.nma_pk_waterlevelsSensor.nma_pk_equipment
Prerequisites before dropping:
- PyGeoAPI: Update OGC thing views (e.g. in migration
d5e6f7a8b9c0or a new migration) to stop selectingthing.nma_pk_welldata, then drop the column. - Search: Update the contact search vector definition so it no longer includes
nma_pk_owners(seee4f7a9c0b2d3_add_search_vector_triggers.pyand Contact model), then drop the column.
Scope: Add a short doc or ADR that records this plan and the prerequisites; implement the drop only when the team has decided transfers are permanently complete.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
technical debtTechnical debt and cleanup tasksTechnical debt and cleanup tasks