SQL style guide
"Where possible avoid simply using id as the primary identifier for the table."Has anyone had trouble by using surrogate primary keys?  I've found the opposite of what the author said could be more true: composite keys should be avoided instead.