yes, if you are having to modify the table records like that then a bigint as the primary key or a uuid would be necessary.