se/SE/schema/ant-object/default_db.InvestArrangements/InvestArrangements/InvestArrangements.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__InvestArrangements="https://biuro.biall-net.pl/wfs/default_db/table/InvestArrangements.xsd"
   xmlns:default_db__x3A__Rozdzielcza_Dzialki="https://biuro.biall-net.pl/wfs/default_db/table/Rozdzielcza_Dzialki.xsd"
   xmlns:default_db__x3A__Rozdzielcza_rurociagi_obce_wsg84="https://biuro.biall-net.pl/wfs/default_db/table/Rozdzielcza_rurociagi_obce_wsg84.xsd"
   xmlns:default_db__x3A__CRM_LISTA_ZASOBOW_OFFERS="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW_OFFERS.xsd"
   xmlns:default_db__x3A__Dzialki="https://biuro.biall-net.pl/wfs/default_db/table/Dzialki.xsd"
   xmlns:default_db__x3A__rurociagi_obce_wsg84="https://biuro.biall-net.pl/wfs/default_db/table/rurociagi_obce_wsg84.xsd"
   xmlns:default_db__x3A__BUILDINGS="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.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"
   xmlns:fix_se_defaultdb_schema="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/fix_se_defaultdb_schema/fix_se_defaultdb_schema.xsd"
   xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types"
   targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/InvestArrangements.xsd"
   vc:minVersion="1.1">
   <xs:import namespace="http://biuro.biall-net.pl/p5/schema/types"
      schemaLocation="../../../types.xsd"/>
   <xs:import namespace="http://www.opengis.net/gml/3.2"
      schemaLocation="http://www.opengis.net/gml/3.2"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/Dzialki.xsd"
      schemaLocation="../../default_db.Dzialki/Dzialki/Dzialki.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
      schemaLocation="../../default_db.IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP.xsd"/>
   <xs:import
      namespace="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW_OFFERS.xsd"
      schemaLocation="../../default_db.CRM_LISTA_ZASOBOW_OFFERS/CRM_LISTA_ZASOBOW_OFFERS/CRM_LISTA_ZASOBOW_OFFERS.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/rurociagi_obce_wsg84.xsd"
      schemaLocation="../../default_db.rurociagi_obce_wsg84/rurociagi_obce_wsg84/rurociagi_obce_wsg84.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
      schemaLocation="../../default_db.BUILDINGS/BUILDINGS/BUILDINGS.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
      schemaLocation="../../default_db.ADMIN_USERS/ADMIN_USERS/ADMIN_USERS.xsd"/>
   <xs:simpleType name="A_STATUS_Type" id="rrangements___d4e7067-1_A_STATUS_T">
      <xs:restriction base="xs:string"/>
   </xs:simpleType>
   <xs:complexType name="InvestArrangements" id="rrangements___d4e7069-1_InvestArra">
      <xs:annotation>
         <xs:documentation>Instancyjny - Protopyowy obiekt, który powinien mieć typy konkretnych
            rodzaji dla różnych technologii. Podzielony z uwagi na stany projektowania oraz
            realizacji. </xs:documentation>
         <xs:appinfo>
            <system_cache__appinfo:heritage>
               <system_cache__appinfo:inherit system_cache__appinfo:inherit_ref="default_db:InvestArrangements" system_cache__appinfo:heritage_acl="true">
                  <system_cache__appinfo:acl_rule_inherit_to_all_same_name_elements_and_refs/>
                  <acl_rule_inherit_to_all_refs_by_primary/>
                  <acl_rule_inherit_to_all_refs_by_local_element system_cache__appinfo:acl_rule_inherit_local_element_name="A_ADM_COMPANY"/>
               </system_cache__appinfo:inherit>
               <system_cache__appinfo:exherit_all system_cache__appinfo:heritage_acl="true" system_cache__appinfo:heritage_sort="true"/>
            </system_cache__appinfo:heritage>
         </xs:appinfo>
      </xs:annotation>
      <xs:sequence id="rrangements___d4e7073-1">
         <xs:element minOccurs="0" maxOccurs="1" name="ID" type="xs:int"
            id="rrangements___d4e7074-1_ID"/>
         <xs:element name="A_STATUS" type="default_db__x3A__InvestArrangements:A_STATUS_Type"
            id="rrangements___d4e7075-1_A_STATUS"/>
         <xs:element name="A_STATUS_INFO" type="xs:string" id="rrangements___d4e7076-1_A_STATUS_I"/>
         <xs:element name="L_APPOITMENT_USER" type="xs:string"
            id="rrangements___d4e7077-1_L_APPOITME"/>
         <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="L_APPOITMENT_USER" system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
                </xs:documentation>
            </xs:annotation>
         </xs:element>
         <!--<xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner"
                     id="rrangements___d4e7078-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:ref_engine="view"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/name"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>-->
         <xs:element name="A_CLASSIFIED" type="xs:string" id="rrangements___d4e7083-1_A_CLASSIFI"/>
         <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
                     id="rrangements___d4e7084-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED"
                                                   system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>-->
         <xs:element name="A_ADM_COMPANY" type="xs:string" id="rrangements___d4e7089-1_A_ADM_COMP"/>
         <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
                     id="rrangements___d4e7090-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:ref_engine="view"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>-->
         <xs:element name="ID_OFFER" type="xs:int" id="rrangements___d4e7099-1_ID_OFFER"/>
         <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW_OFFERS:CRM_LISTA_ZASOBOW_OFFERS"
            minOccurs="0" id="rrangements___d4e7100-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="ID_OFFER" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW_OFFERS:CRM_LISTA_ZASOBOW_OFFERS/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>Oznaczenie elementu oferty w ramach ktorej wystepuje dane
                  uzgodnienie/kolizja/przeciecie</xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element name="ID_KORESP_INVEST_ARRANGEMENT_DEAL" type="xs:int"
            id="rrangements___d4e7107-1_ID_KORESP_">
            <xs:annotation>
               <xs:documentation>Powiazany natywny numer korespondencji</xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_INVEST_ARRANGEMENT_DEAL">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ID_KORESP_INVEST_ARRANGEMENT_DEAL" system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_INVEST_ARRANGEMENT_DEAL"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
                </xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element name="ID_BUILDINGS" type="xs:int" id="rrangements___d4e7108-1_ID_BUILDIN"/>
         <xs:element ref="default_db__x3A__BUILDINGS:BUILDINGS" minOccurs="0"
            id="rrangements___d4e7109-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="ID_BUILDINGS" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__BUILDINGS:BUILDINGS/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>Obiekt dzialki, z ktorym jest kolizja -
                  uzgodnienie</xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element name="ID_Dzialki" type="xs:int" id="rrangements___d4e7116-1_ID_Dzialki"/>
         <xs:element ref="default_db__x3A__Dzialki:Dzialki_Known" minOccurs="0"
            id="rrangements___d4e7117-1">
            <xs:annotation>
               <xs:documentation>Obiekt dzialki, z ktorym jest kolizja -
                  uzgodnienie</xs:documentation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="ID_Dzialki" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__Dzialki:Dzialki_Known/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element name="ID_rurociagi_obce_wsg84_Known" type="xs:int"
            id="rrangements___d4e7124-1_ID_rurocia"/>
         <xs:element ref="default_db__x3A__rurociagi_obce_wsg84:rurociagi_obce_wsg84_Known"
            minOccurs="0" id="rrangements___d4e7125-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="ID_rurociagi_obce_wsg84_Known" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__rurociagi_obce_wsg84:rurociagi_obce_wsg84_Known/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>Obiekt dzialki, z ktorym jest kolizja -
                  uzgodnienie</xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element name="CoverArea" type="xs:double" id="rrangements___d4e7132-1_CoverArea">
            <xs:annotation>
               <xs:documentation>W przypadku powierzchni zajecia - jest to wartosc odpowiadajaca tej
                  powierzchni</xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element name="CoverLength" type="xs:double" id="rrangements___d4e7136-1_CoverLengt"/>
         <xs:element name="CloseupDistance" type="xs:double" id="rrangements___d4e7138-1_CloseupDis">
            <xs:annotation>
               <xs:documentation>Wyliczona odleglosc do zblizenia</xs:documentation>
            </xs:annotation>
         </xs:element>
      </xs:sequence>
   </xs:complexType>
   <xs:element name="InvestArrangements"
      type="default_db__x3A__InvestArrangements:InvestArrangements"
      id="rrangements___d4e7142-1_InvestArra"/>
   <xs:complexType name="InvestArrangements_Network_Crossings"
      id="rrangements___d4e7144-1_InvestArra">
      <xs:complexContent id="rrangements___d4e7145-1">
         <xs:restriction base="default_db__x3A__InvestArrangements:InvestArrangements">
            <xs:sequence id="rrangements___d4e7147-1">
               <xs:element minOccurs="0" maxOccurs="1" name="ID" type="xs:int"
                  id="rrangements___d4e7148-1_ID"/>
               <xs:element name="A_STATUS" type="default_db__x3A__InvestArrangements:A_STATUS_Type"
                  id="rrangements___d4e7149-1_A_STATUS"/>
               <xs:element name="A_STATUS_INFO" type="xs:string"
                  id="rrangements___d4e7150-1_A_STATUS_I"/>
               <xs:element name="L_APPOITMENT_USER" type="xs:string"
                  id="rrangements___d4e7151-1_L_APPOITME"/>
               <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="L_APPOITMENT_USER" system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <!--<xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner"
                  id="rrangements___d4e7152-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:ref_engine="view" system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/name"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>-->
               <xs:element name="A_CLASSIFIED" type="xs:string"
                  id="rrangements___d4e7157-1_A_CLASSIFI"/>
               <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
                  id="rrangements___d4e7158-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>-->
               <xs:element name="A_ADM_COMPANY" type="xs:string"
                  id="rrangements___d4e7163-1_A_ADM_COMP"/>
               <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
                  id="rrangements___d4e7164-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:ref_engine="view" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>-->
               <xs:element name="ID_OFFER" type="xs:int" id="rrangements___d4e7172-1_ID_OFFER"/>
               <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW_OFFERS:CRM_LISTA_ZASOBOW_OFFERS"
                  minOccurs="0" id="rrangements___d4e7173-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_OFFER" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW_OFFERS:CRM_LISTA_ZASOBOW_OFFERS/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Oznaczenie elementu oferty w ramach ktorej wystepuje dane
                        uzgodnienie/kolizja/przeciecie</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element name="ID_KORESP_INVEST_ARRANGEMENT_DEAL" type="xs:int"
                  id="rrangements___d4e7180-1_ID_KORESP_"/>
               <xs:element
                  ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_INVEST_ARRANGEMENT_DEAL">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ID_KORESP_INVEST_ARRANGEMENT_DEAL" system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_INVEST_ARRANGEMENT_DEAL"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element name="ID_BUILDINGS" type="xs:int" id="rrangements___d4e7181-1_ID_BUILDIN"/>
               <xs:element ref="default_db__x3A__BUILDINGS:BUILDINGS" minOccurs="0" maxOccurs="0"
                  id="rrangements___d4e7182-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_BUILDINGS" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__BUILDINGS:BUILDINGS/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element name="ID_Dzialki" type="xs:int" id="rrangements___d4e7187-1_ID_Dzialki"/>
               <xs:element ref="default_db__x3A__Dzialki:Dzialki_Known" minOccurs="0" maxOccurs="0"
                  id="rrangements___d4e7188-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_Dzialki" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__Dzialki:Dzialki_Known/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Obiekt dzialki, z ktorym jest kolizja -
                        uzgodnienie</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element name="ID_rurociagi_obce_wsg84_Known" type="xs:int"
                  id="rrangements___d4e7195-1_ID_rurocia"/>
               <xs:element ref="default_db__x3A__rurociagi_obce_wsg84:rurociagi_obce_wsg84_Known"
                  minOccurs="1" id="rrangements___d4e7196-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_rurociagi_obce_wsg84_Known" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__rurociagi_obce_wsg84:rurociagi_obce_wsg84_Known/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Obiekt dzialki, z ktorym jest kolizja -
                        uzgodnienie</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element name="CoverArea" type="xs:double" id="rrangements___d4e7203-1_CoverArea">
                  <xs:annotation>
                     <xs:documentation>W przypadku powierzchni zajecia - jest to wartosc
                        odpowiadajaca tej powierzchni</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element name="CoverLength" type="xs:double"
                  id="rrangements___d4e7207-1_CoverLengt"/>
               <xs:element name="CloseupDistance" type="xs:double"
                  id="rrangements___d4e7209-1_CloseupDis">
                  <xs:annotation>
                     <xs:documentation>Wyliczona odleglosc do zblizenia</xs:documentation>
                  </xs:annotation>
               </xs:element>
            </xs:sequence>
         </xs:restriction>
      </xs:complexContent>
   </xs:complexType>
   <xs:element name="InvestArrangements_Network_Crossings"
      type="default_db__x3A__InvestArrangements:InvestArrangements_Network_Crossings"
      id="rrangements___d4e7213-1_InvestArra"/>
   <xs:complexType name="InvestArrangements_Infrastructure_Placement_Ground"
      id="rrangements___d4e7214-1_InvestArra">
      <xs:annotation>
         <xs:documentation>Relacja tylko do dzialki</xs:documentation>
      </xs:annotation>
      <xs:complexContent id="rrangements___d4e7218-1">
         <xs:restriction base="default_db__x3A__InvestArrangements:InvestArrangements">
            <xs:sequence id="rrangements___d4e7220-1">
               <xs:element minOccurs="0" maxOccurs="1" name="ID" type="xs:int"
                  id="rrangements___d4e7221-1_ID"/>
               <xs:element name="A_STATUS" type="default_db__x3A__InvestArrangements:A_STATUS_Type"
                  id="rrangements___d4e7222-1_A_STATUS"/>
               <xs:element name="A_STATUS_INFO" type="xs:string"
                  id="rrangements___d4e7223-1_A_STATUS_I"/>
               <xs:element name="L_APPOITMENT_USER" type="xs:string"
                  id="rrangements___d4e7224-1_L_APPOITME"/>
               <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="L_APPOITMENT_USER" system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <!--<xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner"
                  id="rrangements___d4e7225-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:ref_engine="view" system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/name"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>-->
               <xs:element name="A_CLASSIFIED" type="xs:string"
                  id="rrangements___d4e7230-1_A_CLASSIFI"/>
               <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
                  id="rrangements___d4e7231-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>-->
               <xs:element name="A_ADM_COMPANY" type="xs:string"
                  id="rrangements___d4e7236-1_A_ADM_COMP"/>
               <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
                  id="rrangements___d4e7237-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:ref_engine="view" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>-->
               <xs:element name="ID_OFFER" type="xs:int" id="rrangements___d4e7246-1_ID_OFFER"/>
               <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW_OFFERS:CRM_LISTA_ZASOBOW_OFFERS"
                  minOccurs="0" id="rrangements___d4e7247-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_OFFER" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW_OFFERS:CRM_LISTA_ZASOBOW_OFFERS/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Oznaczenie elementu oferty w ramach ktorej wystepuje dane
                        uzgodnienie/kolizja/przeciecie</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element name="ID_KORESP_INVEST_ARRANGEMENT_DEAL" type="xs:int"
                  id="rrangements___d4e7254-1_ID_KORESP_"/>
               <xs:element
                  ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_INVEST_ARRANGEMENT_DEAL">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ID_KORESP_INVEST_ARRANGEMENT_DEAL" system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_INVEST_ARRANGEMENT_DEAL"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element name="ID_BUILDINGS" type="xs:int" id="rrangements___d4e7255-1_ID_BUILDIN"/>
               <xs:element ref="default_db__x3A__BUILDINGS:BUILDINGS" minOccurs="0" maxOccurs="0"
                  id="rrangements___d4e7256-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_BUILDINGS" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__BUILDINGS:BUILDINGS/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Oznaczenie elementu oferty w ramach ktorej wystepuje dane
                        uzgodnienie/kolizja/przeciecie</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element name="ID_Dzialki" type="xs:int" id="rrangements___d4e7263-1_ID_Dzialki"/>
               <xs:element ref="default_db__x3A__Dzialki:Dzialki_Known" minOccurs="1"
                  id="rrangements___d4e7264-1">
                  <xs:annotation>
                     <xs:documentation>Obiekt dzialki, z ktorym jest kolizja -
                        uzgodnienie</xs:documentation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_Dzialki" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__Dzialki:Dzialki_Known/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element name="ID_rurociagi_obce_wsg84_Known" type="xs:int"
                  id="rrangements___d4e7271-1_ID_rurocia"/>
               <xs:element ref="default_db__x3A__rurociagi_obce_wsg84:rurociagi_obce_wsg84_Known"
                  minOccurs="0" maxOccurs="0" id="rrangements___d4e7272-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_rurociagi_obce_wsg84_Known" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__rurociagi_obce_wsg84:rurociagi_obce_wsg84_Known/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Obiekt dzialki, z ktorym jest kolizja -
                        uzgodnienie</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element name="CoverArea" type="xs:double" id="rrangements___d4e7279-1_CoverArea">
                  <xs:annotation>
                     <xs:documentation>W przypadku powierzchni zajecia - jest to wartosc
                        odpowiadajaca tej powierzchni</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element name="CoverLength" type="xs:double"
                  id="rrangements___d4e7283-1_CoverLengt"/>
               <xs:element name="CloseupDistance" type="xs:double"
                  id="rrangements___d4e7285-1_CloseupDis">
                  <xs:annotation>
                     <xs:documentation>Wyliczona odleglosc do zblizenia</xs:documentation>
                  </xs:annotation>
               </xs:element>
            </xs:sequence>
         </xs:restriction>
      </xs:complexContent>
   </xs:complexType>
   <xs:element name="InvestArrangements_Infrastructure_Placement_Ground"
      type="default_db__x3A__InvestArrangements:InvestArrangements_Infrastructure_Placement_Ground"
      id="rrangements___d4e7289-1_InvestArra">
      <xs:annotation>
         <xs:documentation>W relacji od KORESP - DEAL arrang....</xs:documentation>
      </xs:annotation>
   </xs:element>
   <xs:complexType name="InvestArrangements_Infrastructure_Placement_Buildings"
      id="rrangements___d4e7293-1_InvestArra">
      <xs:annotation>
         <xs:documentation>tylko relacja do budynkow</xs:documentation>
      </xs:annotation>
      <xs:complexContent id="rrangements___d4e7297-1">
         <xs:restriction base="default_db__x3A__InvestArrangements:InvestArrangements">
            <xs:sequence id="rrangements___d4e7299-1">
               <xs:element minOccurs="0" maxOccurs="1" name="ID" type="xs:int"
                  id="rrangements___d4e7300-1_ID"/>
               <xs:element name="A_STATUS" type="default_db__x3A__InvestArrangements:A_STATUS_Type"
                  id="rrangements___d4e7301-1_A_STATUS"/>
               <xs:element name="A_STATUS_INFO" type="xs:string"
                  id="rrangements___d4e7302-1_A_STATUS_I"/>
               <xs:element name="L_APPOITMENT_USER" type="xs:string"
                  id="rrangements___d4e7303-1_L_APPOITME"/>
               <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="L_APPOITMENT_USER" system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <!--<xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner"
                  id="rrangements___d4e7304-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:ref_engine="view" system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/name"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>-->
               <xs:element name="A_CLASSIFIED" type="xs:string"
                  id="rrangements___d4e7309-1_A_CLASSIFI"/>
               <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
                  id="rrangements___d4e7310-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>-->
               <xs:element name="A_ADM_COMPANY" type="xs:string"
                  id="rrangements___d4e7315-1_A_ADM_COMP"/>
               <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
                  id="rrangements___d4e7316-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:ref_engine="view" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>-->
               <xs:element name="ID_OFFER" type="xs:int" id="rrangements___d4e7325-1_ID_OFFER"/>
               <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW_OFFERS:CRM_LISTA_ZASOBOW_OFFERS"
                  minOccurs="0" id="rrangements___d4e7326-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_OFFER" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW_OFFERS:CRM_LISTA_ZASOBOW_OFFERS/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Oznaczenie elementu oferty w ramach ktorej wystepuje dane
                        uzgodnienie/kolizja/przeciecie</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element name="ID_KORESP_INVEST_ARRANGEMENT_DEAL" type="xs:int"
                  id="rrangements___d4e7333-1_ID_KORESP_"/>
               <xs:element
                  ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_INVEST_ARRANGEMENT_DEAL">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ID_KORESP_INVEST_ARRANGEMENT_DEAL" system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_INVEST_ARRANGEMENT_DEAL"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element name="ID_BUILDINGS" type="xs:int" id="rrangements___d4e7334-1_ID_BUILDIN"/>
               <xs:element ref="default_db__x3A__BUILDINGS:BUILDINGS" minOccurs="1"
                  id="rrangements___d4e7335-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_BUILDINGS" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__BUILDINGS:BUILDINGS/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Oznaczenie elementu oferty w ramach ktorej wystepuje dane
                        uzgodnienie/kolizja/przeciecie</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element name="ID_Dzialki" type="xs:int" id="rrangements___d4e7336-1_ID_Dzialki"/>
               <xs:element ref="default_db__x3A__Dzialki:Dzialki_Known" minOccurs="0" maxOccurs="0"
                  id="rrangements___d4e7337-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_Dzialki" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__Dzialki:Dzialki_Known/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Obiekt dzialki, z ktorym jest kolizja -
                        uzgodnienie</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element name="ID_rurociagi_obce_wsg84_Known" type="xs:int"
                  id="rrangements___d4e7341-1_ID_rurocia"/>
               <xs:element ref="default_db__x3A__rurociagi_obce_wsg84:rurociagi_obce_wsg84_Known"
                  minOccurs="0" maxOccurs="0" id="rrangements___d4e7342-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_rurociagi_obce_wsg84_Known" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__rurociagi_obce_wsg84:rurociagi_obce_wsg84_Known/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Obiekt dzialki, z ktorym jest kolizja -
                        uzgodnienie</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element name="CoverArea" type="xs:double" id="rrangements___d4e7349-1_CoverArea">
                  <xs:annotation>
                     <xs:documentation>W przypadku powierzchni zajecia - jest to wartosc
                        odpowiadajaca tej powierzchni</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element name="CoverLength" type="xs:double"
                  id="rrangements___d4e7353-1_CoverLengt"/>
               <xs:element name="CloseupDistance" type="xs:double"
                  id="rrangements___d4e7355-1_CloseupDis">
                  <xs:annotation>
                     <xs:documentation>Wyliczona odleglosc do zblizenia</xs:documentation>
                  </xs:annotation>
               </xs:element>
            </xs:sequence>
         </xs:restriction>
      </xs:complexContent>
   </xs:complexType>
   <xs:element name="InvestArrangements_Infrastructure_Placement_Buildings"
      type="default_db__x3A__InvestArrangements:InvestArrangements_Infrastructure_Placement_Buildings"
      id="rrangements___d4e7359-1_InvestArra"/>
</xs:schema>