[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