Dear Wiki user, You have subscribed to a wiki page or wiki category on "Ws Wiki" for change notification.
The following page has been changed by lresende: http://wiki.apache.org/ws/WorkingWithCompoundKeys ------------------------------------------------------------------------------ Relationships between tables are in terms of primary keys and foreign keys and so foreign keys can also be compound. The following example illustrates a relationship using a compound foreign key: {{{ - TBD: need an example here (see JIRA 841) + <Config xsi:noNamespaceSchemaLocation="http:///org.apache.tuscany.das.rdb/config.xsd"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> + + <Table tableName="ORDERDETAILS"> + <Column columnName="ORDERID" primaryKey="true"/> + <Column columnName="PRODUCTID" primaryKey="true"/> + </Table> + + <Table tableName="ORDERDETAILSDESC"> + <Column columnName="ID" primaryKey="true"/> + </Table> + + <Relationship name="orderDetailsDesc" primaryKeyTable="ORDERDETAILS" + foriegnKeyTable="ORDERDETAILSDESC" many="true"> + <KeyPair primaryKeyColumn="ORDERID" foriegnKeyColumn="ORDERID" /> + <KeyPair primaryKeyColumn="PRODUCTID" foreignKeyColumn="PRODUCTID" /> + </Relationship> + </Config> + }}} --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
