frankyberry
Programmer
I was curious if there is a proper naming convention used when creating database tables?
Thanks.
Thanks.
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
This is very true, but can get tricky. What I ususally do would be a "Customers" table which holds all the generic customer information (account number, etc). For the customers addresses I'd use a table called "Customer_Addresses". I use the name that I did, because each customer can have more than one address, so to spell that out in the name I use the singular of the Customer and the plural of Address.r937 said:6. use plural table names -- this is to remind you that you are dealing with sets of rows, not a singular object
This is one side of a contentious issue: many people subscribe to the idea that the table name should be the description of a row in that table. Hence, you would have a "Customer" table. One counter-argument to the "plural name" implies "set" notion is that it obscures the fact that a set can be empty or have a singular member.r937 said:6. use plural table names -- this is to remind you that you are dealing with sets of rows, not a singular object