| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272 |
- <?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" elementFormDefault="qualified"
- targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
- vc:minVersion="1.1"
- xmlns:default_db__x3A__TERYT_adresy="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_adresy.xsd">
- <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:complexType name="BUILDINGS" id="default_db__x3A__BUILDINGS___d13e10055-1_IN7_MK_B">
- <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 id="default_db__x3A__BUILDINGS___d13e10057-1">
- <xs:element name="ID" type="p5Type:integer"
- id="default_db__x3A__BUILDINGS___d13e10059-1_ID"/>
- <xs:element name="geoportal_gml_punkty_adr_gml_id" minOccurs="0" type="p5Type:string"/>
- <xs:element name="SIMC" minOccurs="0" type="p5Type:string"/>
- <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 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="">
- <xs:simpleType>
- <xs:restriction base="p5Type:string">
- <xs:enumeration value=""/>
- <xs:enumeration value="ARRANGED"/>
- <xs:enumeration value="TO_ARRANGE"/>
- <xs:enumeration value="CANCELLED"/>
- <xs:enumeration value="TO_CANCEL"/>
- <xs:enumeration value="RELATE"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="A_PROBLEM" minOccurs="0" nillable="true" default="">
- <xs:simpleType>
- <xs:restriction base="p5Type:string">
- <xs:enumeration value=""/>
- <xs:enumeration value="WARNING"/>
- <xs:enumeration value="PROBLEM"/>
- <xs:enumeration value="SERIOUS"/>
- <xs:enumeration value="UNVERIFIED"/>
- </xs:restriction>
- </xs:simpleType>
- </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">
- <xs:simpleType>
- <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>
- <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;">
- <xs:simpleType>
- <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:element>
- <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">
- <xs:simpleType>
- <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:element>
- <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">
- <xs:simpleType>
- <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:element>
- <xs:element name="T_TV_KONKURENCJA_OPER" minOccurs="0" nillable="true">
- <xs:simpleType>
- <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:element>
- <xs:element name="T_LAN_KONKURENCJA_OPER" minOccurs="0" nillable="true">
- <xs:simpleType>
- <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:element>
- <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 name="M_PARAMETRY" minOccurs="0" default="" type="p5Type:string"/>
- <xs:element name="M_DIST_OPTIONS" minOccurs="0" nillable="true">
- <xs:simpleType>
- <xs:restriction base="p5Type:string">
- <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value="TABLICA KOREK"/>
- <xs:enumeration value="TABLICA SZKLO KOREK"/>
- <xs:enumeration value="TABLICA SZKLO"/>
- <xs:enumeration value="BRAK MOZLIWOSCI"/>
- <xs:enumeration value="NIE WIADOMO"/>
- </xs:restriction>
- </xs:simpleType>
- </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 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;">
- <xs:simpleType>
- <xs:restriction base="p5Type:string">
- <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value="Y"/>
- <xs:enumeration value="N"/>
- <xs:enumeration value="N/S;"/>
- </xs:restriction>
- </xs:simpleType>
- </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 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 ref="default_db__x3A__COMPANIES:ID_BILLING_USERS" id="__BUILDINGS___d4e5124-1"
- minOccurs="0">
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source 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" minOccurs="0" type="p5Type:integer"/>
- <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS_ADMIN" minOccurs="0"/>
- <xs:element name="ID_BILLING_USERS_ADMIN" minOccurs="0" type="p5Type:integer"/>
- </xs:sequence>
- </xs:complexType>
- <xs:element name="BUILDINGS" type="default_db__x3A__BUILDINGS:BUILDINGS"
- id="default_db__x3A__BUILDINGS___d13e10252-1_IN7_MK_B"/>
- <xs:complexType id="default_db__x3A__BUILDINGS___d13e10055-1_CTBudynekBl" name="Budynek_blok">
- <xs:complexContent id="__BUILDINGS___d14e4329-1">
- <xs:extension base="default_db__x3A__BUILDINGS:BUILDINGS" id="__BUILDINGS___d14e4330-1"/>
- </xs:complexContent>
- </xs:complexType>
- <xs:element id="default_db__x3A__BUILDINGS___d13e10252-1_IN7BLOK" name="Budynek_blok"
- type="default_db__x3A__BUILDINGS:Budynek_blok"/>
- <xs:complexType id="default_db__x3A__BUILDINGS___d13e10252-1_INCTjednorodz" name="Dom_jednorodz">
- <xs:complexContent id="__BUILDINGS___d14e4333-1">
- <xs:extension base="default_db__x3A__BUILDINGS:BUILDINGS" id="__BUILDINGS___d14e4334-1"/>
- </xs:complexContent>
- </xs:complexType>
- <xs:element id="default_db__x3A__BUILDINGS___d13e10252-1_jednorodz" name="Dom_jednorodz"
- type="default_db__x3A__BUILDINGS:Dom_jednorodz"/>
- </xs:schema>
|