Share via

2.6.130 CT_ModelRelationship

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

Referenced by: CT_ModelRelationships

Specifies a single relationship in the spreadsheet data model.

Attributes:

fromTable:  An ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) attribute that specifies the name of the foreign key table for this relationship.

fromColumn:  An ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) attribute that specifies the name of the foreign key table column for this relationship.

toTable:  An ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) attribute that specifies the name of the primary key table for this relationship.

toColumn:  An ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) attribute that specifies the name of the primary key table column for this relationship.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_ModelRelationship">
   <xsd:attribute name="fromTable" type="x:ST_Xstring" use="required"/>
   <xsd:attribute name="fromColumn" type="x:ST_Xstring" use="required"/>
   <xsd:attribute name="toTable" type="x:ST_Xstring" use="required"/>
   <xsd:attribute name="toColumn" type="x:ST_Xstring" use="required"/>
 </xsd:complexType>

See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).