NYCPHP Meetup

NYPHP.org

[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