Categories Products Link

From DevWiki

Jump to: navigation, search

Categories Products Link Intro

This Table joins Products to Categories.

Only the CategoryID and ProductID are required.

Categories Products Link XSD

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="xmldata" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">
<xs:element name="xmldata" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
 <xs:complexType>
    <xs:choice minOccurs="0" maxOccurs="unbounded">
      <xs:element name="Categories_Products_Link">
        <xs:complexType>
          <xs:sequence>
              <xs:element msprop:TableNameXsd="Categories_Products_Link" name="ID" msprop:SqlDbType="Int" msprop:IsIdentity="true"
minOccurs="0" />
             <xs:element name="Auto_Maintenance_Column" msprop:maxLength="1" msprop:SqlDbType="Char" minOccurs="0" />
             <xs:element name="CategoryID" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="ProductID" msprop:SqlDbType="Int" minOccurs="0" />
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:choice>
    </xs:complexType>
 </xs:element>
</xs:schema>

Sample XML

Navigation