Dzialki.xsd 41 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
  3. xmlns:gml="http://www.opengis.net/gml/3.2"
  4. xmlns:Types__x3A__default_Infrastructure="https://biuro.biall-net.pl/wfs/default_db/Types/Infrastructure.xsd"
  5. xmlns:default_db__x3A__IN7_DZIENNIK_KORESP="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
  6. xmlns:hfp="http://www.w3.org/2001/XMLSchema-hasFacetAndProperty"
  7. xmlns:default_db__x3A__ADMIN_USERS="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
  8. xmlns:default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
  9. xmlns:SystemObjects__x3A__AccessGroup="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessGroup.xsd"
  10. xmlns:SystemObjects__x3A__AccessOwner="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessOwner.xsd"
  11. xmlns:default_db__x3A__CRM_LISTA_ZASOBOW="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW.xsd"
  12. xmlns:default_db__x3A__Dzialki="https://biuro.biall-net.pl/wfs/default_db/table/Dzialki.xsd"
  13. xmlns:default_db__x3A__COMPANIES="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
  14. xmlns:fix_se_defaultdb_schema="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/fix_se_defaultdb_schema/fix_se_defaultdb_schema.xsd"
  15. xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types"
  16. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  17. xmlns:p5_tr_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"
  18. xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
  19. 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"
  20. xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
  21. xmlns:p5opr="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/object_parent_relations/object_parent_relations.xsd"
  22. xmlns:p5_simpleSchema_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_simpleSchema_map.xsd"
  23. xmlns:ant-object="http://biuro.biall-net.pl/xmlschema_procesy5/ant-object/ant-object.xsd"
  24. xmlns:p5ant-interface="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/ant_interface/ant_interface.xsd"
  25. targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/Dzialki.xsd"
  26. vc:minVersion="1.1">
  27. <xs:import namespace="http://biuro.biall-net.pl/p5/schema/types"
  28. schemaLocation="../../../types.xsd"/>
  29. <xs:import namespace="http://www.opengis.net/gml/3.2"
  30. schemaLocation="http://www.opengis.net/gml/3.2"/>
  31. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
  32. schemaLocation="../../default_db.IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP.xsd"/>
  33. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
  34. schemaLocation="../../default_db.IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI.xsd"/>
  35. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
  36. schemaLocation="../../default_db.COMPANIES/COMPANIES/COMPANIES.xsd"/>
  37. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
  38. schemaLocation="../../default_db.ADMIN_USERS/ADMIN_USERS/ADMIN_USERS.xsd"/>
  39. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW.xsd"
  40. schemaLocation="../../default_db.CRM_LISTA_ZASOBOW/CRM_LISTA_ZASOBOW/CRM_LISTA_ZASOBOW.xsd"/>
  41. <xs:simpleType name="INWDZ__typ_dzialki" id="_3A__Dzialki___d18e10465-1_INWDZ__typ">
  42. <xs:restriction base="xs:string">
  43. <xs:enumeration value=""/>
  44. <xs:enumeration value="DROGA"/>
  45. <xs:enumeration value="PRYWATNA"/>
  46. <xs:enumeration value="LAS"/>
  47. <xs:enumeration value="CIEK"/>
  48. <xs:enumeration value="INNE"/>
  49. <xs:enumeration value="PKP"/>
  50. <xs:enumeration value="AGENCJA ROLNA"/>
  51. <xs:enumeration value="SPÓŁDZIELNIA"/>
  52. <xs:enumeration value="GMINNA"/>
  53. <xs:enumeration value="POWIATOWA"/>
  54. <xs:enumeration value="WOJEWÓDZKA"/>
  55. </xs:restriction>
  56. </xs:simpleType>
  57. <xs:complexType name="Dzialki"
  58. system_cache__appinfo:primaryKey="ID"
  59. id="_3A__Dzialki___d18e10480-1_Dzialki"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  60. <xs:annotation>
  61. <xs:appinfo>
  62. <system_cache__appinfo:heritage>
  63. <system_cache__appinfo:inherit system_cache__appinfo:inherit_ref="default_db:Dzialki"
  64. system_cache__appinfo:heritage_acl="true">
  65. <system_cache__appinfo:acl_rule_inherit_to_all_same_name_elements_and_refs/>
  66. <acl_rule_inherit_to_all_refs_by_primary/>
  67. <acl_rule_inherit_to_all_refs_by_local_element system_cache__appinfo:acl_rule_inherit_local_element_name="A_STATUS"/>
  68. </system_cache__appinfo:inherit>
  69. <system_cache__appinfo:exherit_all system_cache__appinfo:heritage_acl="true"
  70. system_cache__appinfo:heritage_sort="true"/>
  71. </system_cache__appinfo:heritage>
  72. </xs:appinfo>
  73. <xs:documentation>Instancyjny - Protopyowy obiekt, który powinien mieć typy konkretnych
  74. rodzaji dla różnych technologii. Podzielony z uwagi na stany projektowania oraz
  75. realizacji. </xs:documentation>
  76. </xs:annotation>
  77. <xs:sequence id="_3A__Dzialki___d18e10491-1">
  78. <xs:element name="ID" type="xs:int" id="_3A__Dzialki___d18e10492-1_ID"/>
  79. <xs:element name="the_geom"
  80. type="p5Type:polygon"
  81. id="_3A__Dzialki___d18e10493-1_the_geom"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  82. <xs:annotation>
  83. <xs:documentation>Dane geograficzne obiektu - linia, punkt,
  84. polygon
  85. KONIECZNIE UZUPELNIONE</xs:documentation>
  86. </xs:annotation>
  87. </xs:element>
  88. <xs:element minOccurs="0"
  89. name="A_STATUS_INFO"
  90. type="xs:string"
  91. id="_3A__Dzialki___d18e10497-1_A_STATUS_I"/>
  92. <xs:element minOccurs="0"
  93. name="opis"
  94. type="xs:string"
  95. id="_3A__Dzialki___d18e10498-1_opis"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  96. <xs:annotation>
  97. <xs:documentation>To zmiany na ID_ZASOBU pod katem kosztorysowym</xs:documentation>
  98. </xs:annotation>
  99. </xs:element>
  100. <xs:element minOccurs="0"
  101. name="ID_ZASOB"
  102. type="xs:int"
  103. id="_3A__Dzialki___d18e10502-1_ID_ZASOB"/>
  104. <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:ID_ZASOB"
  105. minOccurs="0"
  106. id="_3A__Dzialki___d18e10503-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  107. <xs:annotation>
  108. <xs:appinfo>
  109. <system_cache__appinfo:flat_relation_cache>
  110. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  111. system_cache__appinfo:name="ID_ZASOB"
  112. system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:ID_ZASOB/ID"/>
  113. </system_cache__appinfo:flat_relation_cache>
  114. </xs:appinfo>
  115. <xs:documentation>
  116. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #51112 !!!
  117. </xs:documentation>
  118. </xs:annotation>
  119. </xs:element>
  120. <xs:element minOccurs="0"
  121. name="Dlugosc"
  122. type="xs:double"
  123. id="_3A__Dzialki___d18e10510-1_Dlugosc"/>
  124. <xs:element minOccurs="0"
  125. name="Powierzchnia"
  126. type="xs:double"
  127. id="_3A__Dzialki___d18e10511-1_Powierzchn"/>
  128. <xs:element minOccurs="0"
  129. name="L_APPOITMENT_USER"
  130. type="xs:string"
  131. id="_3A__Dzialki___d18e10512-1_L_APPOITME"/>
  132. <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
  133. minOccurs="0"
  134. id="_3A__Dzialki___d18e10513-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  135. <xs:annotation>
  136. <xs:appinfo>
  137. <system_cache__appinfo:flat_relation_cache>
  138. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  139. system_cache__appinfo:name="L_APPOITMENT_USER"
  140. system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
  141. </system_cache__appinfo:flat_relation_cache>
  142. </xs:appinfo>
  143. <xs:documentation>
  144. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
  145. </xs:documentation>
  146. </xs:annotation>
  147. </xs:element>
  148. <!--<xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner" id="cza_Dzialki___d4e6454-1">
  149. <xs:annotation>
  150. <xs:appinfo>
  151. <system_cache__appinfo:flat_relation_cache>
  152. <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER" system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/name"/>
  153. </system_cache__appinfo:flat_relation_cache>
  154. </xs:appinfo>
  155. </xs:annotation>
  156. </xs:element>-->
  157. <xs:element minOccurs="0"
  158. name="A_CLASSIFIED"
  159. type="xs:string"
  160. id="_3A__Dzialki___d18e10522-1_A_CLASSIFI"/>
  161. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
  162. id="cza_Dzialki___d4e6461-1">
  163. <xs:annotation>
  164. <xs:appinfo>
  165. <system_cache__appinfo:flat_relation_cache>
  166. <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
  167. </system_cache__appinfo:flat_relation_cache>
  168. </xs:appinfo>
  169. </xs:annotation>
  170. </xs:element>-->
  171. <xs:element minOccurs="0"
  172. name="A_ADM_COMPANY"
  173. type="xs:string"
  174. id="_3A__Dzialki___d18e10524-1_A_ADM_COMP"/>
  175. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
  176. id="cza_Dzialki___d4e6467-1">
  177. <xs:annotation>
  178. <xs:appinfo>
  179. <system_cache__appinfo:flat_relation_cache>
  180. <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
  181. </system_cache__appinfo:flat_relation_cache>
  182. </xs:appinfo>
  183. </xs:annotation>
  184. </xs:element>-->
  185. <xs:element minOccurs="0"
  186. name="ID_PROJECT"
  187. type="xs:int"
  188. id="_3A__Dzialki___d18e10526-1_ID_PROJECT"/>
  189. <xs:element ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT"
  190. minOccurs="0"
  191. id="_3A__Dzialki___d18e10527-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  192. <xs:annotation>
  193. <xs:appinfo>
  194. <system_cache__appinfo:flat_relation_cache>
  195. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  196. system_cache__appinfo:name="ID_PROJECT"
  197. system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT/ID"/>
  198. </system_cache__appinfo:flat_relation_cache>
  199. </xs:appinfo>
  200. <xs:documentation>
  201. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #204
  202. </xs:documentation>
  203. </xs:annotation>
  204. </xs:element>
  205. <xs:element minOccurs="0"
  206. name="ID_BILLING_USERS"
  207. type="xs:int"
  208. id="_3A__Dzialki___d18e10534-1_ID_BILLING"/>
  209. <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS"
  210. minOccurs="0"
  211. id="_3A__Dzialki___d18e10535-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  212. <xs:annotation>
  213. <xs:appinfo>
  214. <system_cache__appinfo:flat_relation_cache>
  215. <system_cache__appinfo:source system_cache__appinfo:name="ID_BILLING_USERS"
  216. system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
  217. </system_cache__appinfo:flat_relation_cache>
  218. </xs:appinfo>
  219. </xs:annotation>
  220. </xs:element>
  221. <xs:element minOccurs="0"
  222. name="IDENTYFIKATOR"
  223. type="xs:string"
  224. id="_3A__Dzialki___d18e10540-1_IDENTYFIKA"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  225. <xs:annotation>
  226. <xs:documentation>e.g. 220405_2.0003.AR_2.94/2</xs:documentation>
  227. </xs:annotation>
  228. </xs:element>
  229. <xs:element minOccurs="0"
  230. name="OBREB"
  231. type="xs:string"
  232. id="_3A__Dzialki___d18e10544-1_OBREB"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  233. <xs:annotation>
  234. <xs:documentation>e.g. Ostrołęka</xs:documentation>
  235. </xs:annotation>
  236. </xs:element>
  237. <xs:element minOccurs="0"
  238. name="NUMER"
  239. type="xs:string"
  240. id="_3A__Dzialki___d18e10548-1_NUMER"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  241. <xs:annotation>
  242. <xs:documentation>e.g. 94/2</xs:documentation>
  243. </xs:annotation>
  244. </xs:element>
  245. <xs:element minOccurs="0"
  246. name="P_NAME"
  247. type="xs:string"
  248. id="_3A__Dzialki___d18e10553-1_P_NAME"/>
  249. <xs:element minOccurs="0"
  250. name="P_NAME_SECOND"
  251. type="xs:string"
  252. id="_3A__Dzialki___d18e10554-1_P_NAME_SEC"/>
  253. <xs:element minOccurs="0"
  254. name="P_NIP"
  255. type="xs:string"
  256. id="_3A__Dzialki___d18e10555-1_P_NIP"/>
  257. <xs:element minOccurs="0"
  258. name="P_PESEL"
  259. type="xs:string"
  260. id="_3A__Dzialki___d18e10556-1_P_PESEL"/>
  261. <xs:element minOccurs="0"
  262. name="P_OTHER_DOC"
  263. type="xs:string"
  264. id="_3A__Dzialki___d18e10557-1_P_OTHER_DO"/>
  265. <xs:element minOccurs="0"
  266. name="P_PHONE"
  267. type="xs:string"
  268. id="_3A__Dzialki___d18e10558-1_P_PHONE"/>
  269. <xs:element minOccurs="0"
  270. name="P_ADDRESS"
  271. type="xs:string"
  272. id="_3A__Dzialki___d18e10559-1_P_ADDRESS"/>
  273. <xs:element name="INWDZ__typ_dzialki"
  274. minOccurs="0"
  275. type="default_db__x3A__Dzialki:INWDZ__typ_dzialki"
  276. id="_3A__Dzialki___d18e10560-1_INWDZ__typ"/>
  277. </xs:sequence>
  278. <xs:assert test="P_NAME = default_db__x3A__COMPANIES:ID_BILLING_USERS/P_NAME"
  279. id="_3A__Dzialki___d18e10561-1"/>
  280. <xs:assert test="P_NAME_SECOND = default_db__x3A__COMPANIES:ID_BILLING_USERS/P_NAME_SECOND"
  281. id="_3A__Dzialki___d18e10562-1"/>
  282. <xs:assert test="P_NIP = default_db__x3A__COMPANIES:ID_BILLING_USERS/P_NIP"
  283. id="_3A__Dzialki___d18e10563-1"/>
  284. <xs:assert test="P_PESEL = default_db__x3A__COMPANIES:ID_BILLING_USERS/P_PESEL"
  285. id="_3A__Dzialki___d18e10564-1"/>
  286. <xs:assert test="P_OTHER_DOC = default_db__x3A__COMPANIES:ID_BILLING_USERS"
  287. id="_3A__Dzialki___d18e10565-1"/>
  288. <xs:assert test="P_PHONE = default_db__x3A__COMPANIES:ID_BILLING_USERS/P_PHONE"
  289. id="_3A__Dzialki___d18e10566-1"/>
  290. <xs:assert test="P_ADDRESS = default_db__x3A__COMPANIES:ID_BILLING_USERS/concat(P_ADDRESS_POST_CODE, ' ', P_ADDRESS_CITY, ' ', P_ADDRESS_STREET, ' ', P_ADDRESS_HOME, '/', P_ADDRESS_HOUSE)"
  291. id="_3A__Dzialki___d18e10567-1"/>
  292. </xs:complexType>
  293. <xs:element name="Dzialki"
  294. type="default_db__x3A__Dzialki:Dzialki"
  295. id="_3A__Dzialki___d18e10568-1_Dzialki"/>
  296. <xs:complexType name="Dzialki_Known"
  297. system_cache__appinfo:primaryKey="ID"
  298. id="_3A__Dzialki___d18e10569-1_Dzialki_Kn">
  299. <xs:complexContent id="_3A__Dzialki___d18e10570-1">
  300. <xs:restriction base="default_db__x3A__Dzialki:Dzialki">
  301. <xs:sequence id="_3A__Dzialki___d18e10572-1">
  302. <xs:element name="ID" type="xs:int" id="_3A__Dzialki___d18e10573-1_ID"/>
  303. <xs:element name="the_geom"
  304. type="p5Type:polygon"
  305. id="_3A__Dzialki___d18e10574-1_the_geom"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  306. <xs:annotation>
  307. <xs:documentation>Dane geograficzne obiektu - linia, punkt,
  308. polygon</xs:documentation>
  309. </xs:annotation>
  310. </xs:element>
  311. <xs:element minOccurs="0"
  312. name="A_STATUS_INFO"
  313. type="xs:string"
  314. id="_3A__Dzialki___d18e10578-1_A_STATUS_I"/>
  315. <xs:element minOccurs="0"
  316. name="opis"
  317. type="xs:string"
  318. id="_3A__Dzialki___d18e10579-1_opis"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  319. <xs:annotation>
  320. <xs:documentation>To zmiany na ID_ZASOBU pod katem kosztorysowym</xs:documentation>
  321. </xs:annotation>
  322. </xs:element>
  323. <xs:element minOccurs="0"
  324. name="ID_ZASOB"
  325. type="xs:int"
  326. id="_3A__Dzialki___d18e10583-1_ID_ZASOB"/>
  327. <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:ID_ZASOB"
  328. minOccurs="0"
  329. id="_3A__Dzialki___d18e10584-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  330. <xs:annotation>
  331. <xs:appinfo>
  332. <system_cache__appinfo:flat_relation_cache>
  333. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  334. system_cache__appinfo:name="ID_ZASOB"
  335. system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:ID_ZASOB/ID"/>
  336. </system_cache__appinfo:flat_relation_cache>
  337. </xs:appinfo>
  338. <xs:documentation>
  339. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #51112 !!!
  340. </xs:documentation>
  341. </xs:annotation>
  342. </xs:element>
  343. <xs:element minOccurs="0"
  344. name="Dlugosc"
  345. type="xs:double"
  346. id="_3A__Dzialki___d18e10591-1_Dlugosc"/>
  347. <xs:element minOccurs="0"
  348. name="Powierzchnia"
  349. type="xs:double"
  350. id="_3A__Dzialki___d18e10592-1_Powierzchn"/>
  351. <xs:element minOccurs="0"
  352. name="L_APPOITMENT_USER"
  353. type="xs:string"
  354. id="_3A__Dzialki___d18e10593-1_L_APPOITME"/>
  355. <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
  356. minOccurs="0"
  357. id="_3A__Dzialki___d18e10594-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  358. <xs:annotation>
  359. <xs:appinfo>
  360. <system_cache__appinfo:flat_relation_cache>
  361. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  362. system_cache__appinfo:name="L_APPOITMENT_USER"
  363. system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
  364. </system_cache__appinfo:flat_relation_cache>
  365. </xs:appinfo>
  366. <xs:documentation>
  367. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
  368. </xs:documentation>
  369. </xs:annotation>
  370. </xs:element>
  371. <!--<xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner" id="cza_Dzialki___d4e6454-1">
  372. <xs:annotation>
  373. <xs:appinfo>
  374. <system_cache__appinfo:flat_relation_cache>
  375. <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER" system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/name"/>
  376. </system_cache__appinfo:flat_relation_cache>
  377. </xs:appinfo>
  378. </xs:annotation>
  379. </xs:element>-->
  380. <xs:element minOccurs="0"
  381. name="A_CLASSIFIED"
  382. type="xs:string"
  383. id="_3A__Dzialki___d18e10603-1_A_CLASSIFI"/>
  384. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
  385. id="cza_Dzialki___d4e6461-1">
  386. <xs:annotation>
  387. <xs:appinfo>
  388. <system_cache__appinfo:flat_relation_cache>
  389. <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
  390. </system_cache__appinfo:flat_relation_cache>
  391. </xs:appinfo>
  392. </xs:annotation>
  393. </xs:element>-->
  394. <xs:element minOccurs="0"
  395. name="A_ADM_COMPANY"
  396. type="xs:string"
  397. id="_3A__Dzialki___d18e10605-1_A_ADM_COMP"/>
  398. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
  399. id="cza_Dzialki___d4e6467-1">
  400. <xs:annotation>
  401. <xs:appinfo>
  402. <system_cache__appinfo:flat_relation_cache>
  403. <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
  404. </system_cache__appinfo:flat_relation_cache>
  405. </xs:appinfo>
  406. </xs:annotation>
  407. </xs:element>-->
  408. <xs:element minOccurs="0"
  409. name="ID_PROJECT"
  410. type="xs:int"
  411. id="_3A__Dzialki___d18e10607-1_ID_PROJECT"/>
  412. <xs:element ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT"
  413. minOccurs="0"
  414. id="_3A__Dzialki___d18e10608-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  415. <xs:annotation>
  416. <xs:appinfo>
  417. <system_cache__appinfo:flat_relation_cache>
  418. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  419. system_cache__appinfo:name="ID_PROJECT"
  420. system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT/ID"/>
  421. </system_cache__appinfo:flat_relation_cache>
  422. </xs:appinfo>
  423. <xs:documentation>
  424. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #204
  425. </xs:documentation>
  426. </xs:annotation>
  427. </xs:element>
  428. <xs:element minOccurs="1"
  429. name="ID_BILLING_USERS"
  430. type="xs:int"
  431. id="_3A__Dzialki___d18e10615-1_ID_BILLING"/>
  432. <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS"
  433. minOccurs="1"
  434. id="_3A__Dzialki___d18e10616-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  435. <xs:annotation>
  436. <xs:appinfo>
  437. <system_cache__appinfo:flat_relation_cache>
  438. <system_cache__appinfo:source system_cache__appinfo:name="ID_BILLING_USERS"
  439. system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
  440. </system_cache__appinfo:flat_relation_cache>
  441. </xs:appinfo>
  442. </xs:annotation>
  443. </xs:element>
  444. <xs:element minOccurs="0"
  445. name="IDENTYFIKATOR"
  446. type="xs:string"
  447. id="_3A__Dzialki___d18e10621-1_IDENTYFIKA"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  448. <xs:annotation>
  449. <xs:documentation>e.g. 220405_2.0003.AR_2.94/2</xs:documentation>
  450. </xs:annotation>
  451. </xs:element>
  452. <xs:element minOccurs="1"
  453. name="OBREB"
  454. type="xs:string"
  455. id="_3A__Dzialki___d18e10625-1_OBREB"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  456. <xs:annotation>
  457. <xs:documentation>e.g. Ostrołęka</xs:documentation>
  458. </xs:annotation>
  459. </xs:element>
  460. <xs:element minOccurs="1"
  461. name="NUMER"
  462. type="xs:string"
  463. id="_3A__Dzialki___d18e10629-1_NUMER"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  464. <xs:annotation>
  465. <xs:documentation>e.g. 94/2</xs:documentation>
  466. </xs:annotation>
  467. </xs:element>
  468. <xs:element minOccurs="0"
  469. name="P_NAME"
  470. type="xs:string"
  471. id="_3A__Dzialki___d18e10634-1_P_NAME"/>
  472. <xs:element minOccurs="1"
  473. name="P_NAME_SECOND"
  474. type="xs:string"
  475. id="_3A__Dzialki___d18e10635-1_P_NAME_SEC"/>
  476. <xs:element minOccurs="0"
  477. name="P_NIP"
  478. type="xs:string"
  479. id="_3A__Dzialki___d18e10636-1_P_NIP"/>
  480. <xs:element minOccurs="0"
  481. name="P_PESEL"
  482. type="xs:string"
  483. id="_3A__Dzialki___d18e10637-1_P_PESEL"/>
  484. <xs:element minOccurs="0"
  485. name="P_OTHER_DOC"
  486. type="xs:string"
  487. id="_3A__Dzialki___d18e10638-1_P_OTHER_DO"/>
  488. <xs:element minOccurs="0"
  489. name="P_PHONE"
  490. type="xs:string"
  491. id="_3A__Dzialki___d18e10639-1_P_PHONE"/>
  492. <xs:element minOccurs="1"
  493. name="P_ADDRESS"
  494. type="xs:string"
  495. id="_3A__Dzialki___d18e10640-1_P_ADDRESS"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  496. <xs:annotation>
  497. <xs:documentation>assert - concat adresu</xs:documentation>
  498. </xs:annotation>
  499. </xs:element>
  500. <xs:element name="INWDZ__typ_dzialki"
  501. minOccurs="0"
  502. type="default_db__x3A__Dzialki:INWDZ__typ_dzialki"
  503. id="_3A__Dzialki___d18e10644-1_INWDZ__typ"/>
  504. </xs:sequence>
  505. </xs:restriction>
  506. </xs:complexContent>
  507. </xs:complexType>
  508. <xs:element name="Dzialki_Known"
  509. type="default_db__x3A__Dzialki:Dzialki_Known"
  510. id="_3A__Dzialki___d18e10646-1_Dzialki_Kn"/>
  511. <xs:complexType name="Dzialki_Unknown"
  512. system_cache__appinfo:primaryKey="ID"
  513. id="_3A__Dzialki___d18e10647-1_Dzialki_Un">
  514. <xs:complexContent id="_3A__Dzialki___d18e10648-1">
  515. <xs:restriction base="default_db__x3A__Dzialki:Dzialki">
  516. <xs:sequence id="_3A__Dzialki___d18e10650-1">
  517. <xs:element name="ID" type="xs:int" id="_3A__Dzialki___d18e10651-1_ID"/>
  518. <xs:element name="the_geom"
  519. type="p5Type:polygon"
  520. id="_3A__Dzialki___d18e10652-1_the_geom"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  521. <xs:annotation>
  522. <xs:documentation>Dane geograficzne obiektu - linia, punkt,
  523. polygon</xs:documentation>
  524. </xs:annotation>
  525. </xs:element>
  526. <xs:element minOccurs="0"
  527. name="A_STATUS_INFO"
  528. type="xs:string"
  529. id="_3A__Dzialki___d18e10656-1_A_STATUS_I"/>
  530. <xs:element minOccurs="0"
  531. name="opis"
  532. type="xs:string"
  533. id="_3A__Dzialki___d18e10657-1_opis"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  534. <xs:annotation>
  535. <xs:documentation>To zmiany na ID_ZASOBU pod katem kosztorysowym</xs:documentation>
  536. </xs:annotation>
  537. </xs:element>
  538. <xs:element minOccurs="0"
  539. name="ID_ZASOB"
  540. type="xs:int"
  541. id="_3A__Dzialki___d18e10661-1_ID_ZASOB"/>
  542. <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:ID_ZASOB"
  543. minOccurs="0"
  544. id="_3A__Dzialki___d18e10662-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  545. <xs:annotation>
  546. <xs:appinfo>
  547. <system_cache__appinfo:flat_relation_cache>
  548. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  549. system_cache__appinfo:name="ID_ZASOB"
  550. system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:ID_ZASOB/ID"/>
  551. </system_cache__appinfo:flat_relation_cache>
  552. </xs:appinfo>
  553. <xs:documentation>
  554. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #51112 !!!
  555. </xs:documentation>
  556. </xs:annotation>
  557. </xs:element>
  558. <xs:element minOccurs="0"
  559. name="Dlugosc"
  560. type="xs:double"
  561. id="_3A__Dzialki___d18e10669-1_Dlugosc"/>
  562. <xs:element minOccurs="0"
  563. name="Powierzchnia"
  564. type="xs:double"
  565. id="_3A__Dzialki___d18e10670-1_Powierzchn"/>
  566. <xs:element minOccurs="0"
  567. name="L_APPOITMENT_USER"
  568. type="xs:string"
  569. id="_3A__Dzialki___d18e10671-1_L_APPOITME"/>
  570. <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
  571. minOccurs="0"
  572. id="_3A__Dzialki___d18e10672-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  573. <xs:annotation>
  574. <xs:appinfo>
  575. <system_cache__appinfo:flat_relation_cache>
  576. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  577. system_cache__appinfo:name="L_APPOITMENT_USER"
  578. system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
  579. </system_cache__appinfo:flat_relation_cache>
  580. </xs:appinfo>
  581. <xs:documentation>
  582. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
  583. </xs:documentation>
  584. </xs:annotation>
  585. </xs:element>
  586. <!--<xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner" id="cza_Dzialki___d4e6454-1">
  587. <xs:annotation>
  588. <xs:appinfo>
  589. <system_cache__appinfo:flat_relation_cache>
  590. <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER" system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/name"/>
  591. </system_cache__appinfo:flat_relation_cache>
  592. </xs:appinfo>
  593. </xs:annotation>
  594. </xs:element>-->
  595. <xs:element minOccurs="0"
  596. name="A_CLASSIFIED"
  597. type="xs:string"
  598. id="_3A__Dzialki___d18e10681-1_A_CLASSIFI"/>
  599. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
  600. id="cza_Dzialki___d4e6461-1">
  601. <xs:annotation>
  602. <xs:appinfo>
  603. <system_cache__appinfo:flat_relation_cache>
  604. <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
  605. </system_cache__appinfo:flat_relation_cache>
  606. </xs:appinfo>
  607. </xs:annotation>
  608. </xs:element>-->
  609. <xs:element minOccurs="0"
  610. name="A_ADM_COMPANY"
  611. type="xs:string"
  612. id="_3A__Dzialki___d18e10683-1_A_ADM_COMP"/>
  613. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
  614. id="cza_Dzialki___d4e6467-1">
  615. <xs:annotation>
  616. <xs:appinfo>
  617. <system_cache__appinfo:flat_relation_cache>
  618. <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
  619. </system_cache__appinfo:flat_relation_cache>
  620. </xs:appinfo>
  621. </xs:annotation>
  622. </xs:element>-->
  623. <xs:element minOccurs="0"
  624. name="ID_PROJECT"
  625. type="xs:int"
  626. id="_3A__Dzialki___d18e10685-1_ID_PROJECT"/>
  627. <xs:element ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT"
  628. minOccurs="0"
  629. id="_3A__Dzialki___d18e10686-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  630. <xs:annotation>
  631. <xs:appinfo>
  632. <system_cache__appinfo:flat_relation_cache>
  633. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  634. system_cache__appinfo:name="ID_PROJECT"
  635. system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT/ID"/>
  636. </system_cache__appinfo:flat_relation_cache>
  637. </xs:appinfo>
  638. <xs:documentation>
  639. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #204
  640. </xs:documentation>
  641. </xs:annotation>
  642. </xs:element>
  643. <xs:element minOccurs="1"
  644. name="ID_BILLING_USERS"
  645. type="xs:int"
  646. id="_3A__Dzialki___d18e10693-1_ID_BILLING"/>
  647. <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS"
  648. minOccurs="1"
  649. id="_3A__Dzialki___d18e10694-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  650. <xs:annotation>
  651. <xs:appinfo>
  652. <system_cache__appinfo:flat_relation_cache>
  653. <system_cache__appinfo:source system_cache__appinfo:name="ID_BILLING_USERS"
  654. system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
  655. </system_cache__appinfo:flat_relation_cache>
  656. </xs:appinfo>
  657. </xs:annotation>
  658. </xs:element>
  659. <xs:element minOccurs="0"
  660. name="IDENTYFIKATOR"
  661. type="xs:string"
  662. id="_3A__Dzialki___d18e10699-1_IDENTYFIKA"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  663. <xs:annotation>
  664. <xs:documentation>e.g. 220405_2.0003.AR_2.94/2</xs:documentation>
  665. </xs:annotation>
  666. </xs:element>
  667. <xs:element minOccurs="1"
  668. name="OBREB"
  669. type="xs:string"
  670. id="_3A__Dzialki___d18e10703-1_OBREB"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  671. <xs:annotation>
  672. <xs:documentation>e.g. Ostrołęka</xs:documentation>
  673. </xs:annotation>
  674. </xs:element>
  675. <xs:element minOccurs="0"
  676. name="NUMER"
  677. type="xs:string"
  678. id="_3A__Dzialki___d18e10707-1_NUMER"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  679. <xs:annotation>
  680. <xs:documentation>e.g. 94/2</xs:documentation>
  681. </xs:annotation>
  682. </xs:element>
  683. <xs:element minOccurs="0"
  684. name="P_NAME"
  685. type="xs:string"
  686. id="_3A__Dzialki___d18e10712-1_P_NAME"/>
  687. <xs:element minOccurs="0"
  688. name="P_NAME_SECOND"
  689. type="xs:string"
  690. id="_3A__Dzialki___d18e10713-1_P_NAME_SEC"/>
  691. <xs:element minOccurs="0"
  692. name="P_NIP"
  693. type="xs:string"
  694. id="_3A__Dzialki___d18e10714-1_P_NIP"/>
  695. <xs:element minOccurs="0"
  696. name="P_PESEL"
  697. type="xs:string"
  698. id="_3A__Dzialki___d18e10715-1_P_PESEL"/>
  699. <xs:element minOccurs="0"
  700. name="P_OTHER_DOC"
  701. type="xs:string"
  702. id="_3A__Dzialki___d18e10716-1_P_OTHER_DO"/>
  703. <xs:element minOccurs="0"
  704. name="P_PHONE"
  705. type="xs:string"
  706. id="_3A__Dzialki___d18e10717-1_P_PHONE"/>
  707. <xs:element minOccurs="0"
  708. name="P_ADDRESS"
  709. type="xs:string"
  710. id="_3A__Dzialki___d18e10718-1_P_ADDRESS"/>
  711. <xs:element name="INWDZ__typ_dzialki"
  712. minOccurs="0"
  713. type="default_db__x3A__Dzialki:INWDZ__typ_dzialki"
  714. id="_3A__Dzialki___d18e10719-1_INWDZ__typ"/>
  715. </xs:sequence>
  716. </xs:restriction>
  717. </xs:complexContent>
  718. </xs:complexType>
  719. <xs:element name="Dzialki_Unknown"
  720. type="default_db__x3A__Dzialki:Dzialki_Unknown"
  721. id="_3A__Dzialki___d18e10720-1_Dzialki_Un"/>
  722. </xs:schema>