assigning ID's
Do you have some rule of thumb when assigning ID's for the following tables in the database:
1. Products
2. orders
3. users
the shop intending to use the database can be considered medium with products upto 2000, customers upto 200000.
I am hopping the ID are future proof.