AFFA II

Meeskond

• Tõnn Talpsepp
• Madis Allikmaa
• Ranno Rass
• Marek Leinjärv

XMLi skeem XSD

<?xml version="1.0" encoding="utf-8"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:element name="database">
    <xs:complexType>
      <xs:sequence>
        <xs:element maxOccurs="unbounded" name="financial_statements">
          <xs:complexType>
            <xs:sequence>
              <xs:element minOccurs="0" name="income_statement">
                <xs:complexType mixed="true">
                  <xs:sequence minOccurs="0">
                    <xs:element maxOccurs="unbounded" name="column">
                      <xs:complexType>
                        <xs:simpleContent>
                          <xs:extension base="xs:decimal">
                            <xs:attribute name="name" type="xs:string" use="required" />
                            <xs:attribute name="multiplier" type="xs:string" use="required" />
                            <xs:attribute name="unit" type="xs:string" use="required" />
                            <xs:attribute name="currency" type="xs:string" use="optional" />
                          </xs:extension>
                        </xs:simpleContent>
                      </xs:complexType>
                    </xs:element>
                  </xs:sequence>
                  <xs:attribute name="symbol" type="xs:string" use="required" />
                  <xs:attribute name="date" type="xs:date" use="required" />
                </xs:complexType>
              </xs:element>
              <xs:element minOccurs="0" name="balance_sheet">
                <xs:complexType mixed="true">
                  <xs:sequence minOccurs="0">
                    <xs:element maxOccurs="unbounded" name="column">
                      <xs:complexType>
                        <xs:simpleContent>
                          <xs:extension base="xs:decimal">
                            <xs:attribute name="name" type="xs:string" use="required" />
                            <xs:attribute name="multiplier" type="xs:string" use="required" />
                            <xs:attribute name="unit" type="xs:string" use="required" />
                            <xs:attribute name="currency" type="xs:string" use="optional" />
                          </xs:extension>
                        </xs:simpleContent>
                      </xs:complexType>
                    </xs:element>
                  </xs:sequence>
                  <xs:attribute name="symbol" type="xs:string" use="required" />
                  <xs:attribute name="date" type="xs:date" use="required" />
                </xs:complexType>
              </xs:element>
              <xs:element minOccurs="0" name="cash_flow_statement">
                <xs:complexType mixed="true">
                  <xs:sequence minOccurs="0">
                    <xs:element maxOccurs="unbounded" name="column">
                      <xs:complexType>
                        <xs:simpleContent>
                          <xs:extension base="xs:decimal">
                            <xs:attribute name="name" type="xs:string" use="required" />
                            <xs:attribute name="multiplier" type="xs:string" use="required" />
                            <xs:attribute name="unit" type="xs:string" use="required" />
                            <xs:attribute name="currency" type="xs:string" use="required" />
                          </xs:extension>
                        </xs:simpleContent>
                      </xs:complexType>
                    </xs:element>
                  </xs:sequence>
                  <xs:attribute name="symbol" type="xs:string" use="required" />
                  <xs:attribute name="date" type="xs:date" use="required" />
                </xs:complexType>
              </xs:element>
            </xs:sequence>
            <xs:attribute name="type" type="xs:string" use="required" />
          </xs:complexType>
        </xs:element>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
</xs:schema>