To normalise the cuc_agent column in the cu_changes table, the column will be removed and replaced with cuc_agent_id. This will contain an ID that references the cu_useragent table. The row in that table will contain the value previously held in cuc_agent as cuua_text.

This change is also happening to the cu_log_event and cu_private_event tables but, based on T327447, it looks like the Data-Engineering team does not use these tables.

There is no particular timeline for this change, as this is not a high priority change for the Trust and Safety Product Team.

The new cu_useragent table and cuc_agent_id column will be stable to read from once T361199 is complete. In T361205, the CheckUser code will stop writing to cuc_agent and then later in T361208 the column will be removed.