You should look into what kind of barcode the books are using you are going to store. Take a look here for more information about bar codes https://barcode.tec-it.com/en/EAN13?data=978020137962
You should also look into if you need to store leading zeros.
And your primary key does not have to be the value from the bar code.
The reason i can see for continue using a standard “rowid column” (integer with autoincrement) is that the name could change and in these cases i will have to update the tables which holds relations to table A
This is the best reason not to do what you intend.
The mess that you can get yourself into having to update foreign keys in other tables because the ...