clrds.xsd

< SQL Server2005程序设计>

                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FirstName" msprop:Generator_UserColumnName="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MiddleName" msprop:Generator_UserColumnName="MiddleName" msprop:Generator_ColumnVarNameInTable="columnMiddleName" msprop:Generator_ColumnPropNameInRow="MiddleName" msprop:Generator_ColumnPropNameInTable="MiddleNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msprop:Generator_UserColumnName="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Suffix" msprop:Generator_UserColumnName="Suffix" msprop:Generator_ColumnVarNameInTable="columnSuffix" msprop:Generator_ColumnPropNameInRow="Suffix" msprop:Generator_ColumnPropNameInTable="SuffixColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmailAddress" msprop:Generator_UserColumnName="EmailAddress" msprop:Generator_ColumnVarNameInTable="columnEmailAddress" msprop:Generator_ColumnPropNameInRow="EmailAddress" msprop:Generator_ColumnPropNameInTable="EmailAddressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmailPromotion" msprop:Generator_UserColumnName="EmailPromotion" msprop:Generator_ColumnVarNameInTable="columnEmailPromotion" msprop:Generator_ColumnPropNameInRow="EmailPromotion" msprop:Generator_ColumnPropNameInTable="EmailPromotionColumn" type="xs:int" />
              <xs:element name="Phone" msprop:Generator_UserColumnName="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PasswordHash" msprop:Generator_UserColumnName="PasswordHash" msprop:Generator_ColumnVarNameInTable="columnPasswordHash" msprop:Generator_ColumnPropNameInRow="PasswordHash" msprop:Generator_ColumnPropNameInTable="PasswordHashColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PasswordSalt" msprop:Generator_UserColumnName="PasswordSalt" msprop:Generator_ColumnVarNameInTable="columnPasswordSalt" msprop:Generator_ColumnPropNameInRow="PasswordSalt" msprop:Generator_ColumnPropNameInTable="PasswordSaltColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AdditionalContactInfo" msprop:Generator_UserColumnName="AdditionalContactInfo" msprop:Generator_ColumnVarNameInTable="columnAdditionalContactInfo" msprop:Generator_ColumnPropNameInRow="AdditionalContactInfo" msprop:Generator_ColumnPropNameInTable="AdditionalContactInfoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="rowguid" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="rowguid" msprop:Generator_ColumnVarNameInTable="columnrowguid" msprop:Generator_ColumnPropNameInRow="rowguid" msprop:Generator_ColumnPropNameInTable="rowguidColumn" type="xs:string" />
              <xs:element name="ModifiedDate" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblAggregateTest" msprop:Generator_UserTableName="tblAggregateTest" msprop:Generator_RowDeletedName="tblAggregateTestRowDeleted" msprop:Generator_RowChangedName="tblAggregateTestRowChanged" msprop:Generator_RowClassName="tblAggregateTestRow" msprop:Generator_RowChangingName="tblAggregateTestRowChanging" msprop:Generator_RowEvArgName="tblAggregateTestRowChangeEvent" msprop:Generator_RowEvHandlerName="tblAggregateTestRowChangeEventHandler" msprop:Generator_TableClassName="tblAggregateTestDataTable" msprop:Generator_TableVarName="tabletblAggregateTest" msprop:Generator_RowDeletingName="tblAggregateTestRowDeleting" msprop:Generator_TablePropName="tblAggregateTest">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OrderId" msprop:Generator_UserColumnName="OrderId" msprop:Generator_ColumnVarNameInTable="columnOrderId" msprop:Generator_ColumnPropNameInRow="OrderId" msprop:Generator_ColumnPropNameInTable="OrderIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SUM" msdata:ReadOnly="true" msprop:Generator_UserColumnName="SUM" msprop:Generator_ColumnVarNameInTable="columnSUM" msprop:Generator_ColumnPropNameInRow="SUM" msprop:Generator_ColumnPropNameInTable="SUMColumn" type="xs:int" minOccurs="0" />
              <xs:element name="BakersDozen" msdata:ReadOnly="true" msprop:Generator_UserColumnName="BakersDozen" msprop:Generator_ColumnVarNameInTable="columnBakersDozen" msprop:Generator_ColumnPropNameInRow="BakersDozen" msprop:Generator_ColumnPropNameInTable="BakersDozenColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblPoint" msprop:Generator_UserTableName="tblPoint" msprop:Generator_RowDeletedName="tblPointRowDeleted" msprop:Generator_RowChangedName="tblPointRowChanged" msprop:Generator_RowClassName="tblPointRow" msprop:Generator_RowChangingName="tblPointRowChanging" msprop:Generator_RowEvArgName="tblPointRowChangeEvent" msprop:Generator_RowEvHandlerName="tblPointRowChangeEventHandler" msprop:Generator_TableClassName="tblPointDataTable" msprop:Generator_TableVarName="tabletblPoint" msprop:Generator_RowDeletingName="tblPointRowDeleting" msprop:Generator_TablePropName="tblPoint">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ThePoint" msprop:Generator_UserColumnName="ThePoint" msprop:Generator_ColumnVarNameInTable="columnThePoint" msprop:Generator_ColumnPropNameInRow="ThePoint" msprop:Generator_ColumnPropNameInTable="ThePointColumn" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="fnPortfolioTable" msprop:Generator_UserTableName="fnPortfolioTable" msprop:Generator_RowDeletedName="fnPortfolioTableRowDeleted" msprop:Generator_RowChangedName="fnPortfolioTableRowChanged" msprop:Generator_RowClassName="fnPortfolioTableRow" msprop:Generator_RowChangingName="fnPortfolioTableRowChanging" msprop:Generator_RowEvArgName="fnPortfolioTableRowChangeEvent" msprop:Generator_RowEvHandlerName="fnPortfolioTableRowChangeEventHandler" msprop:Generator_TableClassName="fnPortfolioTableDataTable" msprop:Generator_TableVarName="tablefnPortfolioTable" msprop:Generator_RowDeletingName="fnPortfolioTableRowDeleting" msprop:Generator_TablePropName="fnPortfolioTable">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TickerSymbol" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TickerSymbol" msprop:Generator_ColumnVarNameInTable="columnTickerSymbol" msprop:Generator_ColumnPropNameInRow="TickerSymbol" msprop:Generator_ColumnPropNameInTable="TickerSymbolColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Value" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Value" msprop:Generator_ColumnVarNameInTable="columnValue" msprop:Generator_ColumnPropNameInRow="Value" msprop:Generator_ColumnPropNameInTable="ValueColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:spContacts" />
      <xs:field xpath="mstns:ContactID" />
    </xs:unique>
  </xs:element>
</xs:schema>