NYCPHP Meetup

NYPHP.org

[nycphp-talk] Database, table, and column naming schemes

tedd tedd at sperling.com
Tue Oct 6 13:49:27 EDT 2009


At 9:38 AM -0700 10/6/09, Kristina Anderson wrote:
>  > On Tue, 6 Oct 2009, David Krings wrote:
>>
>>  > There
>>  > really is no need to store the same piece of data more than once in
>a
>>  > database.
>>
>>  But a table descrbing a manay-to-many could just contain foreign keys.
>>
>>
>>
>>  --
>>  Aj.
>>
>>
>
>Exactly, the table would contain probably nothing more than a primary
>key autonumber field, the user id and account id in each row.
>
>Creating a view is an option, but I have concerns about how it would
>scale in a situation where a lot of accounts were being created.
>
>
>
>Kristina
>
>Kristina

Oh no -- there's two of you!  :-)

Cheers,

tedd
-- 
-------
http://sperling.com  http://ancientstones.com  http://earthstones.com



More information about the talk mailing list