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: [email protected] > 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]
