NYCPHP Meetup

[Russ Demarest]

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