Schema SqlSelect-1.0.0.xsd

attribute form default: | unqualified
element form default: | qualified

Elements | Complex types
RowSet | RowCollectionType
| RowType

element RowSet

diagram |
type | RowCollectionType
children | ColumnDefinitions Rows
source |
    <xs:element name="RowSet" type="RowCollectionType">
      <xs:annotation>
        <xs:documentation>This schema defines the return structure of Fdo Select operation</xs:documentation>
      </xs:annotation>
    </xs:element>

complexType RowCollectionType

diagram |
children | ColumnDefinitions Rows
used by |
element | RowSet
source |
    <xs:complexType name="RowCollectionType">
      <xs:sequence>
        <xs:element name="ColumnDefinitions" maxOccurs="unbounded">
          <xs:annotation>
            <xs:documentation>There can be more than one table definition in case we do join operation etc. like road.id = highway.id etc.</xs:documentation>
          </xs:annotation>
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Column" maxOccurs="unbounded">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="Name" type="xs:string"/>
                    <xs:element name="Type">
                      <xs:annotation>
                        <xs:documentation>Enum of data types  Boolean, Byte, DateTime, Decimal, Double, Int16, Int32, Int64, Single, String, BLOB, CLOB, UniqueID  </xs:documentation>
                      </xs:annotation>
                      <xs:simpleType>
                        <xs:restriction base="xs:string">
                          <xs:enumeration value="boolean"/>
                          <xs:enumeration value="byte"/>
                          <xs:enumeration value="datetime"/>
                          <xs:enumeration value="decimal"/>
                          <xs:enumeration value="double"/>
                          <xs:enumeration value="int16"/>
                          <xs:enumeration value="int32"/>
                          <xs:enumeration value="int64"/>
                          <xs:enumeration value="single"/>
                          <xs:enumeration value="string"/>
                          <xs:enumeration value="blob"/>
                          <xs:enumeration value="clob"/>
                          <xs:enumeration value="uniqueId"/>
                        </xs:restriction>
                      </xs:simpleType>
                    </xs:element>
                  </xs:sequence>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Rows">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Row" minOccurs="0" maxOccurs="unbounded">
                <xs:complexType>
                  <xs:complexContent>
                    <xs:extension base="RowType">
                      <xs:sequence>
                        <xs:element name="Column" maxOccurs="unbounded">
                          <xs:complexType>
                            <xs:sequence>
                              <xs:element name="Name">
                                <xs:complexType>
                                  <xs:simpleContent>
                                    <xs:extension base="xs:string"/>
                                  </xs:simpleContent>
                                </xs:complexType>
                              </xs:element>
                              <xs:element name="Value" type="xs:string"/>
                            </xs:sequence>
                          </xs:complexType>
                        </xs:element>
                      </xs:sequence>
                    </xs:extension>
                  </xs:complexContent>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:sequence>
    </xs:complexType>

element RowCollectionType/ColumnDefinitions

diagram |
children | Column
source |
    <xs:element name="ColumnDefinitions" maxOccurs="unbounded">
      <xs:annotation>
        <xs:documentation>There can be more than one table definition in case we do join operation etc. like road.id = highway.id etc.</xs:documentation>
      </xs:annotation>
      <xs:complexType>
        <xs:sequence>
          <xs:element name="Column" maxOccurs="unbounded">
            <xs:complexType>
              <xs:sequence>
                <xs:element name="Name" type="xs:string"/>
                <xs:element name="Type">
                  <xs:annotation>
                    <xs:documentation>Enum of data types  Boolean, Byte, DateTime, Decimal, Double, Int16, Int32, Int64, Single, String, BLOB, CLOB, UniqueID  </xs:documentation>
                  </xs:annotation>
                  <xs:simpleType>
                    <xs:restriction base="xs:string">
                      <xs:enumeration value="boolean"/>
                      <xs:enumeration value="byte"/>
                      <xs:enumeration value="datetime"/>
                      <xs:enumeration value="decimal"/>
                      <xs:enumeration value="double"/>
                      <xs:enumeration value="int16"/>
                      <xs:enumeration value="int32"/>
                      <xs:enumeration value="int64"/>
                      <xs:enumeration value="single"/>
                      <xs:enumeration value="string"/>
                      <xs:enumeration value="blob"/>
                      <xs:enumeration value="clob"/>
                      <xs:enumeration value="uniqueId"/>
                    </xs:restriction>
                  </xs:simpleType>
                </xs:element>
              </xs:sequence>
            </xs:complexType>
          </xs:element>
        </xs:sequence>
      </xs:complexType>
    </xs:element>

element RowCollectionType/ColumnDefinitions/Column

