[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