se/SE/schema/table/DEALS_TABLE_OFFERS_STATS.xsd

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
           xmlns:gml="http://www.opengis.net/gml/3.2"
           xmlns:Types__x3A__default_Default="https://biuro.biall-net.pl/wfs/default_db/Types/Default.xsd"
           xmlns:default_db__x3A__IN7_DZIENNIK_KORESP="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
           xmlns:hfp="http://www.w3.org/2001/XMLSchema-hasFacetAndProperty"
           xmlns:default_db__x3A__ADMIN_USERS="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
           xmlns:default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
           xmlns:SystemObjects__x3A__AccessGroup="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessGroup.xsd"
           xmlns:SystemObjects__x3A__AccessOwner="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessOwner.xsd"
           xmlns:default_db__x3A__DEALS_TABLE_OFFERS_STATS="https://biuro.biall-net.pl/wfs/default_db/table/DEALS_TABLE_OFFERS_STATS.xsd"
           xmlns:p5_tr_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"
           xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
           xmlns:system_cache__resources_tree_generate_xsl_required_occurs_raport="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/resources_tree_generate_xsl_require_occurs_raport"
           xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
           targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/DEALS_TABLE_OFFERS_STATS.xsd"
           vc:minVersion="1.1">
   <xs:import namespace="http://www.opengis.net/gml/3.2"
              schemaLocation="../Types/gml.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
              schemaLocation="../table/IN7_DZIENNIK_KORESP.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
              schemaLocation="../table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessGroup.xsd"
              schemaLocation="../SystemObjects/AccessGroup.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessOwner.xsd"
              schemaLocation="../SystemObjects/AccessOwner.xsd"/>
   <xs:simpleType name="A_STATUS_Type" id="FFERS_STATS___d5e78816-1_A_STATUS_T">
      <xs:restriction base="xs:string">
         <xs:enumeration value="NORMAL"/>
         <xs:enumeration value="WAITING"/>
         <xs:enumeration value="MONITOR"/>
         <xs:enumeration value="DELETED"/>
         <xs:enumeration value="WARNING"/>
         <xs:enumeration value="OFF_SOFT"/>
         <xs:enumeration value="OFF_HARD"/>
      </xs:restriction>
   </xs:simpleType>
   <xs:complexType name="DEALS_TABLE_OFFERS_STATS"
                   id="FFERS_STATS___d5e78825-1_DEALS_TABL">
      <xs:sequence id="FFERS_STATS___d5e78826-1">
         <xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner"
                     id="FFERS_STATS___d5e78827-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/login"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
                     id="FFERS_STATS___d5e78832-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/uid"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
                     id="FFERS_STATS___d5e78837-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/uid"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element name="ID_DEAL"
                     type="xs:integer"
                     id="FFERS_STATS___d5e78842-1_ID_DEAL"/>
         <xs:element name="ID_GROUP"
                     type="xs:integer"
                     id="FFERS_STATS___d5e78843-1_ID_GROUP"/>
         <xs:element name="ID_OFFER"
                     type="xs:integer"
                     id="FFERS_STATS___d5e78844-1_ID_OFFER"/>
         <xs:element name="ID_COSTS_GROUPS"
                     type="xs:integer"
                     id="FFERS_STATS___d5e78845-1_ID_COSTS_G"/>
         <xs:element name="OFFER_P_SERVICE"
                     type="xs:string"
                     id="FFERS_STATS___d5e78846-1_OFFER_P_SE"/>
         <xs:element name="OFFER_P_SERVICE_PARENT"
                     type="xs:string"
                     id="FFERS_STATS___d5e78847-1_OFFER_P_SE"/>
         <xs:element name="GROUP_S_ALIAS"
                     type="xs:string"
                     id="FFERS_STATS___d5e78848-1_GROUP_S_AL"/>
         <xs:element name="DEAL_S_ADDRESS_STREET"
                     type="xs:string"
                     id="FFERS_STATS___d5e78849-1_DEAL_S_ADD"/>
         <xs:element name="BUILDING_M_REWIR"
                     type="xs:string"
                     id="FFERS_STATS___d5e78851-1_BUILDING_M"/>
         <xs:element name="BUILDING_P_OSIEDLE"
                     type="xs:string"
                     id="FFERS_STATS___d5e78852-1_BUILDING_P"/>
         <xs:element name="GROUP_P_DEALTERM_MONTHS"
                     type="xs:integer"
                     id="FFERS_STATS___d5e78853-1_GROUP_P_DE"/>
         <xs:element name="OFFER_P_DEAL_PROMO_MONTHS"
                     type="xs:integer"
                     id="FFERS_STATS___d5e78854-1_OFFER_P_DE"/>
         <xs:element name="OFFER_P_CONTRACT_PRICE_NETTO"
                     type="xs:double"
                     id="FFERS_STATS___d5e78855-1_OFFER_P_CO"/>
         <xs:element name="OFFER_P_PROMO_MONTH_PRICE_NETTO"
                     type="xs:double"
                     id="FFERS_STATS___d5e78856-1_OFFER_P_PR"/>
         <xs:element name="OFFER_P_INSTALL_QUOTE_NETTO"
                     type="xs:double"
                     id="FFERS_STATS___d5e78857-1_OFFER_P_IN"/>
         <xs:element name="OFFER_ABO_SUM_NETTO"
                     type="xs:double"
                     id="FFERS_STATS___d5e78858-1_OFFER_ABO_"/>
         <xs:element name="OFFER_ABO_AVG_NETTO"
                     type="xs:double"
                     id="FFERS_STATS___d5e78859-1_OFFER_ABO_"/>
         <xs:element name="OFFER_COST_NETTO"
                     type="xs:double"
                     id="FFERS_STATS___d5e78860-1_OFFER_COST"/>
         <xs:element name="OFFER_ZYSK_NETTO"
                     type="xs:double"
                     id="FFERS_STATS___d5e78861-1_OFFER_ZYSK"/>
      </xs:sequence>
   </xs:complexType>
   <xs:element name="DEALS_TABLE_OFFERS_STATS"
               type="default_db__x3A__DEALS_TABLE_OFFERS_STATS:DEALS_TABLE_OFFERS_STATS"
               id="FFERS_STATS___d5e78862-1_DEALS_TABL"/>
</xs:schema>