Method 2: prefixing the tablename to "ID" when using arbitrary unique identifiers is best practice. The reason is that when the Primary Key is migrated as a foreign key, it...
I've gone back back and forth on the singular v. plural table names argument. In the early days when I was a systems analyst, I was taught that table names...
While I agree with the essence of the previous posts, saying something is "nonsense" without constructively suggesting alternatives or even saying why is not helpful.