MK_Rewiry.xsd 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469
  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_Default="https://biuro.biall-net.pl/wfs/default_db/Types/Default.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__MK_Rewiry="https://biuro.biall-net.pl/wfs/default_db/table/MK_Rewiry.xsd"
  12. xmlns:default_db__x3A__USERS2_MARKETING="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_MARKETING.xsd"
  13. xmlns:fix_se_defaultdb_schema="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/fix_se_defaultdb_schema/fix_se_defaultdb_schema.xsd"
  14. xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types"
  15. xmlns:default_db__x3A__CRM_LISTA_ZASOBOW="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW.xsd"
  16. xmlns:default_db__x3A__SALES_PLAN="https://biuro.biall-net.pl/wfs/default_db/table/SALES_PLAN.xsd"
  17. xmlns:default_db__x3A__DEALS_TABLE="https://biuro.biall-net.pl/wfs/default_db/table/DEALS_TABLE.xsd"
  18. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  19. xmlns:p5_tr_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"
  20. xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
  21. 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"
  22. xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
  23. xmlns:p5opr="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/object_parent_relations/object_parent_relations.xsd"
  24. xmlns:p5_simpleSchema_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_simpleSchema_map.xsd"
  25. xmlns:ant-object="http://biuro.biall-net.pl/xmlschema_procesy5/ant-object/ant-object.xsd"
  26. xmlns:p5ant-interface="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/ant_interface/ant_interface.xsd"
  27. targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/MK_Rewiry.xsd"
  28. vc:minVersion="1.1">
  29. <xs:import namespace="http://biuro.biall-net.pl/p5/schema/types"
  30. schemaLocation="../../../types.xsd"/>
  31. <xs:import namespace="http://www.opengis.net/gml/3.2"
  32. schemaLocation="http://www.opengis.net/gml/3.2"/>
  33. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
  34. schemaLocation="../../default_db.IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP.xsd"/>
  35. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
  36. schemaLocation="../../default_db.IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI.xsd"/>
  37. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_MARKETING.xsd"
  38. schemaLocation="../../default_db.USERS2_MARKETING/USERS2_MARKETING/USERS2_MARKETING.xsd"/>
  39. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
  40. schemaLocation="../../default_db.ADMIN_USERS/ADMIN_USERS/ADMIN_USERS.xsd"/>
  41. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW.xsd"
  42. schemaLocation="../../default_db.CRM_LISTA_ZASOBOW/CRM_LISTA_ZASOBOW/CRM_LISTA_ZASOBOW.xsd"/>
  43. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/SALES_PLAN.xsd"
  44. schemaLocation="../../default_db.SALES_PLAN/SALES_PLAN/SALES_PLAN.xsd"/>
  45. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/DEALS_TABLE.xsd"
  46. schemaLocation="../../default_db.DEALS_TABLE/DEALS_TABLE/DEALS_TABLE.xsd"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  47. <xs:annotation>
  48. <xs:documentation>Ta relacja bedzie potrzebna do raportów sprzedazy</xs:documentation>
  49. </xs:annotation>
  50. </xs:import>
  51. <xs:simpleType name="A_STATUS_Type" id="__MK_Rewiry___d5e78387-1_A_STATUS_T">
  52. <xs:restriction base="xs:string">
  53. <xs:enumeration value="NORMAL"/>
  54. <xs:enumeration value="WAITING"/>
  55. <xs:enumeration value="MONITOR"/>
  56. <xs:enumeration value="DELETED"/>
  57. <xs:enumeration value="WARNING"/>
  58. <xs:enumeration value="OFF_SOFT"/>
  59. <xs:enumeration value="OFF_HARD"/>
  60. </xs:restriction>
  61. </xs:simpleType>
  62. <xs:complexType name="MK_Rewiry"
  63. id="__MK_Rewiry___d5e78396-1_MK_Rewiry"
  64. system_cache__appinfo:primaryKey="ID"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  65. <xs:annotation>
  66. <xs:appinfo>
  67. <system_cache__appinfo:heritage>
  68. <system_cache__appinfo:inherit system_cache__appinfo:inherit_ref="default_db:MK_Rewiry"
  69. system_cache__appinfo:heritage_acl="true">
  70. <system_cache__appinfo:acl_rule_inherit_to_all_same_name_elements_and_refs/>
  71. <acl_rule_inherit_to_all_refs_by_primary/>
  72. <acl_rule_inherit_to_all_refs_by_local_element system_cache__appinfo:acl_rule_inherit_local_element_name="A_STATUS"/>
  73. </system_cache__appinfo:inherit>
  74. <system_cache__appinfo:exherit_all system_cache__appinfo:heritage_acl="true"
  75. system_cache__appinfo:heritage_sort="true"/>
  76. </system_cache__appinfo:heritage>
  77. </xs:appinfo>
  78. </xs:annotation>
  79. <xs:sequence id="__MK_Rewiry___d5e78397-1">
  80. <xs:element name="ID" type="xs:integer" id="__MK_Rewiry___d5e78417-1_ID"/>
  81. <xs:element name="the_geom"
  82. id="__MK_Rewiry___d5e78398-1_the_geom"
  83. type="p5Type:polygon"/>
  84. <xs:element name="A_STATUS"
  85. type="default_db__x3A__MK_Rewiry:A_STATUS_Type"
  86. id="__MK_Rewiry___d5e78402-1_A_STATUS"/>
  87. <xs:element name="A_STATUS_INFO"
  88. type="xs:string"
  89. id="__MK_Rewiry___d5e78403-1_A_STATUS_I"/>
  90. <xs:element name="L_APPOITMENT_USER"
  91. type="xs:string"
  92. id="__MK_Rewiry___d5e78404-1_L_APPOITME"/>
  93. <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
  94. id="__MK_Rewiry___d18e38621-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  95. <xs:annotation>
  96. <xs:appinfo>
  97. <system_cache__appinfo:flat_relation_cache>
  98. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  99. system_cache__appinfo:name="L_APPOITMENT_USER"
  100. system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
  101. </system_cache__appinfo:flat_relation_cache>
  102. </xs:appinfo>
  103. <xs:documentation>
  104. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
  105. </xs:documentation>
  106. </xs:annotation>
  107. </xs:element>
  108. <!--<xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner">
  109. <xs:annotation>
  110. <xs:appinfo>
  111. <system_cache__appinfo:flat_relation_cache>
  112. <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER" system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/name"/>
  113. </system_cache__appinfo:flat_relation_cache>
  114. </xs:appinfo>
  115. </xs:annotation>
  116. </xs:element>-->
  117. <xs:element name="A_CLASSIFIED"
  118. type="xs:string"
  119. id="__MK_Rewiry___d5e78406-1_A_CLASSIFI"/>
  120. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead">
  121. <xs:annotation>
  122. <xs:appinfo>
  123. <system_cache__appinfo:flat_relation_cache>
  124. <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
  125. </system_cache__appinfo:flat_relation_cache>
  126. </xs:appinfo>
  127. </xs:annotation>
  128. </xs:element>-->
  129. <xs:element name="A_ADM_COMPANY"
  130. type="xs:string"
  131. id="__MK_Rewiry___d5e78408-1_A_ADM_COMP"/>
  132. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite">
  133. <xs:annotation>
  134. <xs:appinfo>
  135. <system_cache__appinfo:flat_relation_cache>
  136. <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
  137. </system_cache__appinfo:flat_relation_cache>
  138. </xs:appinfo>
  139. </xs:annotation>
  140. </xs:element>-->
  141. <xs:element name="cache_count_POPC_lokali"
  142. type="xs:integer"
  143. id="__MK_Rewiry___d5e78411-1_cache_coun"/>
  144. <xs:element name="data_kuponow"
  145. type="xs:string"
  146. id="__MK_Rewiry___d5e78413-1_data_kupon"/>
  147. <xs:element name="gis_square_ha_area"
  148. type="xs:double"
  149. id="__MK_Rewiry___d5e78414-1_gis_square"/>
  150. <xs:element name="NAZWA_REWI"
  151. type="xs:string"
  152. id="__MK_Rewiry___d5e78415-1_NAZWA_REWI"/>
  153. <xs:element name="T_INSTALACJA_W_CIAGU_DNI"
  154. type="xs:string"
  155. id="__MK_Rewiry___d5e78416-1_T_INSTALAC"/>
  156. <xs:element name="A_RECORD_CREATE_DATE"
  157. type="xs:token"
  158. id="__MK_Rewiry___d5e78418-1_A_RECORD_C"/>
  159. <xs:element name="A_RECORD_CREATE_AUTHOR"
  160. type="xs:string"
  161. id="__MK_Rewiry___d5e78419-1_A_RECORD_C"/>
  162. <xs:element name="A_RECORD_UPDATE_DATE"
  163. type="xs:token"
  164. id="__MK_Rewiry___d5e78421-1_A_RECORD_U"/>
  165. <xs:element name="A_RECORD_UPDATE_AUTHOR"
  166. type="xs:string"
  167. id="__MK_Rewiry___d5e78422-1_A_RECORD_U"/>
  168. <xs:element name="L_APPOITMENT_DATE"
  169. type="xs:string"
  170. id="__MK_Rewiry___d5e78423-1_L_APPOITME"/>
  171. <xs:element name="L_APPOITMENT_PERIOD"
  172. type="xs:string"
  173. id="__MK_Rewiry___d5e78425-1_L_APPOITME"/>
  174. <xs:element name="L_APPOITMENT_INFO"
  175. type="xs:string"
  176. id="__MK_Rewiry___d5e78426-1_L_APPOITME"/>
  177. <xs:element name="L_APPOITMENT_TYPE"
  178. type="xs:string"
  179. id="__MK_Rewiry___d5e78427-1_L_APPOITME"/>
  180. <xs:element name="CRM_LISTA_ZASOBOW_ID"
  181. type="xs:integer"
  182. id="__MK_Rewiry___d5e78428-1_CRM_LISTA_"/>
  183. <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID"
  184. id="__MK_Rewiry___d18e38649-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  185. <xs:annotation>
  186. <xs:appinfo>
  187. <system_cache__appinfo:flat_relation_cache>
  188. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  189. system_cache__appinfo:name="CRM_LISTA_ZASOBOW_ID"
  190. system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID/ID"/>
  191. </system_cache__appinfo:flat_relation_cache>
  192. </xs:appinfo>
  193. <xs:documentation>
  194. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #224
  195. </xs:documentation>
  196. </xs:annotation>
  197. </xs:element>
  198. <xs:element name="ADMIN_USERS_ID"
  199. type="xs:integer"
  200. id="__MK_Rewiry___d5e78429-1_ADMIN_USER"/>
  201. <xs:element ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS_ID"
  202. id="__MK_Rewiry___d18e38657-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  203. <xs:annotation>
  204. <xs:appinfo>
  205. <system_cache__appinfo:flat_relation_cache>
  206. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  207. system_cache__appinfo:name="ADMIN_USERS_ID"
  208. system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS_ID/ID"/>
  209. </system_cache__appinfo:flat_relation_cache>
  210. </xs:appinfo>
  211. <xs:documentation>
  212. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #185
  213. </xs:documentation>
  214. </xs:annotation>
  215. </xs:element>
  216. <xs:element name="cache_count_POPC"
  217. type="xs:integer"
  218. id="__MK_Rewiry___d5e78430-1_cache_coun"/>
  219. <xs:element name="cache_count_POPC_plac"
  220. type="xs:integer"
  221. id="__MK_Rewiry___d5e78431-1_cache_coun"/>
  222. <xs:element name="cache_count_POPC_plac_os_A"
  223. type="xs:integer"
  224. id="__MK_Rewiry___d5e78432-1_cache_coun"/>
  225. <xs:element name="ID_PROJECT"
  226. type="xs:integer"
  227. id="__MK_Rewiry___d5e78433-1_ID_PROJECT"/>
  228. <xs:element ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT"
  229. id="__MK_Rewiry___d18e38668-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  230. <xs:annotation>
  231. <xs:appinfo>
  232. <system_cache__appinfo:flat_relation_cache>
  233. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  234. system_cache__appinfo:name="ID_PROJECT"
  235. system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT/ID"/>
  236. </system_cache__appinfo:flat_relation_cache>
  237. </xs:appinfo>
  238. <xs:documentation>
  239. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #204
  240. </xs:documentation>
  241. </xs:annotation>
  242. </xs:element>
  243. <xs:element name="TASKS_INFO_trigger"
  244. type="xs:string"
  245. id="__MK_Rewiry___d18e38676-1_TASKS_INFO"/>
  246. <xs:element name="PROJ_INFO_trigger"
  247. type="xs:string"
  248. id="__MK_Rewiry___d18e38677-1_PROJ_INFO_"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  249. <xs:annotation>
  250. <xs:documentation>Bez tego pola @2018-03-28 ktore jest w bazie natywnie, UI zglaszal error ze Field Not Found - zatem dodaje te pola...</xs:documentation>
  251. </xs:annotation>
  252. </xs:element>
  253. <xs:element name="IN7_DZIENNIK_KORESP_INFO_trigger"
  254. type="xs:string"
  255. id="__MK_Rewiry___d18e38681-1_IN7_DZIENN"/>
  256. <xs:element name="ID_KORESP_PROJEKT"
  257. type="xs:integer"
  258. id="__MK_Rewiry___d5e78434-1_ID_KORESP_"/>
  259. <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_PROJEKT"
  260. id="__MK_Rewiry___d18e38683-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  261. <xs:annotation>
  262. <xs:appinfo>
  263. <system_cache__appinfo:flat_relation_cache>
  264. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  265. system_cache__appinfo:name="ID_KORESP_PROJEKT"
  266. system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_PROJEKT"/>
  267. </system_cache__appinfo:flat_relation_cache>
  268. </xs:appinfo>
  269. <xs:documentation>
  270. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
  271. </xs:documentation>
  272. </xs:annotation>
  273. </xs:element>
  274. <xs:element name="ID_KORESP_ZLECENIE"
  275. type="xs:integer"
  276. id="__MK_Rewiry___d5e78437-1_ID_KORESP_"/>
  277. <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_ZLECENIE"
  278. id="__MK_Rewiry___d18e38691-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  279. <xs:annotation>
  280. <xs:appinfo>
  281. <system_cache__appinfo:flat_relation_cache>
  282. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  283. system_cache__appinfo:name="ID_KORESP_ZLECENIE"
  284. system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_ZLECENIE"/>
  285. </system_cache__appinfo:flat_relation_cache>
  286. </xs:appinfo>
  287. <xs:documentation>
  288. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
  289. </xs:documentation>
  290. </xs:annotation>
  291. </xs:element>
  292. <xs:element name="ID_KORESP_ZLECENIE_PROJEKT"
  293. type="xs:integer"
  294. id="__MK_Rewiry___d5e78438-1_ID_KORESP_"/>
  295. <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_ZLECENIE_PROJEKT"
  296. id="__MK_Rewiry___d18e38699-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  297. <xs:annotation>
  298. <xs:appinfo>
  299. <system_cache__appinfo:flat_relation_cache>
  300. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  301. system_cache__appinfo:name="ID_KORESP_ZLECENIE_PROJEKT"
  302. system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_ZLECENIE_PROJEKT"/>
  303. </system_cache__appinfo:flat_relation_cache>
  304. </xs:appinfo>
  305. <xs:documentation>
  306. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
  307. </xs:documentation>
  308. </xs:annotation>
  309. </xs:element>
  310. <xs:element name="ID_KORESP_PROTOK_ODB"
  311. type="xs:integer"
  312. id="__MK_Rewiry___d5e78439-1_ID_KORESP_"/>
  313. <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_PROTOK_ODB"
  314. id="__MK_Rewiry___d18e38707-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  315. <xs:annotation>
  316. <xs:appinfo>
  317. <system_cache__appinfo:flat_relation_cache>
  318. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  319. system_cache__appinfo:name="ID_KORESP_PROTOK_ODB"
  320. system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_PROTOK_ODB"/>
  321. </system_cache__appinfo:flat_relation_cache>
  322. </xs:appinfo>
  323. <xs:documentation>
  324. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
  325. </xs:documentation>
  326. </xs:annotation>
  327. </xs:element>
  328. <xs:element name="ID_KORESP_OFFER"
  329. type="xs:integer"
  330. id="__MK_Rewiry___d5e78440-1_ID_KORESP_"/>
  331. <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_OFFER"
  332. id="__MK_Rewiry___d18e38716-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  333. <xs:annotation>
  334. <xs:appinfo>
  335. <system_cache__appinfo:flat_relation_cache>
  336. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  337. system_cache__appinfo:name="ID_KORESP_OFFER"
  338. system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_OFFER"/>
  339. </system_cache__appinfo:flat_relation_cache>
  340. </xs:appinfo>
  341. <xs:documentation>
  342. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
  343. </xs:documentation>
  344. </xs:annotation>
  345. </xs:element>
  346. <xs:element name="ID_KORESP_UMOWA_DEVELOPPER"
  347. type="xs:integer"
  348. id="__MK_Rewiry___d5e78441-1_ID_KORESP_"/>
  349. <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_UMOWA_DEVELOPPER"
  350. id="__MK_Rewiry___d18e38724-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  351. <xs:annotation>
  352. <xs:appinfo>
  353. <system_cache__appinfo:flat_relation_cache>
  354. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  355. system_cache__appinfo:name="ID_KORESP_UMOWA_DEVELOPPER"
  356. system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_UMOWA_DEVELOPPER"/>
  357. </system_cache__appinfo:flat_relation_cache>
  358. </xs:appinfo>
  359. <xs:documentation>
  360. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
  361. </xs:documentation>
  362. </xs:annotation>
  363. </xs:element>
  364. <xs:element name="PLANNED_DATE_PROJEKT_FINISH"
  365. type="xs:token"
  366. id="__MK_Rewiry___d5e78442-1_PLANNED_DA"/>
  367. <xs:element name="PLANNED_DATE_BUDOWA_START"
  368. type="xs:token"
  369. id="__MK_Rewiry___d5e78443-1_PLANNED_DA"/>
  370. <xs:element name="PLANNED_DATE_BUDOWA_FINISH"
  371. type="xs:token"
  372. id="__MK_Rewiry___d5e78444-1_PLANNED_DA"/>
  373. <xs:element ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING"
  374. maxOccurs="unbounded"
  375. minOccurs="0"
  376. id="__MK_Rewiry___d18e38734-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  377. <xs:annotation>
  378. <xs:appinfo>
  379. <system_cache__appinfo:flat_relation_cache>
  380. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  381. system_cache__appinfo:name="NAZWA_REWI"
  382. system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING/M_REWIR"/>
  383. </system_cache__appinfo:flat_relation_cache>
  384. </xs:appinfo>
  385. <xs:documentation>Podstawowqe filtrowania klientow</xs:documentation>
  386. </xs:annotation>
  387. </xs:element>
  388. <xs:element ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING_BN_FRESH"
  389. id="__MK_Rewiry___d5e78445-1"
  390. maxOccurs="unbounded"
  391. minOccurs="0"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  392. <xs:annotation>
  393. <xs:appinfo>
  394. <system_cache__appinfo:flat_relation_cache>
  395. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  396. system_cache__appinfo:name="NAZWA_REWI"
  397. system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING_BN_FRESH/M_REWIR"/>
  398. </system_cache__appinfo:flat_relation_cache>
  399. </xs:appinfo>
  400. <xs:documentation>Podstawowqe filtrowania klientow</xs:documentation>
  401. </xs:annotation>
  402. </xs:element>
  403. <xs:element ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING_OBCY_OLD"
  404. id="__MK_Rewiry___d5e78450-1"
  405. maxOccurs="unbounded"
  406. minOccurs="0"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  407. <xs:annotation>
  408. <xs:appinfo>
  409. <system_cache__appinfo:flat_relation_cache>
  410. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  411. system_cache__appinfo:name="NAZWA_REWI"
  412. system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING_OBCY_OLD/M_REWIR"/>
  413. </system_cache__appinfo:flat_relation_cache>
  414. </xs:appinfo>
  415. <xs:documentation>Podstawowqe filtrowania klientow</xs:documentation>
  416. </xs:annotation>
  417. </xs:element>
  418. <xs:element ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING_BN_OLD"
  419. id="__MK_Rewiry___d5e78455-1"
  420. maxOccurs="unbounded"
  421. minOccurs="0"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  422. <xs:annotation>
  423. <xs:appinfo>
  424. <system_cache__appinfo:flat_relation_cache>
  425. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  426. system_cache__appinfo:name="NAZWA_REWI"
  427. system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING_BN_OLD/M_REWIR"/>
  428. </system_cache__appinfo:flat_relation_cache>
  429. </xs:appinfo>
  430. <xs:documentation>Podstawowqe filtrowania klientow</xs:documentation>
  431. </xs:annotation>
  432. </xs:element>
  433. <xs:element maxOccurs="unbounded"
  434. minOccurs="0"
  435. ref="default_db__x3A__SALES_PLAN:SALES_PLAN"
  436. id="__MK_Rewiry___d18e38763-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  437. <xs:annotation>
  438. <xs:appinfo>
  439. <system_cache__appinfo:flat_relation_cache>
  440. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  441. system_cache__appinfo:name="NAZWA_REWI"
  442. system_cache__appinfo:xpath="default_db__x3A__SALES_PLAN:SALES_PLAN/NAZWA_REWI"/>
  443. </system_cache__appinfo:flat_relation_cache>
  444. </xs:appinfo>
  445. </xs:annotation>
  446. </xs:element>
  447. <xs:element maxOccurs="unbounded"
  448. minOccurs="0"
  449. ref="default_db__x3A__DEALS_TABLE:DEALS_TABLE"
  450. id="__MK_Rewiry___d18e38768-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  451. <xs:annotation>
  452. <xs:documentation>
  453. Potrzebne do raportu sprzedazy - idziemy do faktur
  454. </xs:documentation>
  455. <xs:appinfo>
  456. <system_cache__appinfo:flat_relation_cache>
  457. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  458. system_cache__appinfo:name="NAZWA_REWI"
  459. system_cache__appinfo:xpath="default_db__x3A__DEALS_TABLE:DEALS_TABLE/M_REWIR"/>
  460. </system_cache__appinfo:flat_relation_cache>
  461. </xs:appinfo>
  462. </xs:annotation>
  463. </xs:element>
  464. </xs:sequence>
  465. </xs:complexType>
  466. <xs:element name="MK_Rewiry"
  467. type="default_db__x3A__MK_Rewiry:MK_Rewiry"
  468. id="__MK_Rewiry___d5e78466-1_MK_Rewiry"/>
  469. </xs:schema>