northwind.dsv

< SQL Server2005程序设计>

                  <xs:element name="Unit_x0020_Sales" msprop:FriendlyName="Unit Sales" msprop:DbColumnName="Unit Sales" msprop:design-time-name="6936ead4-778a-4146-859b-b0c25d4b4645" type="xs:int" minOccurs="0" />
                  <xs:element name="TimeKey" msprop:FriendlyName="TimeKey" msprop:DbColumnName="TimeKey" msprop:design-time-name="cdb9006a-3e78-40cc-8841-5ed3bb29e184" type="xs:int" minOccurs="0" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="dbo_vwShippers" msprop:FriendlyName="vwShippers" msprop:DbSchemaName="dbo" msprop:DbTableName="vwShippers" msprop:design-time-name="74a3d23f-2192-4623-a48b-20b820f01bca" msprop:TableType="View">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="ShipperId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:FriendlyName="ShipperId" msprop:DbColumnName="ShipperId" msprop:design-time-name="164281f8-bd68-4afc-ba8d-b32cee361128" type="xs:int" />
                  <xs:element name="ShipperName" msprop:FriendlyName="ShipperName" msprop:DbColumnName="ShipperName" msprop:design-time-name="a08ce299-93ae-4927-965e-a34b04c52822">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="40" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="dbo_vwProducts" msprop:FriendlyName="vwProducts" msprop:DbSchemaName="dbo" msprop:DbTableName="vwProducts" msprop:design-time-name="11da3704-3faf-4eb8-9fe0-369c688d85ce" msprop:TableType="View">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="ProductID" msprop:FriendlyName="ProductID" msprop:DbColumnName="ProductID" msprop:design-time-name="be380be7-ed4f-4868-8b03-e6db8b18254e" type="xs:int" />
                  <xs:element name="ProductName" msprop:FriendlyName="ProductName" msprop:DbColumnName="ProductName" msprop:design-time-name="dd72d523-9a81-4aa4-ae76-77d787420f11">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="40" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="CategoryName" msprop:FriendlyName="CategoryName" msprop:DbColumnName="CategoryName" msprop:design-time-name="c0c539ac-e62a-4939-bbb5-421baf9719eb">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="15" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="dbo_vwGeography" msprop:FriendlyName="vwGeography" msprop:DbSchemaName="dbo" msprop:DbTableName="vwGeography" msprop:design-time-name="0a43d825-5914-475c-ab4d-acc44d8a23c4" msprop:TableType="View">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="PostalCode" msprop:FriendlyName="PostalCode" msprop:DbColumnName="PostalCode" msprop:design-time-name="311c3200-c6b4-42f3-9fdc-a93dd75a7282">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="10" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="City" msprop:FriendlyName="City" msprop:DbColumnName="City" msprop:design-time-name="65c8cf15-62e7-4c8a-b82f-4a9ba1041e60" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="15" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="State" msprop:FriendlyName="State" msprop:DbColumnName="State" msprop:design-time-name="8e2154c5-cdaf-4c2c-8544-7210cd3dfe9c" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="15" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="Country" msprop:FriendlyName="Country" msprop:DbColumnName="Country" msprop:design-time-name="d4ebc1f3-dd97-4844-9d50-86824a6bab2e" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="15" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="dbo_vwEmployees" msprop:FriendlyName="vwEmployees" msprop:DbSchemaName="dbo" msprop:DbTableName="vwEmployees" msprop:design-time-name="23ea16cc-e18c-4495-9a49-b8166bb3e7a5" msprop:TableType="View">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="EmployeeID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:FriendlyName="EmployeeID" msprop:DbColumnName="EmployeeID" msprop:design-time-name="243381f0-92f3-48b6-a996-62f014c0cf06" type="xs:int" />
                  <xs:element name="EmployeeName" msdata:ReadOnly="true" msprop:FriendlyName="EmployeeName" msprop:DbColumnName="EmployeeName" msprop:design-time-name="b036a709-0ad5-43b9-84b3-df36fb4886ab">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="32" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="dbo_vwSuppliers" msprop:FriendlyName="vwSuppliers" msprop:DbSchemaName="dbo" msprop:DbTableName="vwSuppliers" msprop:design-time-name="fce6797a-bfc4-4b36-895f-138b0c1a2410" msprop:TableType="View">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="ProductID" msprop:FriendlyName="ProductID" msprop:DbColumnName="ProductID" msprop:design-time-name="35afb3e1-b66b-45d0-a03f-8c3a5bed9303" type="xs:int" />
                  <xs:element name="ProductName" msprop:FriendlyName="ProductName" msprop:DbColumnName="ProductName" msprop:design-time-name="b68111a5-0d8a-49e0-9919-5a6a269bfa69">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="40" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="SupplierName" msprop:FriendlyName="SupplierName" msprop:DbColumnName="SupplierName" msprop:design-time-name="0a44cd48-bda1-464e-a0b7-af0417c094f2">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="40" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
          </xs:choice>
        </xs:complexType>
        <xs:unique name="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">
          <xs:selector xpath=".//dbo_tblTime" />
          <xs:field xpath="TimeKey" />
        </xs:unique>
        <xs:unique name="dbo_vwShippers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//dbo_vwShippers" />
          <xs:field xpath="ShipperId" />
        </xs:unique>
        <xs:unique name="dbo_vwProducts_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//dbo_vwProducts" />
          <xs:field xpath="ProductID" />
        </xs:unique>
        <xs:unique name="dbo_vwGeography_Constraint1" msdata:ConstraintName="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">
          <xs:selector xpath=".//dbo_vwGeography" />
          <xs:field xpath="PostalCode" />
        </xs:unique>
        <xs:unique name="dbo_vwEmployees_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//dbo_vwEmployees" />
          <xs:field xpath="EmployeeID" />
        </xs:unique>
        <xs:unique name="dbo_vwSuppliers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//dbo_vwSuppliers" />
          <xs:field xpath="ProductID" />
        </xs:unique>
      </xs:element>
      <xs:annotation>
        <xs:appinfo>
          <msdata:Relationship name="tblFact-vwProducts" msdata:parent="dbo_vwProducts" msdata:child="dbo_tblFact" msdata:parentkey="ProductID" msdata:childkey="ProductID" msprop:Description="" msprop:IsLogical="True" />
          <msdata:Relationship name="tblFact-vwGeography" msdata:parent="dbo_vwGeography" msdata:child="dbo_tblFact" msdata:parentkey="PostalCode" msdata:childkey="PostalCode" msprop:Description="" msprop:IsLogical="True" />
          <msdata:Relationship name="tblFact-vwSuppliers" msdata:parent="dbo_vwSuppliers" msdata:child="dbo_tblFact" msdata:parentkey="ProductID" msdata:childkey="ProductID" msprop:Description="" msprop:IsLogical="True" />
          <msdata:Relationship name="tblFact-tblTime" msdata:parent="dbo_tblTime" msdata:child="dbo_tblFact" msdata:parentkey="TimeKey" msdata:childkey="TimeKey" msprop:Description="" msprop:IsLogical="True" />
          <msdata:Relationship name="tblFact-vwShippers" msdata:parent="dbo_vwShippers" msdata:child="dbo_tblFact" msdata:parentkey="ShipperId" msdata:childkey="ShipperId" msprop:Description="" msprop:IsLogical="True" />
          <msdata:Relationship name="tblFact-vwEmployees" msdata:parent="dbo_vwEmployees" msdata:child="dbo_tblFact" msdata:parentkey="EmployeeID" msdata:childkey="EmployeeId" msprop:Description="" msprop:IsLogical="True" />
        </xs:appinfo>
      </xs:annotation>
    </xs:schema>
    <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1" />
  </Schema>
</DataSourceView>