[Dbix-class] more complex relationships

[Brandon Black]

On 3/22/06, Mark Hedges <hedges at ucsd.edu> wrote:
> Here's an example that can't
> be done:
>
>   product         pk product_code
>
>   vendor          pk vendor_name
>
>   vendor_product  pk vendor_name, product_id
>                   fk product_code
>
>   sale            pk sale_id
>                   ff vendor_name
>
>   sale_item       pk sale_item_id
>                   fk sale_id
>                   ff product_id
>

Could you show that in SQL create statements?  This example seems to
me like it is something one should be able to accomplish via existing
DBIC relationships, unless there's some kind of strange normalization
problem going on here, but I just wanted to make sure we're on the
same page wrt to what the above means, exactly.

-- Brandon