Hot answers tagged


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 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 ...

Only top voted, non community-wiki answers of a minimum length are eligible