[nycphp-talk] Database, table, and column naming schemes
Ajai Khattri
ajai at bitblit.net
Tue Oct 6 01:19:13 EDT 2009
On Tue, 6 Oct 2009, Matt Juszczak wrote:
> And how about one more thing...
>
> What would you call a table that joins two other tables on a many to many:
>
> say I have an account table, and a user table:
>
>
> account
> - ID
>
> user
> - ID
>
> Finally, I have a third table:
>
> un-named
> - account_id
> - user_id
> - column X
> - column Y
>
>
> What would you call that many:many table?
>
> Surely, not account_user, and not user_account
Why not AccountUser?
Some PHP frameworks do indeed follow that convention.
--
Aj.
More information about the talk
mailing list