NYCPHP Meetup

[Daniel Convissor]

On Mon, Apr 27, 2009 at 08:00:03PM -0400, Dan Cech wrote:
> 
> Plural-names for tables are a pain...
> 
> field: person
> table: ???
> 
> Is it persons or people or something else?

Yep.  Plus it makes consistency very easy and makes life easier by 
allowing the use of USING.

person
------
person_id
first_name
last_name
company_id
...

company
-------
company_id
company_name
...


etc

--Another 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