I am modifying a database with @ 50 tables, many of the tables contain a field called ProdID (product ID) a long interger field used in a many to one relationship with ProdID a key field in the product table.
Is it good practice to have a field with the same name in several tables?
Is it good practice to have a field with the same name in several tables?