OK tank you. 2007/4/23, Kevin Williams <[EMAIL PROTECTED]>:
Yes. That looks good except you will also need to define the compound primary key for the join table. On 4/20/07, Paulo Henrique Trecenti <[EMAIL PROTECTED]> wrote: > > Like that's > > <Table tableName="RESERVE" typeName="Reserve"> > <Column columnName="ID" propertyName="reserveID" primaryKey="true" > /> > <Column columnName="ROOM_ID" propertyName="roomID" /> > <Column columnName="EMAIL" propertyName="email"/> > <Column columnName="DATEHOUR" propertyName="dateHour"/> > <Column columnName="REASON" propertyName="reasom"/> > </Table> > > <Table tableName="EQUIPMENT" typeName="Equipment"> > <Column columnName="ID" propertyName="equipmentID" > primaryKey="true" > generated="true" /> > <Column columnName="NAME" propertyName="name" /> > <Column columnName="QUANTITY" propertyName="quantity"/> > <Column columnName="TYPE" propertyName="type"/> > </Table> > > <Table tableName="RESERVE_EQUIPMENTS" > > <Column columnName="RESERVE_ID" propertyName="reserveID" /> > <Column columnName="EQUIPMENT_ID" propertyName="equipmentID" /> > </Table> > > <Relationship name="reserveEquipments" primaryKeyTable="RESERVE" > foreignKeyTable="RESERVE_EQUIPMENTS" many="true"> > <KeyPair primaryKeyColumn="ID" foreignKeyColumn="RESERVE_ID" /> > </Relationship> > > <Relationship name="equipmentReserves" primaryKeyTable="EQUIPMENT" > foreignKeyTable="RESERVE_EQUIPMENTS" many="true"> > <KeyPair primaryKeyColumn="ID" foreignKeyColumn="EQUIPMENT_ID" /> > </Relationship> > > > > 2007/4/20, Kevin Williams <[EMAIL PROTECTED]>: > > > > Hello Paulo, > > > > The RDB DAS does not yet directly support many to many > relationships. YOu > > can work around this by using two 1:m relationships where both Reserve > and > > Equipment has 1:m relationship with Reserve_Equipment. So, you have to > > directly model the junction table. > > > > --Kevin > > > > > > On 4/20/07, Paulo Henrique Trecenti <[EMAIL PROTECTED]> wrote: > > > > > > Hi, > > > I'm try using the DAS Relationship but I can not undestand, in my case > I > > > try > > > make this > > > > > > _________ __________ > > > | Reserve | *_________*| Equipment | > > > |________| | |__________| > > > | > > > _______|____________ > > > | Reserve_Equipments | > > > |__________________ | > > > > > > Ok, one Reserve have many equipments, one equipment can be used by > many > > > Reservers then I have a relatonship many to many. > > > My config file is > > > > > > <Table tableName="RESERVE" typeName="Reserve"> > > > <Column columnName="ID" propertyName="reserveID" > > primaryKey="true" > > > /> > > > <Column columnName="ROOM_ID" propertyName="roomID" /> > > > <Column columnName="EMAIL" propertyName="email"/> > > > <Column columnName="DATEHOUR" propertyName="dateHour"/> > > > <Column columnName="REASON" propertyName="reasom"/> > > > </Table> > > > > > > <Table tableName="EQUIPMENT" typeName="Equipment"> > > > <Column columnName="ID" propertyName="equipmentID" > > > primaryKey="true" > > > generated="true" /> > > > <Column columnName="NAME" propertyName="name" /> > > > <Column columnName="QUANTITY" propertyName="quantity"/> > > > <Column columnName="TYPE" propertyName="type"/> > > > </Table> > > > > > > <Relationship name="reserveEquipments" primaryKeyTable="RESERVE" > > > foreignKeyTable="EQUIPMENT" many="true"> > > > <KeyPair primaryKeyColumn="ID" foreignKeyColumn="EQUIPMENT_ID" > > /> > > > </Relationship> > > > > > > This is correct ? If yes how I can insert into table > RESERVE_EQUIPMENTS > > > using DataObject with ChangeSummary ? > > > > > > -- > > > Paulo Henrique Trecenti > > > > > > > > > -- > Paulo Henrique Trecenti >
-- Paulo Henrique Trecenti