BUILDINGS.xsd 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
  3. xmlns:default_db__x3A__BUILDINGS="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
  4. xmlns:gml="http://www.opengis.net/gml/3.2"
  5. xmlns:default_db__x3A__COMPANIES="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
  6. xmlns:p5_tr_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"
  7. xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
  8. 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"
  9. xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
  10. xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types" elementFormDefault="qualified"
  11. targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
  12. vc:minVersion="1.1"
  13. xmlns:default_db__x3A__TERYT_adresy="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_adresy.xsd">
  14. <xs:import namespace="http://biuro.biall-net.pl/p5/schema/types"
  15. schemaLocation="../../../types.xsd"/>
  16. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
  17. schemaLocation="../../default_db.COMPANIES/COMPANIES/COMPANIES.xsd"/>
  18. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_adresy.xsd"
  19. schemaLocation="../../default_db.TERYT_adresy/TERYT_adresy/TERYT_adresy.xsd"/>
  20. <xs:complexType name="BUILDINGS" id="default_db__x3A__BUILDINGS___d13e10055-1_IN7_MK_B">
  21. <xs:annotation>
  22. <xs:appinfo>
  23. <system_cache__appinfo:heritage>
  24. <system_cache__appinfo:inherit system_cache__appinfo:inherit_ref="default_db:BUILDINGS" system_cache__appinfo:heritage_acl="true">
  25. <system_cache__appinfo:acl_rule_inherit_to_all_same_name_elements_and_refs/>
  26. <acl_rule_inherit_to_all_refs_by_primary/>
  27. <acl_rule_inherit_to_all_refs_by_local_element system_cache__appinfo:acl_rule_inherit_local_element_name="P_ID"/>
  28. </system_cache__appinfo:inherit>
  29. <system_cache__appinfo:exherit_all system_cache__appinfo:heritage_acl="true" system_cache__appinfo:heritage_sort="true"/>
  30. </system_cache__appinfo:heritage>
  31. </xs:appinfo>
  32. </xs:annotation>
  33. <xs:sequence id="default_db__x3A__BUILDINGS___d13e10057-1">
  34. <xs:element name="ID" type="p5Type:integer"
  35. id="default_db__x3A__BUILDINGS___d13e10059-1_ID"/>
  36. <xs:element name="geoportal_gml_punkty_adr_gml_id" minOccurs="0" type="p5Type:string"/>
  37. <xs:element name="SIMC" minOccurs="0" type="p5Type:string"/>
  38. <xs:element name="A_RECORD_CREATE_DATE" minOccurs="0" default="" type="p5Type:string"/>
  39. <xs:element name="A_RECORD_CREATE_AUTHOR" minOccurs="0" default="" type="p5Type:string"/>
  40. <xs:element name="A_RECORD_UPDATE_DATE" minOccurs="0" type="p5Type:dateTime"/>
  41. <xs:element name="A_RECORD_UPDATE_AUTHOR" minOccurs="0" default="" type="p5Type:string"/>
  42. <xs:element name="L_APPOITMENT_DATE" minOccurs="0" default="" type="p5Type:string"/>
  43. <xs:element name="L_APPOITMENT_USER" minOccurs="0" default="" type="p5Type:string"/>
  44. <xs:element name="L_APPOITMENT_PERIOD" minOccurs="0" default="" type="p5Type:string"/>
  45. <xs:element name="L_APPOITMENT_INFO" minOccurs="0" default="" type="p5Type:string"/>
  46. <xs:element name="L_APPOITMENT_TYPE" minOccurs="0" nillable="true" default="">
  47. <xs:simpleType>
  48. <xs:restriction base="p5Type:string">
  49. <xs:enumeration value=""/>
  50. <xs:enumeration value="ARRANGED"/>
  51. <xs:enumeration value="TO_ARRANGE"/>
  52. <xs:enumeration value="CANCELLED"/>
  53. <xs:enumeration value="TO_CANCEL"/>
  54. <xs:enumeration value="RELATE"/>
  55. </xs:restriction>
  56. </xs:simpleType>
  57. </xs:element>
  58. <xs:element name="A_PROBLEM" minOccurs="0" nillable="true" default="">
  59. <xs:simpleType>
  60. <xs:restriction base="p5Type:string">
  61. <xs:enumeration value=""/>
  62. <xs:enumeration value="WARNING"/>
  63. <xs:enumeration value="PROBLEM"/>
  64. <xs:enumeration value="SERIOUS"/>
  65. <xs:enumeration value="UNVERIFIED"/>
  66. </xs:restriction>
  67. </xs:simpleType>
  68. </xs:element>
  69. <xs:element name="A_PROBLEM_DESC" minOccurs="0" default="" type="p5Type:string"/>
  70. <xs:element name="A_PROBLEM_DATE" minOccurs="0" default="" type="p5Type:string"/>
  71. <xs:element name="A_STATUS" minOccurs="0" nillable="true" default="MONITOR">
  72. <xs:simpleType>
  73. <xs:restriction base="p5Type:string">
  74. <xs:enumeration value="WAITING"/>
  75. <xs:enumeration value="NORMAL"/>
  76. <xs:enumeration value="MONITOR"/>
  77. <xs:enumeration value="WARNING"/>
  78. <xs:enumeration value="OFF"/>
  79. <xs:enumeration value="TO_OFF"/>
  80. <xs:enumeration value="DELETED"/>
  81. <xs:enumeration value="OFF_SOFT"/>
  82. <xs:enumeration value="OFF_HARD"/>
  83. </xs:restriction>
  84. </xs:simpleType>
  85. </xs:element>
  86. <xs:element name="A_STATUS_INFO" minOccurs="0" default="" type="p5Type:string"/>
  87. <xs:element name="A_STATUS_LASTCHANGE_DATE" minOccurs="0" default="" type="p5Type:string"/>
  88. <xs:element name="A_UPDATE_DATE" minOccurs="0" default="" type="p5Type:string"/>
  89. <xs:element name="A_ADM_COMPANY" minOccurs="0" default="" type="p5Type:string"/>
  90. <xs:element name="S_ADMIN_NAME" minOccurs="0" default="" type="p5Type:string"/>
  91. <xs:element name="S_ADDRESS_CITY" minOccurs="0" default="" type="p5Type:string"/>
  92. <xs:element name="S_ADDRESS_POST_CODE" minOccurs="0" default="" type="p5Type:string"/>
  93. <xs:element name="S_ADDRESS_POST_OFFICE" minOccurs="0" default="" type="p5Type:string"/>
  94. <xs:element name="S_ADDRESS_STREET" minOccurs="0" nillable="true" default=""
  95. type="p5Type:string"/>
  96. <xs:element name="S_ADDRESS_STREET_FULL" minOccurs="0" type="p5Type:string"/>
  97. <xs:element name="S_ADDRESS_HOUSE" minOccurs="0" default="" type="p5Type:string"/>
  98. <xs:element name="S_OTHER_INFO" minOccurs="0" default="" type="p5Type:string"/>
  99. <xs:element name="P_ADMIN_NAME" minOccurs="0" default="" type="p5Type:string"/>
  100. <xs:element name="P_ADDRESS_CITY" minOccurs="0" default="" type="p5Type:string"/>
  101. <xs:element name="P_ADDRESS_POST_CODE" minOccurs="0" default="" type="p5Type:string"/>
  102. <xs:element name="P_ADDRESS_POST_OFFICE" minOccurs="0" default="" type="p5Type:string"/>
  103. <xs:element name="P_ADDRESS_STREET" minOccurs="0" default="" type="p5Type:string"/>
  104. <xs:element name="P_ADDRESS_HOUSE" minOccurs="0" default="" type="p5Type:string"/>
  105. <xs:element name="P_OTHER_INFO" minOccurs="0" default="" type="p5Type:string"/>
  106. <xs:element name="P_DEAL_DATE" minOccurs="0" default="" type="p5Type:string"/>
  107. <xs:element name="P_DEALNUMBER" minOccurs="0" default="" type="p5Type:string"/>
  108. <xs:element name="P_DEALEXPIRE" minOccurs="0" default="" type="p5Type:string"/>
  109. <xs:element name="P_DEAL_DETAIL" minOccurs="0" default="" type="p5Type:string"/>
  110. <xs:element name="P_DEAL_LOCATION" minOccurs="0" default="" type="p5Type:string"/>
  111. <xs:element name="T_NETWORK_SERVER" minOccurs="0" default="" type="p5Type:string"/>
  112. <xs:element name="T_TOPOLOGY_PLACE" minOccurs="0" default="" type="p5Type:string"/>
  113. <xs:element name="T_BUILDING_TYPE" minOccurs="0" default="N/S;">
  114. <xs:simpleType>
  115. <xs:restriction base="p5Type:string">
  116. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  117. <xs:enumeration value="N/S;"/>
  118. <xs:enumeration value="Domek_Jednorodzin."/>
  119. <xs:enumeration value="Domek_Wielorodz."/>
  120. <xs:enumeration value="Blok_Wielorodz"/>
  121. <xs:enumeration value="Obiekt_jedna_firma"/>
  122. <xs:enumeration value="Obiekt_wiele_firm"/>
  123. </xs:restriction>
  124. </xs:simpleType>
  125. </xs:element>
  126. <xs:element name="T_BUILDING_SAVE" minOccurs="0" default="" type="p5Type:string"/>
  127. <xs:element name="T_BUILDING_POWER" minOccurs="0" default="" type="p5Type:string"/>
  128. <xs:element name="T_INSTALACJA_W_CIAGU_DNI" minOccurs="0" nillable="true" default=""
  129. type="p5Type:string"/>
  130. <xs:element name="T_WORKPOINTS" minOccurs="0" type="p5Type:string"/>
  131. <xs:element name="T_WORKPOINTS_VALUE" minOccurs="0" default="" type="p5Type:string"/>
  132. <xs:element name="T_WORKPOINTS_TYPE" minOccurs="0" nillable="true">
  133. <xs:simpleType>
  134. <xs:restriction base="p5Type:string">
  135. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  136. <xs:enumeration value="OTHER"/>
  137. <xs:enumeration value="GUARANTY_SERVICE"/>
  138. <xs:enumeration value="ADMIN_AT_WORK"/>
  139. <xs:enumeration value="TECH_AT_DUTY"/>
  140. <xs:enumeration value="TECH_AT_CONTRACT"/>
  141. </xs:restriction>
  142. </xs:simpleType>
  143. </xs:element>
  144. <xs:element name="T_WORKPOINTS_USER" minOccurs="0" default="" type="p5Type:string"/>
  145. <xs:element name="T_WORKPOINTS_DATE" minOccurs="0" default="" type="p5Type:string"/>
  146. <xs:element name="T_WHO_CONNECTED" minOccurs="0" default="" type="p5Type:string"/>
  147. <xs:element name="T_WHEN_CONNECTED" minOccurs="0" default="" type="p5Type:string"/>
  148. <xs:element name="T_TEL_KONKURENCJA_OPER" minOccurs="0" nillable="true">
  149. <xs:simpleType>
  150. <xs:restriction base="p5Type:string">
  151. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  152. <xs:enumeration value="NIEWIADOMO"/>
  153. <xs:enumeration value="BRAK"/>
  154. <xs:enumeration value="JEST"/>
  155. <xs:enumeration value="MA BYC"/>
  156. </xs:restriction>
  157. </xs:simpleType>
  158. </xs:element>
  159. <xs:element name="T_TV_KONKURENCJA_OPER" minOccurs="0" nillable="true">
  160. <xs:simpleType>
  161. <xs:restriction base="p5Type:string">
  162. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  163. <xs:enumeration value="NIEWIADOMO"/>
  164. <xs:enumeration value="BRAK"/>
  165. <xs:enumeration value="JEST"/>
  166. <xs:enumeration value="MA BYC"/>
  167. </xs:restriction>
  168. </xs:simpleType>
  169. </xs:element>
  170. <xs:element name="T_LAN_KONKURENCJA_OPER" minOccurs="0" nillable="true">
  171. <xs:simpleType>
  172. <xs:restriction base="p5Type:string">
  173. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  174. <xs:enumeration value="NIEWIADOMO"/>
  175. <xs:enumeration value="BRAK"/>
  176. <xs:enumeration value="JEST"/>
  177. <xs:enumeration value="MA BYC"/>
  178. </xs:restriction>
  179. </xs:simpleType>
  180. </xs:element>
  181. <xs:element name="B_INVENTORY_DATE" minOccurs="0" default="" type="p5Type:string"/>
  182. <xs:element name="M_ZRYWKA_DATE" minOccurs="0" nillable="true" type="p5Type:date"/>
  183. <xs:element name="M_ZRYWKA_NUMBER" minOccurs="0" default="" type="p5Type:string"/>
  184. <xs:element name="M_REWIR" minOccurs="0" default="" type="p5Type:string"/>
  185. <xs:element name="M_PARAMETRY" minOccurs="0" default="" type="p5Type:string"/>
  186. <xs:element name="M_DIST_OPTIONS" minOccurs="0" nillable="true">
  187. <xs:simpleType>
  188. <xs:restriction base="p5Type:string">
  189. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  190. <xs:enumeration value="TABLICA KOREK"/>
  191. <xs:enumeration value="TABLICA SZKLO KOREK"/>
  192. <xs:enumeration value="TABLICA SZKLO"/>
  193. <xs:enumeration value="BRAK MOZLIWOSCI"/>
  194. <xs:enumeration value="NIE WIADOMO"/>
  195. </xs:restriction>
  196. </xs:simpleType>
  197. </xs:element>
  198. <xs:element name="M_DIRECT_MARKETING_DATE" minOccurs="0" nillable="true" type="p5Type:date"/>
  199. <xs:element name="M_DATA_ZASIEDLENIA" minOccurs="0" nillable="true" type="p5Type:date"/>
  200. <xs:element name="ID_PROJECT" minOccurs="0" nillable="true" type="p5Type:integer"/>
  201. <xs:element name="path" minOccurs="0" nillable="true" default="" type="p5Type:string"/>
  202. <xs:element name="P_NR_DZIALKI" minOccurs="0" default="" type="p5Type:string"/>
  203. <xs:element name="P_NR_KW" minOccurs="0" default="" type="p5Type:string"/>
  204. <xs:element name="P_OTHER_DOC" minOccurs="0" default="" type="p5Type:string"/>
  205. <xs:element name="P_PESEL" minOccurs="0" default="" type="p5Type:string"/>
  206. <xs:element name="P_KRS" minOccurs="0" default="" type="p5Type:string"/>
  207. <xs:element name="P_ADDRESS" minOccurs="0" default="" type="p5Type:string"/>
  208. <xs:element name="P_NAME" minOccurs="0" default="" type="p5Type:string"/>
  209. <xs:element name="P_ACCOUNT" minOccurs="0" type="p5Type:string"/>
  210. <xs:element name="P_OSIEDLE" minOccurs="0" default="" type="p5Type:string"/>
  211. <xs:element name="T_BUILDING_PIETRA" minOccurs="0" type="p5Type:integer"/>
  212. <xs:element name="T_BUILDING_PIWNICA" minOccurs="0" default="N/S;">
  213. <xs:simpleType>
  214. <xs:restriction base="p5Type:string">
  215. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  216. <xs:enumeration value="Y"/>
  217. <xs:enumeration value="N"/>
  218. <xs:enumeration value="N/S;"/>
  219. </xs:restriction>
  220. </xs:simpleType>
  221. </xs:element>
  222. <xs:element name="T_BUILDING_KLATKI" minOccurs="0" type="p5Type:integer"/>
  223. <xs:element name="T_BUILDING_MIESZKANIA" minOccurs="0" type="p5Type:integer"/>
  224. <xs:element name="A_CLASSIFIED" minOccurs="0" type="p5Type:string"/>
  225. <xs:element name="M_LAST_STICKER_DATE" minOccurs="0" nillable="true" type="p5Type:date"/>
  226. <xs:element name="the_geom" minOccurs="0" nillable="true" type="p5Type:polygon"/>
  227. <xs:element name="SYNC_SQIX_STATUS" minOccurs="0" type="p5Type:string"/>
  228. <xs:element name="gid" minOccurs="0" nillable="true" type="p5Type:integer"/>
  229. <xs:element name="T_ADDRESS_CLASS" minOccurs="0" nillable="true" default=""
  230. type="p5Type:string"/>
  231. <xs:element name="B_LINK" minOccurs="0" nillable="true" default="" type="p5Type:string"/>
  232. <xs:element name="B_URL" minOccurs="0" nillable="true" default="" type="p5Type:string"/>
  233. <xs:element name="B_XYZ" minOccurs="0" nillable="true" default="" type="p5Type:string"/>
  234. <xs:element name="B_ASCII" minOccurs="0" nillable="true" default="" type="p5Type:text"/>
  235. <xs:element name="CRM_LISTA_ZASOBOW_ID" minOccurs="0" type="p5Type:integer"/>
  236. <xs:element name="etykieta_x" minOccurs="0" nillable="true" type="p5Type:decimal"/>
  237. <xs:element name="etykieta_y" minOccurs="0" nillable="true" type="p5Type:decimal"/>
  238. <xs:element name="__Rozdzielcza_Kabel_Swiatlowodowy_wsg84" minOccurs="0" nillable="true"
  239. type="p5Type:integer"/>
  240. <xs:element name="__MK_Rewiry__STATUS" minOccurs="0" type="p5Type:string"/>
  241. <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS" id="__BUILDINGS___d4e5124-1"
  242. minOccurs="0">
  243. <xs:annotation>
  244. <xs:appinfo>
  245. <system_cache__appinfo:flat_relation_cache>
  246. <system_cache__appinfo:source system_cache__appinfo:name="ID_BILLING_USERS" system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
  247. </system_cache__appinfo:flat_relation_cache>
  248. </xs:appinfo>
  249. </xs:annotation>
  250. </xs:element>
  251. <xs:element name="ID_BILLING_USERS" minOccurs="0" type="p5Type:integer"/>
  252. <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS_ADMIN" minOccurs="0"/>
  253. <xs:element name="ID_BILLING_USERS_ADMIN" minOccurs="0" type="p5Type:integer"/>
  254. </xs:sequence>
  255. </xs:complexType>
  256. <xs:element name="BUILDINGS" type="default_db__x3A__BUILDINGS:BUILDINGS"
  257. id="default_db__x3A__BUILDINGS___d13e10252-1_IN7_MK_B"/>
  258. <xs:complexType id="default_db__x3A__BUILDINGS___d13e10055-1_CTBudynekBl" name="Budynek_blok">
  259. <xs:complexContent id="__BUILDINGS___d14e4329-1">
  260. <xs:extension base="default_db__x3A__BUILDINGS:BUILDINGS" id="__BUILDINGS___d14e4330-1"/>
  261. </xs:complexContent>
  262. </xs:complexType>
  263. <xs:element id="default_db__x3A__BUILDINGS___d13e10252-1_IN7BLOK" name="Budynek_blok"
  264. type="default_db__x3A__BUILDINGS:Budynek_blok"/>
  265. <xs:complexType id="default_db__x3A__BUILDINGS___d13e10252-1_INCTjednorodz" name="Dom_jednorodz">
  266. <xs:complexContent id="__BUILDINGS___d14e4333-1">
  267. <xs:extension base="default_db__x3A__BUILDINGS:BUILDINGS" id="__BUILDINGS___d14e4334-1"/>
  268. </xs:complexContent>
  269. </xs:complexType>
  270. <xs:element id="default_db__x3A__BUILDINGS___d13e10252-1_jednorodz" name="Dom_jednorodz"
  271. type="default_db__x3A__BUILDINGS:Dom_jednorodz"/>
  272. </xs:schema>