You may create the another column possibly with Long data type which is the primary key for the table and use the existing bookDetailId of data type varchar with Unique Key Constraints which stores the id according to your Char and Integer Concatenation Logic...
I don't get it. A whale wearing overalls? How does that even work? It's like a tiny ad wearing overalls.
a bit of art, as a gift, the permaculture playing cards