FWD » Core Development » Database

<?xml version="1.0" encoding="UTF-8"?>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://goldencode.com/testNamespace" xmlns:fwdPrefix="http://goldencode.com/testNamespace" targetNamespace="http://goldencode.com/testNamespace" elementFormDefault="qualified" xmlns:prodata="urn:schemas-progress-com:xml-prodata:0001">

  <xsd:element name="tt" prodata:proTempTable="true" prodata:prefix="fwdPrefix">

    <xsd:complexType>

      <xsd:sequence>

        <xsd:element name="ttRow" minOccurs="0" maxOccurs="unbounded">

          <xsd:complexType>

            <xsd:sequence>

              <xsd:element name="fchar" type="xsd:string" nillable="true" default="99aa" prodata:userOrder="3"/>

              <xsd:element name="fcharcs" type="xsd:string" nillable="true" default="aa88" prodata:userOrder="4" prodata:caseSensitive="true"/>

              <xsd:element name="fcharext" type="xsd:string" nillable="true" minOccurs="8" maxOccurs="8" default="99ee" prodata:userOrder="5" prodata:caseSensitive="true"/>

              <xsd:element name="fdecimal" type="xsd:decimal" nillable="true" prodata:userOrder="6"/>

              <xsd:element name="fint" type="xsd:int" nillable="true" default="1" prodata:userOrder="7"/>

              <xsd:element name="fint64" type="xsd:long" nillable="true" default="4" prodata:userOrder="8"/>

              <xsd:element name="fbool" type="xsd:boolean" nillable="true" default="true" prodata:userOrder="9"/>

              <xsd:element name="fdate" type="xsd:date" nillable="true" prodata:initial="prodata:today" prodata:userOrder="10"/>

              <xsd:element name="fdatetime" type="xsd:dateTime" nillable="true" prodata:dataType="prodata:dateTime" prodata:initial="prodata:now" prodata:userOrder="11"/>

              <xsd:element name="fdatetime-tz" type="xsd:dateTime" nillable="true" prodata:initial="prodata:now" prodata:userOrder="12"/>

              <xsd:element name="fdatetime-tz1" type="xsd:dateTime" nillable="true" default="2022-10-17T13:47:48.426+03:00" prodata:userOrder="13"/>

              <xsd:element name="fblob" type="xsd:base64Binary" nillable="true" prodata:dataType="prodata:blob" prodata:userOrder="14"/>

              <xsd:element name="fclob2" type="xsd:string" nillable="true" prodata:dataType="prodata:clob" prodata:userOrder="15" prodata:columnCodepage="IBM850"/>

              <xsd:element name="frecid" type="xsd:long" nillable="true" prodata:dataType="prodata:recid" prodata:userOrder="16"/>

              <xsd:element name="fhandle" type="xsd:long" nillable="true" prodata:dataType="prodata:handle" prodata:userOrder="17"/>

              <xsd:element name="fcom-handle" type="xsd:long" nillable="true" prodata:dataType="prodata:comHandle" prodata:userOrder="18"/>

              <xsd:element name="fraw" type="xsd:base64Binary" nillable="true" prodata:userOrder="19"/>

              <xsd:element name="frowid" type="xsd:base64Binary" nillable="true" prodata:dataType="prodata:rowid" prodata:userOrder="20"/>

            </xsd:sequence>

            <xsd:attribute name="achar" type="xsd:string" default="99aa" prodata:userOrder="1"/>

            <xsd:attribute name="aint" type="xsd:int" default="1" prodata:userOrder="2"/>

            <xsd:attribute name="aint1" type="xsd:int" default="1" prodata:userOrder="21"/>

          </xsd:complexType>

        </xsd:element>

      </xsd:sequence>

    </xsd:complexType>

    <xsd:unique name="idx3">

      <xsd:selector xpath=".//fwdPrefix:ttRow"/>

      <xsd:field xpath="fwdPrefix:fint"/>

    </xsd:unique>

  </xsd:element>

  <xsd:annotation>

    <xsd:appinfo>

      <prodata:index name="idx1" prodata:primaryIndex="true">

        <prodata:table name="tt"/>

        <prodata:field name="fchar"/>

      </prodata:index>

      <prodata:index name="idx2">

        <prodata:table name="tt"/>

        <prodata:field name="achar"/>

      </prodata:index>

    </xsd:appinfo>

  </xsd:annotation>

</xsd:schema>