NYCPHP Meetup

NYPHP.org

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

Matt Juszczak matt at atopia.net
Sat Sep 12 22:27:39 EDT 2009


> account_services
> 	account_service_id
> 	account_id
> 	service_id
> 	start_date
> 	end_date
> 	...
>
> So you have a one to many customers to accounts relation. You have a one to 
> many accounts to account_services and a one to many services to 
> account_services.

Right, although there, I'd probably do it a different way, where services 
would be the listing of service  and service_definition would be the 
definitions of services.  That way, each record in "service" would have 
definition_id which would map to service_definition.id.



More information about the talk mailing list