How to change a unit (in DB)

Change unit in a data structure

1. Important: Do not change or delete directly in the database without a current backup!

Change UNIT

Table datasets

• Search for data structure ID: SELECT * FROM public.datasets WHERE id = '30948'

Table variables

• Filter by data structure: SELECT * FROM public.variables WHERE datastructureref = '1329'
• Change ID under unitref (You can search for the new ID on the page: Manage Units