exclusiveRelationSet

XML format for the exclusiveRelationSet object

The exclusiveRelationSet contains children elements of type relation.

<exclusiveRelationSet
   name="route_for"
   toSideTable="r_rqst"
   tableIdColumn="source_type"
   keyColumn="source_lowid"
   >  
  
   <relation type="OneToMany">
         <fromSide name="case2r_rqst"  table="case" ></fromSide>
         <toSide   name="r_rqst2case"  table="r_rqst" ></toSide>
   </relation>

   <relation type="OneToMany">
         <fromSide name="subcase2r_rqst"  table="subcase" ></fromSide>
         <toSide   name="r_rqst2subcase"  table="r_rqst" ></toSide>
   </relation>

</exclusiveRelationSet>

Attribute Name

Required

default

Description

name

Yes

 

The name of the exclusive set. This allows for multiple exclusive relation sets on a single table.

toSideTable

Yes

 

The name of the table on which the exclusive relation set exists on, and on which the physical columns exist.

tableIdColumn

Yes

 

The name of the column on the toSideTable table that stores the table ID of the related data.

keyColumn

Yes

 

The name of the column on the toSideTable table that stores the foreign key(the objid) of the related data.

See Also

schema

table

relation

view

sqlView

Next

sqlView

exclusiveRelationSet