It makes more sense to have two columns yes, one autoincrement for the primary key, and another uuidv4. Because uuids are too large and makes indexes slower

So when public APIs use uuidv4 to fetch item, those uuidv4 still need to be indexed...