diagram |
children | Name Type
source |
    <xs:element name="Column" maxOccurs="unbounded">
      <xs:complexType>
        <xs:sequence>
          <xs:element name="Name" type="xs:string"/>
          <xs:element name="Type">
            <xs:annotation>
              <xs:documentation>Enum of data types  Boolean, Byte, DateTime, Decimal, Double, Int16, Int32, Int64, Single, String, BLOB, CLOB, UniqueID  </xs:documentation>
            </xs:annotation>
            <xs:simpleType>
              <xs:restriction base="xs:string">
                <xs:enumeration value="boolean"/>
                <xs:enumeration value="byte"/>
                <xs:enumeration value="datetime"/>
                <xs:enumeration value="decimal"/>
                <xs:enumeration value="double"/>
                <xs:enumeration value="int16"/>
                <xs:enumeration value="int32"/>
                <xs:enumeration value="int64"/>
                <xs:enumeration value="single"/>
                <xs:enumeration value="string"/>
                <xs:enumeration value="blob"/>
                <xs:enumeration value="clob"/>
                <xs:enumeration value="uniqueId"/>
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
        </xs:sequence>
      </xs:complexType>
    </xs:element>

element RowCollectionType/ColumnDefinitions/Column/Name

diagram |
type | xs:string
source |
    <xs:element name="Name" type="xs:string"/>

element RowCollectionType/ColumnDefinitions/Column/Type

diagram |
type | restriction of xs:string
facets |
enumeration | boolean
enumeration | byte
enumeration | datetime
enumeration | decimal
enumeration | double
enumeration | int16
enumeration | int32
enumeration | int64
enumeration | single
enumeration | string
enumeration | blob
enumeration | clob
enumeration | uniqueId
source |
    <xs:element name="Type">
      <xs:annotation>
        <xs:documentation>Enum of data types  Boolean, Byte, DateTime, Decimal, Double, Int16, Int32, Int64, Single, String, BLOB, CLOB, UniqueID  </xs:documentation>
      </xs:annotation>
      <xs:simpleType>
        <xs:restriction base="xs:string">
          <xs:enumeration value="boolean"/>
          <xs:enumeration value="byte"/>
          <xs:enumeration value="datetime"/>
          <xs:enumeration value="decimal"/>
          <xs:enumeration value="double"/>
          <xs:enumeration value="int16"/>
          <xs:enumeration value="int32"/>
          <xs:enumeration value="int64"/>
          <xs:enumeration value="single"/>
          <xs:enumeration value="string"/>
          <xs:enumeration value="blob"/>
          <xs:enumeration value="clob"/>
          <xs:enumeration value="uniqueId"/>
        </xs:restriction>
      </xs:simpleType>
    </xs:element>

element RowCollectionType/Rows

diagram |
children | Row
source |
    <xs:element name="Rows">
      <xs:complexType>
        <xs:sequence>
          <xs:element name="Row" minOccurs="0" maxOccurs="unbounded">
            <xs:complexType>
              <xs:complexContent>
                <xs:extension base="RowType">
                  <xs:sequence>
                    <xs:element name="Column" maxOccurs="unbounded">
                      <xs:complexType>
                        <xs:sequence>
                          <xs:element name="Name">
                            <xs:complexType>
                              <xs:simpleContent>
                                <xs:extension base="xs:string"/>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element name="Value" type="xs:string"/>
                        </xs:sequence>
                      </xs:complexType>
                    </xs:element>
                  </xs:sequence>
                </xs:extension>
              </xs:complexContent>
            </xs:complexType>
          </xs:element>
        </xs:sequence>
      </xs:complexType>
    </xs:element>

element RowCollectionType/Rows/Row

diagram |
type | extension of RowType
children | Column
source |
    <xs:element name="Row" minOccurs="0" maxOccurs="unbounded">
      <xs:complexType>
        <xs:complexContent>
          <xs:extension base="RowType">
            <xs:sequence>
              <xs:element name="Column" maxOccurs="unbounded">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="Name">
                      <xs:complexType>
                        <xs:simpleContent>
                          <xs:extension base="xs:string"/>
                        </xs:simpleContent>
                      </xs:complexType>
                    </xs:element>
                    <xs:element name="Value" type="xs:string"/>
                  </xs:sequence>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:extension>
        </xs:complexContent>
      </xs:complexType>
    </xs:element>

element RowCollectionType/Rows/Row/Column

diagram |
children | Name Value
source |
    <xs:element name="Column" maxOccurs="unbounded">
      <xs:complexType>
        <xs:sequence>
          <xs:element name="Name">
            <xs:complexType>
              <xs:simpleContent>
                <xs:extension base="xs:string"/>
              </xs:simpleContent>
            </xs:complexType>
          </xs:element>
          <xs:element name="Value" type="xs:string"/>
        </xs:sequence>
      </xs:complexType>
    </xs:element>

element RowCollectionType/Rows/Row/Column/Name

diagram |
type | extension of xs:string
source |
    <xs:element name="Name">
      <xs:complexType>
        <xs:simpleContent>
          <xs:extension base="xs:string"/>
        </xs:simpleContent>
      </xs:complexType>
    </xs:element>

element RowCollectionType/Rows/Row/Column/Value

diagram |
type | xs:string
source |
    <xs:element name="Value" type="xs:string"/>

complexType RowType

diagram |
used by |
element | RowCollectionType/Rows/Row
source |
    <xs:complexType name="RowType"/>