se/SE/schema/ant-object/default_db.BUILDINGS/BUILDINGS/BUILDINGS.xsd

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
           xmlns:default_db__x3A__BUILDINGS="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
           xmlns:gml="http://www.opengis.net/gml/3.2"
           xmlns:default_db__x3A__COMPANIES="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.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:p5Type="http://biuro.biall-net.pl/p5/schema/types"
           xmlns:default_db__x3A__TERYT_adresy="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_adresy.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:default_db__x3A__ADMIN_USERS="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
           xmlns:default_db__x3A__CRM_LISTA_ZASOBOW="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW.xsd"
           xmlns:default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
           xmlns:default_db__x3A__TERYT_ulice="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_ulice.xsd"
           xmlns:default_db__x3A__USERS2_MARKETING="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_MARKETING.xsd"
           xmlns:default_db__x3A__MK_Rewiry="https://biuro.biall-net.pl/wfs/default_db/table/MK_Rewiry.xsd"
           elementFormDefault="qualified"
           targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
           vc:minVersion="1.1">
   <xs:import namespace="http://www.opengis.net/gml/3.2"
              schemaLocation="http://www.opengis.net/gml/3.2"/>
   <xs:import namespace="http://biuro.biall-net.pl/p5/schema/types"
              schemaLocation="../../../types.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
              schemaLocation="../../default_db.COMPANIES/COMPANIES/COMPANIES.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_adresy.xsd"
              schemaLocation="../../default_db.TERYT_adresy/TERYT_adresy/TERYT_adresy.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:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
              schemaLocation="../../default_db.IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW.xsd"
              schemaLocation="../../default_db.CRM_LISTA_ZASOBOW/CRM_LISTA_ZASOBOW/CRM_LISTA_ZASOBOW.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_MARKETING.xsd"
              schemaLocation="../../default_db.USERS2_MARKETING/USERS2_MARKETING/USERS2_MARKETING.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/MK_Rewiry.xsd"
              schemaLocation="../../default_db.MK_Rewiry/MK_Rewiry/MK_Rewiry.xsd"/>
   <xs:import schemaLocation="../../default_db.TERYT_ulice/TERYT_ulice/TERYT_ulice.xsd"
              namespace="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_ulice.xsd"/>
   <xs:complexType name="BUILDINGS">
      <xs:annotation>
         <xs:appinfo>
            <system_cache__appinfo:heritage>
               <system_cache__appinfo:inherit system_cache__appinfo:inherit_ref="default_db:BUILDINGS"
                                              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="P_ID"/>
               </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>
         <xs:element name="ID" type="p5Type:integer"/>
         <xs:element name="geoportal_gml_punkty_adr_gml_id"
                     minOccurs="0"
                     type="p5Type:string"/>
         <xs:element name="TERYT_ulice" minOccurs="0" type="xs:int"/>
         <!--<xs:element minOccurs="0" ref="default_db__x3A__TERYT_SIMC:TERYT_SIMC">
            <xs:annotation>
               <xs:documentation>Opcjonalne dowiazanie sie do jakiegos adresu i zaciagniecie z niego danych lokalne</xs:documentation>
            </xs:annotation>
         </xs:element>-->
         <xs:element minOccurs="0" ref="default_db__x3A__TERYT_ulice:TERYT_ulice">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="TERYT_ulice"
                                                   system_cache__appinfo:xpath="default_db__x3A__TERYT_ulice:TERYT_ulice/SYM"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>Opcjonalne dowiazanie sie do jakiegos adresu i zaciagniecie z niego danych lokalne</xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element name="A_RECORD_CREATE_DATE"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="A_RECORD_CREATE_AUTHOR"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="A_RECORD_UPDATE_DATE" minOccurs="0" type="p5Type:dateTime"/>
         <xs:element name="A_RECORD_UPDATE_AUTHOR"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="L_APPOITMENT_DATE"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="L_APPOITMENT_USER"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <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:annotation>
         </xs:element>
         <xs:element name="L_APPOITMENT_PERIOD"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="L_APPOITMENT_INFO"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="L_APPOITMENT_TYPE"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="xs:string"> </xs:element>
         <xs:element name="A_PROBLEM"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="xs:string"> </xs:element>
         <xs:element name="A_PROBLEM_DESC"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="A_PROBLEM_DATE"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="A_STATUS"
                     minOccurs="0"
                     nillable="true"
                     default="MONITOR"
                     type="default_db__x3A__BUILDINGS:A_STATUS_Type"/>
         <xs:element name="A_STATUS_INFO"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="A_STATUS_LASTCHANGE_DATE"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="A_UPDATE_DATE"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="A_ADM_COMPANY"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="S_ADMIN_NAME"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="S_ADDRESS_CITY"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="S_ADDRESS_POST_CODE"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="S_ADDRESS_POST_OFFICE"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="S_ADDRESS_STREET"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="S_ADDRESS_STREET_FULL" minOccurs="0" type="p5Type:string"/>
         <xs:element name="S_ADDRESS_HOUSE"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="S_OTHER_INFO"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="P_ADMIN_NAME"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="P_ADDRESS_CITY"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="P_ADDRESS_POST_CODE"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="P_ADDRESS_POST_OFFICE"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="P_ADDRESS_STREET"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="P_ADDRESS_HOUSE"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="P_OTHER_INFO"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="P_DEAL_DATE"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="P_DEALNUMBER"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="P_DEALEXPIRE"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="P_DEAL_DETAIL"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="P_DEAL_LOCATION"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="T_NETWORK_SERVER"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="T_TOPOLOGY_PLACE"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="T_BUILDING_TYPE"
                     minOccurs="0"
                     default="N/S;"
                     type="default_db__x3A__BUILDINGS:T_BUILDING_TYPE_Type"/>
         <xs:element name="T_BUILDING_SAVE"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="T_BUILDING_POWER"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="T_INSTALACJA_W_CIAGU_DNI"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="T_WORKPOINTS" minOccurs="0" type="p5Type:string"/>
         <xs:element name="T_WORKPOINTS_VALUE"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="T_WORKPOINTS_TYPE"
                     minOccurs="0"
                     nillable="true"
                     type="default_db__x3A__BUILDINGS:T_WORKPOINTS_TYPE_Type"/>
         <xs:element name="T_WORKPOINTS_USER"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="T_WORKPOINTS_DATE"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="T_WHO_CONNECTED"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="T_WHEN_CONNECTED"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="T_TEL_KONKURENCJA_OPER"
                     minOccurs="0"
                     nillable="true"
                     type="xs:string"/>
         <xs:element name="T_TV_KONKURENCJA_OPER"
                     minOccurs="0"
                     nillable="true"
                     type="xs:string"/>
         <xs:element name="T_LAN_KONKURENCJA_OPER"
                     minOccurs="0"
                     nillable="true"
                     type="default_db__x3A__BUILDINGS:T_LAN_KONKURENCJA_OPER_Type"/>
         <xs:element name="B_INVENTORY_DATE"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="M_ZRYWKA_DATE"
                     minOccurs="0"
                     nillable="true"
                     type="p5Type:date"/>
         <xs:element name="M_ZRYWKA_NUMBER"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="M_REWIR" minOccurs="0" default="" type="p5Type:string"/>
         <xs:element ref="default_db__x3A__MK_Rewiry:MK_Rewiry">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="M_REWIR"
                                                   system_cache__appinfo:xpath="default_db__x3A__MK_Rewiry:MK_Rewiry/NAZWA_REWI"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element name="M_PARAMETRY"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="M_DIST_OPTIONS"
                     minOccurs="0"
                     nillable="true"
                     type="xs:string"> </xs:element>
         <xs:element name="M_DIRECT_MARKETING_DATE"
                     minOccurs="0"
                     nillable="true"
                     type="p5Type:date"/>
         <xs:element name="M_DATA_ZASIEDLENIA"
                     minOccurs="0"
                     nillable="true"
                     type="p5Type:date"/>
         <xs:element name="ID_PROJECT"
                     minOccurs="0"
                     nillable="true"
                     type="p5Type:integer"/>
         <xs:element ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="ID_PROJECT"
                                                   system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element name="path"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="P_NR_DZIALKI"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="P_NR_KW" minOccurs="0" default="" type="p5Type:string"/>
         <xs:element name="P_OTHER_DOC"
                     minOccurs="0"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="P_PESEL" minOccurs="0" default="" type="p5Type:string"/>
         <xs:element name="P_KRS" minOccurs="0" default="" type="p5Type:string"/>
         <xs:element name="P_ADDRESS" minOccurs="0" default="" type="p5Type:string"/>
         <xs:element name="P_NAME" minOccurs="0" default="" type="p5Type:string"/>
         <xs:element name="P_ACCOUNT" minOccurs="0" type="p5Type:string"/>
         <xs:element name="P_OSIEDLE" minOccurs="0" default="" type="p5Type:string"/>
         <xs:element name="T_BUILDING_PIETRA" minOccurs="0" type="p5Type:integer"/>
         <xs:element name="T_BUILDING_PIWNICA"
                     minOccurs="0"
                     default="N/S;"
                     type="xs:string"> </xs:element>
         <xs:element name="T_BUILDING_KLATKI" minOccurs="0" type="p5Type:integer"/>
         <xs:element name="T_BUILDING_MIESZKANIA" minOccurs="0" type="p5Type:integer"/>
         <xs:element name="A_CLASSIFIED" minOccurs="0" type="p5Type:string"/>
         <xs:element name="M_LAST_STICKER_DATE"
                     minOccurs="0"
                     nillable="true"
                     type="p5Type:date"/>
         <xs:element name="the_geom"
                     minOccurs="0"
                     nillable="true"
                     type="p5Type:polygon"/>
         <xs:element name="SYNC_SQIX_STATUS" minOccurs="0" type="p5Type:string"/>
         <xs:element name="gid" minOccurs="0" nillable="true" type="p5Type:integer"/>
         <xs:element name="T_ADDRESS_CLASS"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="B_LINK"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="B_URL"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="B_XYZ"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="p5Type:string"/>
         <xs:element name="B_ASCII"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="p5Type:text"/>
         <xs:element name="CRM_LISTA_ZASOBOW_ID" minOccurs="0" type="p5Type:integer"/>
         <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="CRM_LISTA_ZASOBOW_ID"
                                                   system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element name="etykieta_x"
                     minOccurs="0"
                     nillable="true"
                     type="p5Type:decimal"/>
         <xs:element name="etykieta_y"
                     minOccurs="0"
                     nillable="true"
                     type="p5Type:decimal"/>
         <xs:element name="__Rozdzielcza_Kabel_Swiatlowodowy_wsg84"
                     minOccurs="0"
                     nillable="true"
                     type="p5Type:integer"/>
         <xs:element name="__MK_Rewiry__STATUS" minOccurs="0" type="p5Type:string"/>
         <xs:element name="ID_BILLING_USERS" minOccurs="0" type="p5Type:integer"/>
         <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS" minOccurs="0">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="ID_BILLING_USERS"
                                                   system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element name="ID_BILLING_USERS_ADMIN" minOccurs="0" type="p5Type:integer"/>
         <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS_ADMIN" minOccurs="0">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="ID_BILLING_USERS_ADMIN"
                                                   system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS_ADMIN/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element maxOccurs="unbounded"
                     minOccurs="0"
                     ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="S_ADDRESS_STREET"
                                                   system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING/T_TELBOX_BUILDING_IN"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>Reff- backref jest od marketingu</xs:documentation>
            </xs:annotation>
         </xs:element>
      </xs:sequence>
   </xs:complexType>
   <xs:element name="BUILDINGS" type="default_db__x3A__BUILDINGS:BUILDINGS"/>
   <xs:complexType name="Budynek_blok">
      <xs:complexContent>
         <xs:restriction base="default_db__x3A__BUILDINGS:BUILDINGS">
            <xs:sequence>
               <xs:element name="ID" type="p5Type:integer"/>
               <xs:element name="geoportal_gml_punkty_adr_gml_id"
                           minOccurs="0"
                           type="p5Type:string"/>
               <xs:element name="TERYT_ulice" minOccurs="0" type="xs:int"/>
               <xs:element minOccurs="0" ref="default_db__x3A__TERYT_ulice:TERYT_ulice">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="TERYT_ulice"
                                                         system_cache__appinfo:xpath="default_db__x3A__TERYT_ulice:TERYT_ulice/SYM"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Opcjonalne dowiazanie sie do jakiegos adresu i zaciagniecie z niego danych lokalne</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element name="A_RECORD_CREATE_DATE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="A_RECORD_CREATE_AUTHOR"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="A_RECORD_UPDATE_DATE" minOccurs="0" type="p5Type:dateTime"/>
               <xs:element name="A_RECORD_UPDATE_AUTHOR"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="L_APPOITMENT_DATE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="L_APPOITMENT_USER"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <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:annotation>
               </xs:element>
               <xs:element name="L_APPOITMENT_PERIOD"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="L_APPOITMENT_INFO"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="L_APPOITMENT_TYPE"
                           minOccurs="0"
                           nillable="true"
                           default=""
                           type="xs:string"> </xs:element>
               <xs:element name="A_PROBLEM"
                           minOccurs="0"
                           nillable="true"
                           default=""
                           type="xs:string"> </xs:element>
               <xs:element name="A_PROBLEM_DESC"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="A_PROBLEM_DATE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="A_STATUS"
                           minOccurs="0"
                           nillable="true"
                           default="MONITOR"
                           type="default_db__x3A__BUILDINGS:A_STATUS_Type"> </xs:element>
               <xs:element name="A_STATUS_INFO"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="A_STATUS_LASTCHANGE_DATE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="A_UPDATE_DATE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="A_ADM_COMPANY"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="S_ADMIN_NAME"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="S_ADDRESS_CITY"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="S_ADDRESS_POST_CODE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="S_ADDRESS_POST_OFFICE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="S_ADDRESS_STREET"
                           minOccurs="0"
                           nillable="true"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="S_ADDRESS_STREET_FULL" minOccurs="0" type="p5Type:string"/>
               <xs:element name="S_ADDRESS_HOUSE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="S_OTHER_INFO"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_ADMIN_NAME"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_ADDRESS_CITY"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_ADDRESS_POST_CODE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_ADDRESS_POST_OFFICE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_ADDRESS_STREET"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_ADDRESS_HOUSE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_OTHER_INFO"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_DEAL_DATE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_DEALNUMBER"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_DEALEXPIRE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_DEAL_DETAIL"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_DEAL_LOCATION"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_NETWORK_SERVER"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_TOPOLOGY_PLACE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_BUILDING_SAVE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_BUILDING_POWER"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_INSTALACJA_W_CIAGU_DNI"
                           minOccurs="0"
                           nillable="true"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_WORKPOINTS" minOccurs="0" type="p5Type:string"/>
               <xs:element name="T_WORKPOINTS_VALUE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_WORKPOINTS_USER"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_WORKPOINTS_DATE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_WHO_CONNECTED"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_WHEN_CONNECTED"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_TEL_KONKURENCJA_OPER"
                           minOccurs="0"
                           nillable="true"
                           type="xs:string"> </xs:element>
               <xs:element name="T_TV_KONKURENCJA_OPER"
                           minOccurs="0"
                           nillable="true"
                           type="xs:string"> </xs:element>
               <xs:element name="T_LAN_KONKURENCJA_OPER"
                           minOccurs="0"
                           nillable="true"
                           type="default_db__x3A__BUILDINGS:T_LAN_KONKURENCJA_OPER_Type"/>
               <xs:element name="B_INVENTORY_DATE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="M_ZRYWKA_DATE"
                           minOccurs="0"
                           nillable="true"
                           type="p5Type:date"/>
               <xs:element name="M_ZRYWKA_NUMBER"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="M_REWIR" minOccurs="0" default="" type="p5Type:string"/>
               <xs:element ref="default_db__x3A__MK_Rewiry:MK_Rewiry">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="M_REWIR"
                                                         system_cache__appinfo:xpath="default_db__x3A__MK_Rewiry:MK_Rewiry/NAZWA_REWI"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #4122 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element name="M_PARAMETRY"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="M_DIST_OPTIONS"
                           minOccurs="0"
                           nillable="true"
                           type="xs:string"> </xs:element>
               <xs:element name="M_DIRECT_MARKETING_DATE"
                           minOccurs="0"
                           nillable="true"
                           type="p5Type:date"/>
               <xs:element name="M_DATA_ZASIEDLENIA"
                           minOccurs="0"
                           nillable="true"
                           type="p5Type:date"/>
               <xs:element name="ID_PROJECT"
                           minOccurs="0"
                           nillable="true"
                           type="p5Type:integer"/>
               <xs:element ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_PROJECT"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element name="path"
                           minOccurs="0"
                           nillable="true"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_NR_DZIALKI"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_NR_KW" minOccurs="0" default="" type="p5Type:string"/>
               <xs:element name="P_OTHER_DOC"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_PESEL" minOccurs="0" default="" type="p5Type:string"/>
               <xs:element name="P_KRS" minOccurs="0" default="" type="p5Type:string"/>
               <xs:element name="P_ADDRESS" minOccurs="0" default="" type="p5Type:string"/>
               <xs:element name="P_NAME" minOccurs="0" default="" type="p5Type:string"/>
               <xs:element name="P_ACCOUNT" minOccurs="0" type="p5Type:string"/>
               <xs:element name="P_OSIEDLE" minOccurs="0" default="" type="p5Type:string"/>
               <xs:element name="T_BUILDING_PIETRA" minOccurs="0" type="p5Type:integer"/>
               <xs:element name="T_BUILDING_PIWNICA"
                           minOccurs="0"
                           default="N/S;"
                           type="xs:string"> </xs:element>
               <xs:element name="T_BUILDING_KLATKI" minOccurs="0" type="p5Type:integer"/>
               <xs:element name="T_BUILDING_MIESZKANIA" minOccurs="0" type="p5Type:integer"/>
               <xs:element name="A_CLASSIFIED" minOccurs="0" type="p5Type:string"/>
               <xs:element name="M_LAST_STICKER_DATE"
                           minOccurs="0"
                           nillable="true"
                           type="p5Type:date"/>
               <xs:element name="the_geom"
                           minOccurs="0"
                           nillable="true"
                           type="p5Type:polygon"/>
               <xs:element name="SYNC_SQIX_STATUS" minOccurs="0" type="p5Type:string"/>
               <xs:element name="gid" minOccurs="0" nillable="true" type="p5Type:integer"/>
               <xs:element name="T_ADDRESS_CLASS"
                           minOccurs="0"
                           nillable="true"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="B_LINK"
                           minOccurs="0"
                           nillable="true"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="B_URL"
                           minOccurs="0"
                           nillable="true"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="B_XYZ"
                           minOccurs="0"
                           nillable="true"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="B_ASCII"
                           minOccurs="0"
                           nillable="true"
                           default=""
                           type="p5Type:text"/>
               <xs:element name="CRM_LISTA_ZASOBOW_ID" minOccurs="0" type="p5Type:integer"/>
               <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="CRM_LISTA_ZASOBOW_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element name="etykieta_x"
                           minOccurs="0"
                           nillable="true"
                           type="p5Type:decimal"/>
               <xs:element name="etykieta_y"
                           minOccurs="0"
                           nillable="true"
                           type="p5Type:decimal"/>
               <xs:element name="__Rozdzielcza_Kabel_Swiatlowodowy_wsg84"
                           minOccurs="0"
                           nillable="true"
                           type="p5Type:integer"/>
               <xs:element name="__MK_Rewiry__STATUS" minOccurs="0" type="p5Type:string"/>
               <xs:element name="ID_BILLING_USERS" minOccurs="0" type="p5Type:integer"/>
               <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS" minOccurs="0">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_BILLING_USERS"
                                                         system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element name="ID_BILLING_USERS_ADMIN" minOccurs="0" type="p5Type:integer"/>
               <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS_ADMIN" minOccurs="0">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_BILLING_USERS_ADMIN"
                                                         system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS_ADMIN/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element maxOccurs="unbounded"
                           minOccurs="0"
                           ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="S_ADDRESS_STREET"
                                                         system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING/T_TELBOX_BUILDING_IN"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Reff- backref jest od marketingu</xs:documentation>
                  </xs:annotation>
               </xs:element>
            </xs:sequence>
         </xs:restriction>
      </xs:complexContent>
   </xs:complexType>
   <xs:element name="Budynek_blok" type="default_db__x3A__BUILDINGS:Budynek_blok"/>
   <xs:complexType name="Dom_jednorodz">
      <xs:complexContent>
         <xs:restriction base="default_db__x3A__BUILDINGS:BUILDINGS">
            <xs:sequence>
               <xs:element name="ID" type="p5Type:integer"/>
               <xs:element name="geoportal_gml_punkty_adr_gml_id"
                           minOccurs="0"
                           type="p5Type:string"/>
               <xs:element name="TERYT_ulice" minOccurs="0" type="xs:int"/>
               <xs:element minOccurs="0" ref="default_db__x3A__TERYT_ulice:TERYT_ulice">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="TERYT_ulice"
                                                         system_cache__appinfo:xpath="default_db__x3A__TERYT_ulice:TERYT_ulice/SYM"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Opcjonalne dowiazanie sie do jakiegos adresu i zaciagniecie z niego danych lokalne</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element name="A_RECORD_CREATE_DATE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="A_RECORD_CREATE_AUTHOR"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="A_RECORD_UPDATE_DATE" minOccurs="0" type="p5Type:dateTime"/>
               <xs:element name="A_RECORD_UPDATE_AUTHOR"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="L_APPOITMENT_DATE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="L_APPOITMENT_USER"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <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:annotation>
               </xs:element>
               <xs:element name="L_APPOITMENT_PERIOD"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="L_APPOITMENT_INFO"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="A_PROBLEM_DESC"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="A_PROBLEM_DATE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="A_STATUS"
                           minOccurs="0"
                           nillable="true"
                           default="MONITOR"
                           type="default_db__x3A__BUILDINGS:A_STATUS_Type"/>
               <xs:element name="A_STATUS_INFO"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="A_STATUS_LASTCHANGE_DATE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="A_UPDATE_DATE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="A_ADM_COMPANY"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="S_ADMIN_NAME"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="S_ADDRESS_CITY"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="S_ADDRESS_POST_CODE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="S_ADDRESS_POST_OFFICE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="S_ADDRESS_STREET"
                           minOccurs="0"
                           nillable="true"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="S_ADDRESS_STREET_FULL" minOccurs="0" type="p5Type:string"/>
               <xs:element name="S_ADDRESS_HOUSE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="S_OTHER_INFO"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_ADMIN_NAME"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_ADDRESS_CITY"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_ADDRESS_POST_CODE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_ADDRESS_POST_OFFICE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_ADDRESS_STREET"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_ADDRESS_HOUSE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_OTHER_INFO"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_DEAL_DATE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_DEALNUMBER"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_DEALEXPIRE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_DEAL_DETAIL"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_DEAL_LOCATION"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_NETWORK_SERVER"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_TOPOLOGY_PLACE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_BUILDING_SAVE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_BUILDING_POWER"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_INSTALACJA_W_CIAGU_DNI"
                           minOccurs="0"
                           nillable="true"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_WORKPOINTS" minOccurs="0" type="p5Type:string"/>
               <xs:element name="T_WORKPOINTS_VALUE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_WORKPOINTS_USER"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_WORKPOINTS_DATE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_WHO_CONNECTED"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_WHEN_CONNECTED"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="T_LAN_KONKURENCJA_OPER"
                           minOccurs="0"
                           nillable="true"
                           type="default_db__x3A__BUILDINGS:T_LAN_KONKURENCJA_OPER_Type"/>
               <xs:element name="B_INVENTORY_DATE"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="M_ZRYWKA_DATE"
                           minOccurs="0"
                           nillable="true"
                           type="p5Type:date"/>
               <xs:element name="M_ZRYWKA_NUMBER"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="M_REWIR" minOccurs="0" default="" type="p5Type:string"/>
               <xs:element ref="default_db__x3A__MK_Rewiry:MK_Rewiry">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="M_REWIR"
                                                         system_cache__appinfo:xpath="default_db__x3A__MK_Rewiry:MK_Rewiry/NAZWA_REWI"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #4122 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element name="M_PARAMETRY"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="M_DIRECT_MARKETING_DATE"
                           minOccurs="0"
                           nillable="true"
                           type="p5Type:date"/>
               <xs:element name="M_DATA_ZASIEDLENIA"
                           minOccurs="0"
                           nillable="true"
                           type="p5Type:date"/>
               <xs:element name="ID_PROJECT"
                           minOccurs="0"
                           nillable="true"
                           type="p5Type:integer"/>
               <xs:element ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_PROJECT"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element name="path"
                           minOccurs="0"
                           nillable="true"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_NR_DZIALKI"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_NR_KW" minOccurs="0" default="" type="p5Type:string"/>
               <xs:element name="P_OTHER_DOC"
                           minOccurs="0"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="P_PESEL" minOccurs="0" default="" type="p5Type:string"/>
               <xs:element name="P_KRS" minOccurs="0" default="" type="p5Type:string"/>
               <xs:element name="P_ADDRESS" minOccurs="0" default="" type="p5Type:string"/>
               <xs:element name="P_NAME" minOccurs="0" default="" type="p5Type:string"/>
               <xs:element name="P_ACCOUNT" minOccurs="0" type="p5Type:string"/>
               <xs:element name="P_OSIEDLE" minOccurs="0" default="" type="p5Type:string"/>
               <xs:element name="T_BUILDING_PIETRA" minOccurs="0" type="p5Type:integer"/>
               <xs:element name="T_BUILDING_KLATKI" minOccurs="0" type="p5Type:integer"/>
               <xs:element name="T_BUILDING_MIESZKANIA" minOccurs="0" type="p5Type:integer"/>
               <xs:element name="A_CLASSIFIED" minOccurs="0" type="p5Type:string"/>
               <xs:element name="M_LAST_STICKER_DATE"
                           minOccurs="0"
                           nillable="true"
                           type="p5Type:date"/>
               <xs:element name="the_geom"
                           minOccurs="0"
                           nillable="true"
                           type="p5Type:polygon"/>
               <xs:element name="SYNC_SQIX_STATUS" minOccurs="0" type="p5Type:string"/>
               <xs:element name="gid" minOccurs="0" nillable="true" type="p5Type:integer"/>
               <xs:element name="T_ADDRESS_CLASS"
                           minOccurs="0"
                           nillable="true"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="B_LINK"
                           minOccurs="0"
                           nillable="true"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="B_URL"
                           minOccurs="0"
                           nillable="true"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="B_XYZ"
                           minOccurs="0"
                           nillable="true"
                           default=""
                           type="p5Type:string"/>
               <xs:element name="B_ASCII"
                           minOccurs="0"
                           nillable="true"
                           default=""
                           type="p5Type:text"/>
               <xs:element name="CRM_LISTA_ZASOBOW_ID" minOccurs="0" type="p5Type:integer"/>
               <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="CRM_LISTA_ZASOBOW_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element name="etykieta_x"
                           minOccurs="0"
                           nillable="true"
                           type="p5Type:decimal"/>
               <xs:element name="etykieta_y"
                           minOccurs="0"
                           nillable="true"
                           type="p5Type:decimal"/>
               <xs:element name="__Rozdzielcza_Kabel_Swiatlowodowy_wsg84"
                           minOccurs="0"
                           nillable="true"
                           type="p5Type:integer"/>
               <xs:element name="__MK_Rewiry__STATUS" minOccurs="0" type="p5Type:string"/>
               <xs:element name="ID_BILLING_USERS" minOccurs="0" type="p5Type:integer"/>
               <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS" minOccurs="0">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_BILLING_USERS"
                                                         system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element name="ID_BILLING_USERS_ADMIN" minOccurs="0" type="p5Type:integer"/>
               <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS_ADMIN" minOccurs="0">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_BILLING_USERS_ADMIN"
                                                         system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS_ADMIN/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element maxOccurs="unbounded"
                           minOccurs="0"
                           ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="S_ADDRESS_STREET"
                                                         system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING/T_TELBOX_BUILDING_IN"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Reff- backref jest od marketingu</xs:documentation>
                  </xs:annotation>
               </xs:element>
            </xs:sequence>
         </xs:restriction>
      </xs:complexContent>
   </xs:complexType>
   <xs:simpleType name="T_WORKPOINTS_TYPE_Type">
      <xs:restriction base="p5Type:string">
         <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
         <xs:enumeration value="OTHER"/>
         <xs:enumeration value="GUARANTY_SERVICE"/>
         <xs:enumeration value="ADMIN_AT_WORK"/>
         <xs:enumeration value="TECH_AT_DUTY"/>
         <xs:enumeration value="TECH_AT_CONTRACT"/>
      </xs:restriction>
   </xs:simpleType>
   <xs:simpleType name="T_BUILDING_TYPE_Type">
      <xs:restriction base="p5Type:string">
         <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
         <xs:enumeration value="N/S;"/>
         <xs:enumeration value="Domek_Jednorodzin."/>
         <xs:enumeration value="Domek_Wielorodz."/>
         <xs:enumeration value="Blok_Wielorodz"/>
         <xs:enumeration value="Obiekt_jedna_firma"/>
         <xs:enumeration value="Obiekt_wiele_firm"/>
      </xs:restriction>
   </xs:simpleType>
   <xs:simpleType name="T_LAN_KONKURENCJA_OPER_Type">
      <xs:restriction base="p5Type:string">
         <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
         <xs:enumeration value="NIEWIADOMO"/>
         <xs:enumeration value="BRAK"/>
         <xs:enumeration value="JEST"/>
         <xs:enumeration value="MA BYC"/>
      </xs:restriction>
   </xs:simpleType>
   <xs:simpleType name="A_STATUS_Type">
      <xs:restriction base="p5Type:string">
         <xs:enumeration value="WAITING"/>
         <xs:enumeration value="NORMAL"/>
         <xs:enumeration value="MONITOR"/>
         <xs:enumeration value="WARNING"/>
         <xs:enumeration value="OFF"/>
         <xs:enumeration value="TO_OFF"/>
         <xs:enumeration value="DELETED"/>
         <xs:enumeration value="OFF_SOFT"/>
         <xs:enumeration value="OFF_HARD"/>
      </xs:restriction>
   </xs:simpleType>
   <xs:element name="Dom_jednorodz" type="default_db__x3A__BUILDINGS:Dom_jednorodz"/>
   <xs:element name="T_TELBOX_BUILDING_IN" type="default_db__x3A__BUILDINGS:BUILDINGS">
      <xs:annotation>
         <xs:documentation>W telboxes uzywany do budowania struktury</xs:documentation>
      </xs:annotation>
   </xs:element>
</xs:schema>