>Wouldn't you use something more specific no. I would use something as generic as possible, because then when the client asks for a new type of person in their system, I dont have to create tables+code to acheive this, I only have to add a new row. Also, to use your example, what if I have a doctor who is an administrator...
tblperson tblprofession tbladdress link_person_profession link_person_address I also think s.isaac has a very good point here: >I personally prefer singular table names because the form of plurals >is inconsistent. >contact(s)/address(es)/octop(i)-us/pe(ople)-rson/addend(a)-um ... and >because when the column names are written out it more closely >approximates natural language. I don't say "fetch me that addresses >label" (addresses.label) I say "fetch me that address label" >(address.label). I don't say "I want to know this people's name" >(people.name) I say "I want to know this person's name" (person.name). -----Original Message----- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: 30 March 2005 11:20 To: CF-Talk Subject: Re: Table name - Singular or plural? >This is the exact reason I gave it ago with singular table names. tblPeople, >with a PK of PersonID or PeopleID didn't sit too well, tblPersons didn't >seem right either. When I was reading through this thread, I started asking myself who names a table tblpeople anyway? lol! I know I have less experience than most on the list, but I've never built a tblperson or tblpeople. What does tblperson represent? tbldoctors tbllawyers tbladministrators tblemployees tblusers Where would I use tblperson and need to make it plural anyway? What does tblperson represent? Wouldn't you use something more specific? Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200660 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
