Hi John: > I am a bit stuck with legacy naming that is all over the place.
Fun fun fun! > Is there a defacto standard for schema naming? There are loads of naming standards. I think very highly of Peter Gulutzan. The live version of the web page has been yanked, but Archive.org to the rescue... http://web.archive.org/web/20070409075643rn_1/www.dbazine.com/db2/db2-disarticles/gulutzan5 I used to be in the plural camp. But I've become fond of the singular camp. That way the table can more easily match the names of the columns. This makes things easier when it comes to making automatic tools for sanitizing input and reverse engineering databases. Particularly when it comes to things like this: people person_id loans loan_id ...VS... person person_id loan loan_id > I never know what to name timestamp/date fields. What's your issue? Not calling things "date"? I tend to call things "birth_date", "creation_date" etc. > How would you name the following tables? > Users > Permissions > User_Permissions - a many to many connector table system_user system_permission system_permission_user But all this kind of stuff is up to personal taste. When it comes down to taste, I often say, "Some people have it. Some people don't." :) All that aside, you didn't answer the burning question: did my query suggestion work?! :) --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data intensive web and database programming http://www.AnalysisAndSolutions.com/ 4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409 _______________________________________________ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
