DEALS_TABLE.xsd 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:gml="http://www.opengis.net/gml/3.2"
  3. xmlns:Types__x3A__default_Default="https://biuro.biall-net.pl/wfs/default_db/Types/Default.xsd"
  4. xmlns:default_db__x3A__IN7_DZIENNIK_KORESP="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
  5. xmlns:hfp="http://www.w3.org/2001/XMLSchema-hasFacetAndProperty"
  6. xmlns:default_db__x3A__ADMIN_USERS="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
  7. xmlns:default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
  8. xmlns:SystemObjects__x3A__AccessGroup="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessGroup.xsd"
  9. xmlns:SystemObjects__x3A__AccessOwner="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessOwner.xsd"
  10. xmlns:default_db__x3A__DEALS_TABLE="https://biuro.biall-net.pl/wfs/default_db/table/DEALS_TABLE.xsd"
  11. xmlns:fix_se_defaultdb_schema="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/fix_se_defaultdb_schema/fix_se_defaultdb_schema.xsd"
  12. xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types"
  13. xmlns:default_db__x3A__USERS2_OFFERS_GROUPS="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_OFFERS_GROUPS.xsd"
  14. xmlns:default_db__x3A__USERS2_OFFERS="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_OFFERS.xsd"
  15. xmlns:default_db__x3A__MK_Rewiry="https://biuro.biall-net.pl/wfs/default_db/table/MK_Rewiry.xsd"
  16. xmlns:default_db__x3A__COMPANIES="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
  17. xmlns:default_db__x3A__SERVICES="https://biuro.biall-net.pl/wfs/default_db/table/SERVICES.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/DEALS_TABLE.xsd"
  28. vc:minVersion="1.1" xmlns:p5="https://biuro.biall-net.pl/wfs">
  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. <!---->
  34. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
  35. schemaLocation="../../default_db.IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP.xsd"/>
  36. <xs:import
  37. namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
  38. schemaLocation="../../default_db.IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI.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/USERS2_OFFERS_GROUPS.xsd"
  42. schemaLocation="../../default_db.USERS2_OFFERS_GROUPS/USERS2_OFFERS_GROUPS/USERS2_OFFERS_GROUPS.xsd"/>
  43. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_OFFERS.xsd"
  44. schemaLocation="../../default_db.USERS2_OFFERS/USERS2_OFFERS/USERS2_OFFERS.xsd"/>
  45. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/MK_Rewiry.xsd"
  46. schemaLocation="../../default_db.MK_Rewiry/MK_Rewiry/MK_Rewiry.xsd"/>
  47. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
  48. schemaLocation="../../default_db.COMPANIES/COMPANIES/COMPANIES.xsd"/>
  49. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/SERVICES.xsd"
  50. schemaLocation="../../default_db.SERVICES/SERVICES/SERVICES.xsd">
  51. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  52. <xs:annotation>
  53. <xs:documentation>Services potrzebne do raportu sprzedazy</xs:documentation>
  54. </xs:annotation>
  55. </xs:import>
  56. <xs:import namespace="https://biuro.biall-net.pl/wfs" schemaLocation="../../../Types/p5.xsd"/>
  57. <xs:simpleType name="A_STATUS_Type" id="DEALS_TABLE___d4e6183-1_A_STATUS_T">
  58. <xs:restriction base="xs:string">
  59. <xs:enumeration value="NORMAL"/>
  60. <xs:enumeration value="WAITING"/>
  61. <xs:enumeration value="MONITOR"/>
  62. <xs:enumeration value="DELETED"/>
  63. <xs:enumeration value="WARNING"/>
  64. <xs:enumeration value="OFF_SOFT"/>
  65. <xs:enumeration value="OFF_HARD"/>
  66. </xs:restriction>
  67. </xs:simpleType>
  68. <xs:complexType name="DEALS_TABLE" id="DEALS_TABLE___d4e6192-1_DEALS_TABL">
  69. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  70. <xs:annotation>
  71. <xs:appinfo>
  72. <system_cache__appinfo:heritage>
  73. <system_cache__appinfo:inherit system_cache__appinfo:heritage_acl="true" system_cache__appinfo:inherit_ref="default_db:DEALS_TABLE">
  74. <system_cache__appinfo:acl_rule_inherit_to_all_same_name_elements_and_refs/>
  75. <acl_rule_inherit_to_all_refs_by_primary/>
  76. <acl_rule_inherit_to_all_refs_by_local_element system_cache__appinfo:acl_rule_inherit_local_element_name="A_STATUS"/>
  77. </system_cache__appinfo:inherit>
  78. <system_cache__appinfo:exherit_all system_cache__appinfo:heritage_acl="true" system_cache__appinfo:heritage_sort="true"/>
  79. </system_cache__appinfo:heritage>
  80. </xs:appinfo>
  81. <xs:documentation>Umowy z klientami indywidualnymi</xs:documentation>
  82. </xs:annotation>
  83. <xs:sequence id="DEALS_TABLE___d4e6193-1">
  84. <xs:element name="ID" type="xs:integer" id="DEALS_TABLE___d4e6203-1_ID"/>
  85. <xs:element name="P_ID" type="xs:integer" id="DEALS_TABLE___d4e6204-1_P_ID"/>
  86. <xs:element name="the_geom" type="p5Type:point" id="DEALS_TABLE___d4e6194-1_the_geom"/>
  87. <xs:element name="A_STATUS" type="default_db__x3A__DEALS_TABLE:A_STATUS_Type"
  88. id="DEALS_TABLE___d4e6195-1_A_STATUS"/>
  89. <xs:element name="A_STATUS_INFO" type="xs:string" id="DEALS_TABLE___d4e6196-1_A_STATUS_I"/>
  90. <xs:element name="L_APPOITMENT_USER" type="xs:string"
  91. id="DEALS_TABLE___d4e6197-1_L_APPOITME"/>
  92. <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
  93. id="DEALS_TABLE___d18e203-1">
  94. <!--#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" system_cache__appinfo:name="L_APPOITMENT_USER" system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
  99. </system_cache__appinfo:flat_relation_cache>
  100. </xs:appinfo>
  101. </xs:annotation>
  102. </xs:element>
  103. <xs:element name="A_CLASSIFIED" type="xs:string" id="DEALS_TABLE___d4e6199-1_A_CLASSIFI"/>
  104. <xs:element name="A_ADM_COMPANY" type="xs:string" id="DEALS_TABLE___d4e6201-1_A_ADM_COMP"/>
  105. <xs:element name="ID_BILLING_USERS" type="xs:integer"
  106. id="DEALS_TABLE___d4e6206-1_ID_BILLING"/>
  107. <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS" id="DEALS_TABLE___d18e211-1">
  108. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  109. <xs:annotation>
  110. <xs:appinfo>
  111. <system_cache__appinfo:flat_relation_cache>
  112. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ID_BILLING_USERS" system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
  113. </system_cache__appinfo:flat_relation_cache>
  114. </xs:appinfo>
  115. <xs:documentation>
  116. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #3992 !!!
  117. </xs:documentation>
  118. </xs:annotation>
  119. </xs:element>
  120. <xs:element name="P_DEALPREFIX" type="xs:string" id="DEALS_TABLE___d4e6207-1_P_DEALPREF"/>
  121. <xs:element name="P_DEALNUMBER" type="xs:integer" id="DEALS_TABLE___d4e6208-1_P_DEALNUMB"/>
  122. <xs:element name="P_DEALNUMBER_OLD" type="xs:string"
  123. id="DEALS_TABLE___d4e6209-1_P_DEALNUMB"/>
  124. <xs:element name="P_DEALDATE" type="xs:token" id="DEALS_TABLE___d4e6210-1_P_DEALDATE"/>
  125. <xs:element name="TAB_UPDATE_STAT" type="xs:string" id="DEALS_TABLE___d4e6211-1_TAB_UPDATE"/>
  126. <xs:element name="TAB_UPDATE_DATE" type="xs:token" id="DEALS_TABLE___d4e6212-1_TAB_UPDATE"/>
  127. <xs:element name="TAB_UPDATE_INFO" type="xs:string" id="DEALS_TABLE___d4e6213-1_TAB_UPDATE"/>
  128. <xs:element name="P_DEALDATE_TERM" type="xs:token" id="DEALS_TABLE___d4e6214-1_P_DEALDATE"/>
  129. <xs:element name="ANEX_NEEDED" type="xs:string" id="DEALS_TABLE___d4e6215-1_ANEX_NEEDE"/>
  130. <xs:element name="ANEX_CONFIRM_DATE" type="xs:token"
  131. id="DEALS_TABLE___d4e6216-1_ANEX_CONFI"/>
  132. <xs:element name="DEALDESC" type="xs:string" id="DEALS_TABLE___d4e6218-1_DEALDESC"/>
  133. <xs:element name="A_RECORD_CREATE_DATE" type="xs:string"
  134. id="DEALS_TABLE___d4e6219-1_A_RECORD_C"/>
  135. <xs:element name="A_RECORD_CREATE_AUTHOR" type="xs:string"
  136. id="DEALS_TABLE___d4e6220-1_A_RECORD_C"/>
  137. <xs:element name="A_RECORD_UPDATE_DATE" type="xs:string"
  138. id="DEALS_TABLE___d4e6221-1_A_RECORD_U"/>
  139. <xs:element name="A_RECORD_UPDATE_AUTHOR" type="xs:string"
  140. id="DEALS_TABLE___d4e6222-1_A_RECORD_U"/>
  141. <xs:element name="L_APPOITMENT_DATE" type="xs:string"
  142. id="DEALS_TABLE___d4e6223-1_L_APPOITME"/>
  143. <xs:element name="L_APPOITMENT_PERIOD" type="xs:string"
  144. id="DEALS_TABLE___d4e6224-1_L_APPOITME"/>
  145. <xs:element name="L_APPOITMENT_INFO" type="xs:string"
  146. id="DEALS_TABLE___d4e6225-1_L_APPOITME"/>
  147. <xs:element name="L_APPOITMENT_TYPE" type="xs:string"
  148. id="DEALS_TABLE___d4e6226-1_L_APPOITME"/>
  149. <xs:element name="A_PROBLEM" type="xs:string" id="DEALS_TABLE___d4e6227-1_A_PROBLEM"/>
  150. <xs:element name="A_PROBLEM_DESC" type="xs:string" id="DEALS_TABLE___d4e6228-1_A_PROBLEM_"/>
  151. <xs:element name="A_PROBLEM_DATE" type="xs:string" id="DEALS_TABLE___d4e6230-1_A_PROBLEM_"/>
  152. <xs:element name="T_WORKPOINTS" type="xs:string" id="DEALS_TABLE___d4e6231-1_T_WORKPOIN"/>
  153. <xs:element name="T_WORKPOINTS_VALUE" type="xs:string"
  154. id="DEALS_TABLE___d4e6232-1_T_WORKPOIN"/>
  155. <xs:element name="T_WORKPOINTS_TYPE" type="xs:string"
  156. id="DEALS_TABLE___d4e6233-1_T_WORKPOIN"/>
  157. <xs:element name="T_WORKPOINTS_USER" type="xs:string"
  158. id="DEALS_TABLE___d4e6234-1_T_WORKPOIN"/>
  159. <xs:element name="T_WORKPOINTS_DATE" type="xs:string"
  160. id="DEALS_TABLE___d4e6235-1_T_WORKPOIN"/>
  161. <xs:element name="P_ACCOUNT" type="xs:string" id="DEALS_TABLE___d4e6236-1_P_ACCOUNT"/>
  162. <xs:element name="ID_OFFERS_GROUP" type="xs:integer"
  163. id="DEALS_TABLE___d4e6237-1_ID_OFFERS_"/>
  164. <xs:element ref="default_db__x3A__USERS2_OFFERS_GROUPS:USERS2_OFFERS_GROUPS"
  165. id="DEALS_TABLE___d18e250-1">
  166. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  167. <xs:annotation>
  168. <xs:appinfo>
  169. <system_cache__appinfo:flat_relation_cache>
  170. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ID_OFFERS_GROUP" system_cache__appinfo:xpath="default_db__x3A__USERS2_OFFERS_GROUPS:USERS2_OFFERS_GROUPS/ID"/>
  171. </system_cache__appinfo:flat_relation_cache>
  172. </xs:appinfo>
  173. <xs:documentation>@2018-03 todo powinna byc od drugiej strony relacja raczej?</xs:documentation>
  174. </xs:annotation>
  175. </xs:element>
  176. <xs:element name="ID_OFFERS_ON" type="xs:string" id="DEALS_TABLE___d4e6238-1_ID_OFFERS_"/>
  177. <xs:element ref="default_db__x3A__USERS2_OFFERS:ID_OFFERS_ON" id="DEALS_TABLE___d18e258-1">
  178. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  179. <xs:annotation>
  180. <xs:appinfo>
  181. <system_cache__appinfo:flat_relation_cache>
  182. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ID_OFFERS_ON" system_cache__appinfo:xpath="default_db__x3A__USERS2_OFFERS:ID_OFFERS_ON/ID"/>
  183. </system_cache__appinfo:flat_relation_cache>
  184. </xs:appinfo>
  185. <xs:documentation>@2018-03 todo powinna byc od drugiej strony relacja raczej?</xs:documentation>
  186. </xs:annotation>
  187. </xs:element>
  188. <xs:element name="ID_OFFERS_OFF" type="xs:string" id="DEALS_TABLE___d4e6239-1_ID_OFFERS_"/>
  189. <xs:element ref="default_db__x3A__USERS2_OFFERS:ID_OFFERS_OFF" id="DEALS_TABLE___d18e267-1">
  190. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  191. <xs:annotation>
  192. <xs:appinfo>
  193. <system_cache__appinfo:flat_relation_cache>
  194. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ID_OFFERS_OFF" system_cache__appinfo:xpath="default_db__x3A__USERS2_OFFERS:ID_OFFERS_OFF/ID"/>
  195. </system_cache__appinfo:flat_relation_cache>
  196. </xs:appinfo>
  197. <xs:documentation>@2018-03 todo powinna byc od drugiej strony relacja raczej?</xs:documentation>
  198. </xs:annotation>
  199. </xs:element>
  200. <xs:element name="NEW_L2_HANGUP_FROM" type="xs:token"
  201. id="DEALS_TABLE___d4e6240-1_NEW_L2_HAN"/>
  202. <xs:element name="S_ADDRESS_STREET" type="xs:string"
  203. id="DEALS_TABLE___d4e6242-1_S_ADDRESS_"/>
  204. <xs:element name="RODZAJ_DZIALANIA_HANDLOWEGO" type="xs:string"
  205. id="DEALS_TABLE___d4e6243-1_RODZAJ_DZI"/>
  206. <xs:element name="L2_HANGUP_FROM" type="xs:date" id="DEALS_TABLE___d4e6244-1_L2_HANGUP_"/>
  207. <xs:element name="M_DIST_FILES" type="xs:string" id="DEALS_TABLE___d4e6245-1_M_DIST_FIL"/>
  208. <xs:element name="alias_OFFERS_GROUPS__S_ALIAS" type="xs:string"
  209. id="DEALS_TABLE___d4e6246-1_alias_OFFE"/>
  210. <xs:element name="ROZLICZ_MONTH" type="xs:token" id="DEALS_TABLE___d4e6247-1_ROZLICZ_MO"/>
  211. <xs:element name="ROZLICZ_ZYSK" type="xs:double" id="DEALS_TABLE___d4e6248-1_ROZLICZ_ZY"/>
  212. <xs:element name="M_REWIR" type="xs:string" id="DEALS_TABLE___d4e6249-1_M_REWIR"/>
  213. <xs:element ref="default_db__x3A__MK_Rewiry:MK_Rewiry" id="DEALS_TABLE___d18e283-1">
  214. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  215. <xs:annotation>
  216. <xs:appinfo>
  217. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  218. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="M_REWIR" system_cache__appinfo:xpath="default_db__x3A__MK_Rewiry:MK_Rewiry/NAZWA_REWI"/>
  219. </system_cache__appinfo:flat_relation_cache>
  220. </xs:appinfo>
  221. <xs:documentation>@2018-03 todo mamy podwojne dojscie - przez rewir i przez projekt - lepiej od rewiru analizowac sprzedaz. Relacja jako backref</xs:documentation>
  222. </xs:annotation>
  223. </xs:element>
  224. <xs:element name="P_OSIEDLE" type="xs:string" id="DEALS_TABLE___d4e6250-1_P_OSIEDLE"/>
  225. <xs:element name="OFFERS_PRICES_INFO" type="xs:string"
  226. id="DEALS_TABLE___d4e6251-1_OFFERS_PRI"/>
  227. <xs:element name="OFFERS_ZYSK_INFO" type="xs:string"
  228. id="DEALS_TABLE___d4e6252-1_OFFERS_ZYS"/>
  229. <xs:element name="ID_PROJECT" type="xs:integer" id="DEALS_TABLE___d4e6254-1_ID_PROJECT"/>
  230. <xs:element name="USTALONA_DATA_PODLACZENIA" type="xs:date"
  231. id="DEALS_TABLE___d18e295-1_USTALONA_D"/>
  232. <xs:element name="DATA_WYK_PODLACZENIA" type="xs:date"
  233. id="DEALS_TABLE___d18e296-1_DATA_WYK_P"/>
  234. <xs:element ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT"
  235. id="DEALS_TABLE___d18e297-1">
  236. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  237. <xs:annotation>
  238. <xs:appinfo>
  239. <system_cache__appinfo:flat_relation_cache>
  240. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ID_PROJECT" system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT/ID"/>
  241. </system_cache__appinfo:flat_relation_cache>
  242. </xs:appinfo>
  243. <xs:documentation>@2018-03 todo mamy podwojne dojscie - przez rewir i przez projekt - lepiej od rewiru analizowac sprzedaz</xs:documentation>
  244. </xs:annotation>
  245. </xs:element>
  246. <xs:element minOccurs="0" ref="default_db__x3A__SERVICES:SERVICES"
  247. id="DEALS_TABLE___d18e304-1">
  248. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  249. <xs:annotation>
  250. <xs:appinfo>
  251. <system_cache__appinfo:flat_relation_cache>
  252. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ID" system_cache__appinfo:xpath="default_db__x3A__SERVICES:SERVICES/ID_DEALS_TABLE"/>
  253. </system_cache__appinfo:flat_relation_cache>
  254. </xs:appinfo>
  255. <xs:documentation>Jedna usluga moze miec max jedna umowe raczej. Ta relacja jest potrzebna do raportu sprzedazy. Uwaga podwojne dojscie przez ID_PROJECT jest rowniez! Do tuningu</xs:documentation>
  256. </xs:annotation>
  257. </xs:element>
  258. <xs:element name="AKTYWACJA_link" type="p5:link" id="DEALS_TABLE___d18e311-1_AKTYWACJA_">
  259. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  260. <xs:annotation>
  261. <xs:appinfo>
  262. <p5Type:simpleLink href="index.php?MENU_INIT=POKAZ_OFERTY_AKTUALNE_FUNC&amp;task=activate_deal&amp;id_deal={ID}" target="_blank" label="Aktywuj umowę {ID}"/>
  263. </xs:appinfo>
  264. </xs:annotation>
  265. </xs:element>
  266. </xs:sequence>
  267. </xs:complexType>
  268. <xs:element name="DEALS_TABLE" type="default_db__x3A__DEALS_TABLE:DEALS_TABLE"
  269. id="DEALS_TABLE___d4e6255-1_DEALS_TABL">
  270. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  271. <xs:annotation>
  272. <xs:documentation>Umowy z klientami indywidualnymi</xs:documentation>
  273. </xs:annotation>
  274. </xs:element>
  275. </xs:schema>