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.
_______________________________________________
New York PHP User Group Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
http://www.nyphp.org/show_participation.php