Comment by tyre

So you have a second, opaque unique identifier for the frontend to fetch? At that point why not just use a single column (UUID)?