See https://github.com/ral-facilities/inventory-management-system/pull/1759#discussion_r2945570256. Effects other tables too.