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
-Ursprüngliche Nachricht-
Von: brycenesbitt [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 14. August 2007 09:39
An: torque-user@db.apache.org
Betreff: Re: AW: foreign-key generation maps NumberKey to
int, and code fails to compile
Hmm, ok. But if I flip it around like that, I don't get a
BaseCcsMemberPeer.doSelectJoinCcsCoupon().
table name=CCS_MEMBER
column default=0 name=MEMBER_ID primaryKey=true
required=true type=INTEGER/
column default= name=FIRST_NAME size=127
type=VARCHAR/
column default= name=LAST_NAME size=127
type=VARCHAR/
/table
table name=CCS_COUPON
column name=COUPON_ID type=INTEGER
primaryKey=true
required=true autoIncrement=true /
column name=MEMBER_ID type=INTEGER
required=true /
column name=EXPIRES type=DATE/
foreign-key foreignTable=CCS_MEMBER
onUpdate=none onDelete=none name=FK_COUPON
reference local=MEMBER_ID foreign=MEMBER_ID/
/foreign-key
/table
How can I get a BaseCcsMemberPeer.doSelectJoinCcsCoupon(),
which will do
essentially:
SELECT * from CCS_MEMBER JOIN CCS_COUPON USING (MEMBER_ID);
All I get is BaseCcsCouponPeer.doSelectJoinCcsMember()
method, which selects a collection of CcsCoupon objects
pre-filled with their CcsMember objects. But this is
useless, since there can be only one member per coupon! I
want a member object, with a list of (zero or more) coupons.
Thoralf Rickert wrote:
I'm not sure if I understand you problem. But does it make sense to
declare a foreign key for primary key in the same table?
Normally you
declare the foreign key in COUPON and make a reference to MEMBER.
Maybe Torque doesn't like this double key-definition in MEMBER.
But I'm not sure
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#a12140061
Sent from the Apache DB - Torque Users mailing list archive at Nabble.com.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]