db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From brycenesbitt <bry...@obviously.com>
Subject Re: AW: AW: foreign-key generation maps NumberKey to int, and code fails to compile
Date Tue, 14 Aug 2007 08:14:09 GMT

Each coupon is owned by one member.
A member may have any number of coupons.
SQL has no trouble setting up such a relationship without a third table.  Do
I need the third table to satisfy Torque?

Thoralf Rickert wrote:
> Ah, okay, a coupon has only one member. Is it possible to have a member
> that has multiple coupons? Or is it a 1:1 relation? If so, you could make
> a circle reference from member to coupon. If it is 1:n relation (I think
> so), then you should add a third table COUPON_MEMBER_RELATION with
> member_id,coupon_id as foreign keys and unique(member_id,coupon_id) and
> maybe unique(coupon_id).
> bye
> Thoralf

View this message in context: http://www.nabble.com/foreign-key-generation-maps-NumberKey-to-int%2C-and-code-fails-to-compile-tf4265600.html#a12140496
Sent from the Apache DB - Torque Users mailing list archive at Nabble.com.

To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message