I think the definition would be in the services table.
The entity is a service, hosting or something. The columns in services
should define the entity (serivce).
So the service_id in account_services ties back to what the service is.
On Sep 12, 2009, at 10:27 PM, Matt Juszczak wrote:
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
_______________________________________________
New York PHP User Group Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
http://www.nyphp.org/show_participation.php
