DEVICES.xsd 41 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639
  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__DEVICES="https://biuro.biall-net.pl/wfs/default_db/table/DEVICES.xsd"
  11. xmlns:p5_tr_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"
  12. xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
  13. 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"
  14. xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
  15. targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/DEVICES.xsd" vc:minVersion="1.1">
  16. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
  17. schemaLocation="../../default_db.IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP.xsd"/>
  18. <xs:import
  19. namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
  20. schemaLocation="../../default_db.IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI.xsd"/>
  21. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
  22. schemaLocation="../../default_db.ADMIN_USERS/ADMIN_USERS/ADMIN_USERS.xsd"/>
  23. <xs:simpleType name="A_STATUS_Type" id="a3A__DEVICES___d5e78873-1_A_STATUS_T">
  24. <xs:restriction base="xs:string">
  25. <xs:enumeration value="NORMAL"/>
  26. <xs:enumeration value="WAITING"/>
  27. <xs:enumeration value="MONITOR"/>
  28. <xs:enumeration value="DELETED"/>
  29. <xs:enumeration value="WARNING"/>
  30. <xs:enumeration value="OFF_SOFT"/>
  31. <xs:enumeration value="OFF_HARD"/>
  32. </xs:restriction>
  33. </xs:simpleType>
  34. <xs:simpleType id="a3A__DEVICES___d5e8554-1_T_DEVICE_T" name="T_DEVICE_TYPE">
  35. <xs:restriction base="xs:string"/>
  36. </xs:simpleType>
  37. <xs:simpleType id="a3A__DEVICES___d5e8556-1_T_DEVICE_T" name="T_DEVICE_TYPE_forma">
  38. <xs:restriction base="default_db__x3A__DEVICES:T_DEVICE_TYPE">
  39. <xs:enumeration value="FORMA"/>
  40. </xs:restriction>
  41. </xs:simpleType>
  42. <xs:simpleType id="a3A__DEVICES___d5e8559-1_T_DEVICE_T" name="T_DEVICE_TYPE_maszyna">
  43. <xs:restriction base="default_db__x3A__DEVICES:T_DEVICE_TYPE">
  44. <xs:enumeration value="MASZYNA"/>
  45. </xs:restriction>
  46. </xs:simpleType>
  47. <xs:complexType name="DEVICES" id="a3A__DEVICES___d5e78890-1_DEVICES">
  48. <xs:sequence id="a3A__DEVICES___d5e78891-1">
  49. <!--<xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner"
  50. id="a3A__DEVICES___d5e78892-1">
  51. <xs:annotation>
  52. <xs:appinfo>
  53. <system_cache__appinfo:flat_relation_cache>
  54. <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER"
  55. system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/login"/>
  56. </system_cache__appinfo:flat_relation_cache>
  57. </xs:appinfo>
  58. </xs:annotation>
  59. </xs:element>-->
  60. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
  61. id="a3A__DEVICES___d5e78897-1">
  62. <xs:annotation>
  63. <xs:appinfo>
  64. <system_cache__appinfo:flat_relation_cache>
  65. <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED"
  66. system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/uid"/>
  67. </system_cache__appinfo:flat_relation_cache>
  68. </xs:appinfo>
  69. </xs:annotation>
  70. </xs:element>-->
  71. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
  72. id="a3A__DEVICES___d5e78902-1">
  73. <xs:annotation>
  74. <xs:appinfo>
  75. <system_cache__appinfo:flat_relation_cache>
  76. <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY"
  77. system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/uid"/>
  78. </system_cache__appinfo:flat_relation_cache>
  79. </xs:appinfo>
  80. </xs:annotation>
  81. </xs:element>-->
  82. <xs:element name="ID" type="xs:integer" id="a3A__DEVICES___d5e78907-1_ID"/>
  83. <xs:element name="PARENT_ID" type="xs:integer" id="a3A__DEVICES___d5e78908-1_PARENT_ID"
  84. minOccurs="0"/>
  85. <xs:element ref="default_db__x3A__DEVICES:DEVICES" minOccurs="0">
  86. <xs:annotation>
  87. <xs:appinfo>
  88. <system_cache__appinfo:flat_relation_cache>
  89. <system_cache__appinfo:source system_cache__appinfo:name="PARENT_ID" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__DEVICES:DEVICES/ID"/>
  90. </system_cache__appinfo:flat_relation_cache>
  91. </xs:appinfo>
  92. </xs:annotation>
  93. </xs:element>
  94. <xs:element name="A_RECORD_CREATE_DATE" type="xs:string"
  95. id="a3A__DEVICES___d5e78909-1_A_RECORD_C"/>
  96. <xs:element name="A_RECORD_CREATE_AUTHOR" type="xs:string"
  97. id="a3A__DEVICES___d5e78910-1_A_RECORD_C"/>
  98. <xs:element name="A_RECORD_UPDATE_DATE" type="xs:string"
  99. id="a3A__DEVICES___d5e78911-1_A_RECORD_U"/>
  100. <xs:element name="A_RECORD_UPDATE_AUTHOR" type="xs:string"
  101. id="a3A__DEVICES___d5e78912-1_A_RECORD_U"/>
  102. <xs:element name="A_PROBLEM" type="xs:string" id="a3A__DEVICES___d5e78913-1_A_PROBLEM"/>
  103. <xs:element name="A_PROBLEM_DESC" type="xs:string"
  104. id="a3A__DEVICES___d5e78914-1_A_PROBLEM_"/>
  105. <xs:element name="A_PROBLEM_DATE" type="xs:string"
  106. id="a3A__DEVICES___d5e78916-1_A_PROBLEM_"/>
  107. <xs:element name="A_STATUS" type="xs:string" id="a3A__DEVICES___d5e78917-1_A_STATUS"/>
  108. <xs:element name="A_STATUS_EV" type="xs:string" id="a3A__DEVICES___d5e78918-1_A_STATUS_E"/>
  109. <xs:element name="A_STATUS_INFO" type="xs:string" id="a3A__DEVICES___d5e78919-1_A_STATUS_I"/>
  110. <xs:element name="A_STATUS_LASTCHANGE_DATE" type="xs:string"
  111. id="a3A__DEVICES___d5e78920-1_A_STATUS_L"/>
  112. <xs:element name="IN7_DZIENNIK_KORESP_ID" type="xs:integer"
  113. id="a3A__DEVICES___d5e78921-1_IN7_DZIENN"/>
  114. <xs:element name="IN7_DZIENNIK_KORESP_ID_ZAMOWIENIE" type="xs:integer"
  115. id="a3A__DEVICES___d5e78922-1_IN7_DZIENN"/>
  116. <xs:element name="A_UPDATE_DATE" type="xs:string" id="a3A__DEVICES___d5e78923-1_A_UPDATE_D"/>
  117. <xs:element name="A_ADM_COMPANY" type="xs:string" id="a3A__DEVICES___d5e78924-1_A_ADM_COMP"/>
  118. <xs:element name="S_ADDRESS_CITY" type="xs:string"
  119. id="a3A__DEVICES___d5e78925-1_S_ADDRESS_"/>
  120. <xs:element name="S_ADDRESS_POST_CODE" type="xs:string"
  121. id="a3A__DEVICES___d5e78926-1_S_ADDRESS_"/>
  122. <xs:element name="S_ADDRESS_POST_OFFICE" type="xs:string"
  123. id="a3A__DEVICES___d5e78928-1_S_ADDRESS_"/>
  124. <xs:element name="S_ADDRESS_STREET" type="xs:string"
  125. id="a3A__DEVICES___d5e78929-1_S_ADDRESS_"/>
  126. <xs:element name="S_ADDRESS_HOUSE" type="xs:string"
  127. id="a3A__DEVICES___d5e78930-1_S_ADDRESS_"/>
  128. <xs:element name="S_OTHER_INFO" type="xs:string" id="a3A__DEVICES___d5e78931-1_S_OTHER_IN"/>
  129. <xs:element name="S_IP" type="xs:string" id="a3A__DEVICES___d5e78932-1_S_IP"/>
  130. <xs:element name="T_NETWORK_SERVER" type="xs:string"
  131. id="a3A__DEVICES___d5e78933-1_T_NETWORK_"/>
  132. <xs:element name="T_TOPOLOGY_PLACE" type="xs:string"
  133. id="a3A__DEVICES___d5e78934-1_T_TOPOLOGY"/>
  134. <xs:element name="T_DEVICE_SERIAL" type="xs:string"
  135. id="a3A__DEVICES___d5e78935-1_T_DEVICE_S"/>
  136. <xs:element name="T_DEVICE_TYPE" type="default_db__x3A__DEVICES:T_DEVICE_TYPE"
  137. id="a3A__DEVICES___d5e78936-1_T_DEVICE_T"/>
  138. <xs:element name="T_DEVICE_PORTS_OK" type="xs:integer"
  139. id="a3A__DEVICES___d5e78937-1_T_DEVICE_P"/>
  140. <xs:element name="T_DEVICE_INFO" type="xs:string" id="a3A__DEVICES___d5e78938-1_T_DEVICE_I"/>
  141. <xs:element name="T_DEVICE_POWER" type="xs:string"
  142. id="a3A__DEVICES___d5e78940-1_T_DEVICE_P"/>
  143. <xs:element name="T_TELBOX_NEIGHBOUR_IN" type="xs:string"
  144. id="a3A__DEVICES___d5e78941-1_T_TELBOX_N"/>
  145. <xs:element name="T_TELBOX_NEIGHBOUR_IN_ID" type="xs:integer"
  146. id="a3A__DEVICES___d5e78942-1_T_TELBOX_N"/>
  147. <xs:element name="the_geom" type="xs:string" id="a3A__DEVICES___d5e78943-1_the_geom"/>
  148. <xs:element name="T_WORKPOINTS" type="xs:string" id="a3A__DEVICES___d5e78944-1_T_WORKPOIN"/>
  149. <xs:element name="T_WORKPOINTS_VALUE" type="xs:string"
  150. id="a3A__DEVICES___d5e78945-1_T_WORKPOIN"/>
  151. <xs:element name="T_WORKPOINTS_TYPE" type="xs:string"
  152. id="a3A__DEVICES___d5e78946-1_T_WORKPOIN"/>
  153. <xs:element name="T_WORKPOINTS_USER" type="xs:string"
  154. id="a3A__DEVICES___d5e78947-1_T_WORKPOIN"/>
  155. <xs:element name="T_WORKPOINTS_DATE" type="xs:string"
  156. id="a3A__DEVICES___d5e78948-1_T_WORKPOIN"/>
  157. <xs:element name="T_PENALTIES" type="xs:string" id="a3A__DEVICES___d5e78949-1_T_PENALTIE"/>
  158. <xs:element name="T_PENALTIES_TYPE" type="xs:string"
  159. id="a3A__DEVICES___d5e78950-1_T_PENALTIE"/>
  160. <xs:element name="T_PENALTIES_VALUE" type="xs:string"
  161. id="a3A__DEVICES___d5e78952-1_T_PENALTIE"/>
  162. <xs:element name="T_WHO_CONNECTED" type="xs:string"
  163. id="a3A__DEVICES___d5e78953-1_T_WHO_CONN"/>
  164. <xs:element name="T_WHEN_CONNECTED" type="xs:string"
  165. id="a3A__DEVICES___d5e78954-1_T_WHEN_CON"/>
  166. <xs:element name="T_PRODUCER" type="xs:string" id="a3A__DEVICES___d5e78955-1_T_PRODUCER"/>
  167. <xs:element name="T_PRODUCTION_DATE" type="xs:string"
  168. id="a3A__DEVICES___d5e78956-1_T_PRODUCTI"/>
  169. <xs:element name="T_BUY_DATE" type="xs:token" id="a3A__DEVICES___d5e78957-1_T_BUY_DATE"/>
  170. <xs:element name="T_SELLER" type="xs:string" id="a3A__DEVICES___d5e78958-1_T_SELLER"/>
  171. <xs:element name="T_OWNER" type="xs:string" id="a3A__DEVICES___d5e78959-1_T_OWNER"/>
  172. <xs:element name="T_GUARRANTY_EXPIRE" type="xs:string"
  173. id="a3A__DEVICES___d5e78960-1_T_GUARRANT"/>
  174. <xs:element name="T_PAPERBOX_LOCATION" type="xs:string"
  175. id="a3A__DEVICES___d5e78961-1_T_PAPERBOX"/>
  176. <xs:element name="F_BILL_DATE" type="xs:token" id="a3A__DEVICES___d5e78962-1_F_BILL_DAT"/>
  177. <xs:element name="F_BILL_NUMBER" type="xs:string" id="a3A__DEVICES___d5e78964-1_F_BILL_NUM"/>
  178. <xs:element name="F_BILL_POSITION" type="xs:string"
  179. id="a3A__DEVICES___d5e78965-1_F_BILL_POS"/>
  180. <xs:element name="F_BILL_COST" type="xs:double" id="a3A__DEVICES___d5e78966-1_F_BILL_COS"/>
  181. <xs:element name="F_MONTHLY_LEASE_COST" type="xs:double"
  182. id="a3A__DEVICES___d5e78967-1_F_MONTHLY_"/>
  183. <xs:element name="F_DEPTECIATION_LENGTH_YEARS" type="xs:string"
  184. id="a3A__DEVICES___d5e78968-1_F_DEPTECIA"/>
  185. <xs:element name="S_HW" type="xs:string" id="a3A__DEVICES___d5e78969-1_S_HW"/>
  186. <xs:element name="CRM_LISTA_ZASOBOW_ID" type="xs:integer"
  187. id="a3A__DEVICES___d5e78970-1_CRM_LISTA_"/>
  188. <xs:element name="CRM_LISTA_ZASOBOW_xpath" type="xs:string"
  189. id="a3A__DEVICES___d5e78971-1_CRM_LISTA_"/>
  190. <xs:element name="ID_PROJECT" type="xs:integer" id="a3A__DEVICES___d5e78972-1_ID_PROJECT"/>
  191. <xs:element name="L_APPOITMENT_DATE" type="xs:string"
  192. id="a3A__DEVICES___d5e78973-1_L_APPOITME"/>
  193. <xs:element name="L_APPOITMENT_USER" type="xs:string"
  194. id="a3A__DEVICES___d5e78974-1_L_APPOITME"/>
  195. <xs:element name="L_APPOITMENT_PERIOD" type="xs:string"
  196. id="a3A__DEVICES___d5e78976-1_L_APPOITME"/>
  197. <xs:element name="L_APPOITMENT_INFO" type="xs:string"
  198. id="a3A__DEVICES___d5e78977-1_L_APPOITME"/>
  199. <xs:element name="L_APPOITMENT_TYPE" type="xs:string"
  200. id="a3A__DEVICES___d5e78978-1_L_APPOITME"/>
  201. <xs:element name="L_CALENDAR" type="xs:string" id="a3A__DEVICES___d5e78979-1_L_CALENDAR"/>
  202. <xs:element name="P_ACCOUNT" type="xs:string" id="a3A__DEVICES___d5e78980-1_P_ACCOUNT"/>
  203. <xs:element name="ID_BILLING_USERS" type="xs:integer"
  204. id="a3A__DEVICES___d5e78981-1_ID_BILLING"/>
  205. <xs:element name="ID_SERVICES" type="xs:integer" id="a3A__DEVICES___d5e78982-1_ID_SERVICE"/>
  206. <xs:element name="A_CLASSIFIED" type="xs:string" id="a3A__DEVICES___d5e78983-1_A_CLASSIFI"/>
  207. <xs:element name="ADM_PASSWD" type="xs:string" id="a3A__DEVICES___d5e78984-1_ADM_PASSWD"/>
  208. <xs:element name="S_PASSWD" type="xs:string" id="a3A__DEVICES___d5e78985-1_S_PASSWD"/>
  209. <xs:element name="ADMIN_USERS_ID" type="xs:integer"
  210. id="a3A__DEVICES___d5e78988-1_ADMIN_USER"/>
  211. <xs:element ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS" maxOccurs="1" minOccurs="0">
  212. <xs:annotation>
  213. <xs:appinfo>
  214. <system_cache__appinfo:flat_relation_cache>
  215. <system_cache__appinfo:source system_cache__appinfo:name="ADMIN_USERS_ID" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS/ID"/>
  216. </system_cache__appinfo:flat_relation_cache>
  217. </xs:appinfo>
  218. </xs:annotation>
  219. </xs:element>
  220. </xs:sequence>
  221. <xs:attribute name="label" type="xs:string"/>
  222. <xs:assert test="@label = concat(ID, ' ', T_DEVICE_TYPE)"/>
  223. </xs:complexType>
  224. <xs:element name="DEVICES" type="default_db__x3A__DEVICES:DEVICES"
  225. id="a3A__DEVICES___d5e78989-1_DEVICES"/>
  226. <xs:complexType id="a3A__DEVICES___d5e8569-1_MASZYNA" name="MASZYNA">
  227. <xs:complexContent id="a3A__DEVICES___d5e8570-1">
  228. <xs:restriction base="default_db__x3A__DEVICES:DEVICES">
  229. <xs:sequence id="a3A__DEVICES___d5e78994-1">
  230. <!--<xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner"
  231. id="a3A__DEVICES___d5e78995-1">
  232. <xs:annotation>
  233. <xs:appinfo>
  234. <system_cache__appinfo:flat_relation_cache>
  235. <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER" system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/login"/>
  236. </system_cache__appinfo:flat_relation_cache>
  237. </xs:appinfo>
  238. </xs:annotation>
  239. </xs:element>-->
  240. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
  241. id="a3A__DEVICES___d5e79000-1">
  242. <xs:annotation>
  243. <xs:appinfo>
  244. <system_cache__appinfo:flat_relation_cache>
  245. <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/uid"/>
  246. </system_cache__appinfo:flat_relation_cache>
  247. </xs:appinfo>
  248. </xs:annotation>
  249. </xs:element>-->
  250. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
  251. id="a3A__DEVICES___d5e79005-1">
  252. <xs:annotation>
  253. <xs:appinfo>
  254. <system_cache__appinfo:flat_relation_cache>
  255. <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/uid"/>
  256. </system_cache__appinfo:flat_relation_cache>
  257. </xs:appinfo>
  258. </xs:annotation>
  259. </xs:element>-->
  260. <xs:element name="ID" type="xs:integer" id="a3A__DEVICES___d5e79010-1_ID"/>
  261. <xs:element name="PARENT_ID" type="xs:integer"
  262. id="a3A__DEVICES___d5e79011-1_PARENT_ID" minOccurs="0"/>
  263. <xs:element ref="default_db__x3A__DEVICES:DEVICES" minOccurs="0">
  264. <xs:annotation>
  265. <xs:appinfo>
  266. <system_cache__appinfo:flat_relation_cache>
  267. <system_cache__appinfo:source system_cache__appinfo:name="PARENT_ID" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__DEVICES:DEVICES/ID"/>
  268. </system_cache__appinfo:flat_relation_cache>
  269. </xs:appinfo>
  270. </xs:annotation>
  271. </xs:element>
  272. <xs:element name="A_RECORD_CREATE_DATE" type="xs:string"
  273. id="a3A__DEVICES___d5e79012-1_A_RECORD_C"/>
  274. <xs:element name="A_RECORD_CREATE_AUTHOR" type="xs:string"
  275. id="a3A__DEVICES___d5e79013-1_A_RECORD_C"/>
  276. <xs:element name="A_RECORD_UPDATE_DATE" type="xs:string"
  277. id="a3A__DEVICES___d5e79014-1_A_RECORD_U"/>
  278. <xs:element name="A_RECORD_UPDATE_AUTHOR" type="xs:string"
  279. id="a3A__DEVICES___d5e79015-1_A_RECORD_U"/>
  280. <xs:element name="A_PROBLEM" type="xs:string"
  281. id="a3A__DEVICES___d5e79016-1_A_PROBLEM"/>
  282. <xs:element name="A_PROBLEM_DESC" type="xs:string"
  283. id="a3A__DEVICES___d5e79017-1_A_PROBLEM_"/>
  284. <xs:element name="A_PROBLEM_DATE" type="xs:string"
  285. id="a3A__DEVICES___d5e79019-1_A_PROBLEM_"/>
  286. <xs:element name="A_STATUS" type="xs:string" id="a3A__DEVICES___d5e79020-1_A_STATUS"/>
  287. <xs:element name="A_STATUS_EV" type="xs:string"
  288. id="a3A__DEVICES___d5e79021-1_A_STATUS_E"/>
  289. <xs:element name="A_STATUS_INFO" type="xs:string"
  290. id="a3A__DEVICES___d5e79022-1_A_STATUS_I"/>
  291. <xs:element name="A_STATUS_LASTCHANGE_DATE" type="xs:string"
  292. id="a3A__DEVICES___d5e79023-1_A_STATUS_L"/>
  293. <xs:element name="IN7_DZIENNIK_KORESP_ID" type="xs:integer"
  294. id="a3A__DEVICES___d5e79024-1_IN7_DZIENN"/>
  295. <xs:element name="IN7_DZIENNIK_KORESP_ID_ZAMOWIENIE" type="xs:integer"
  296. id="a3A__DEVICES___d5e79025-1_IN7_DZIENN"/>
  297. <xs:element name="A_UPDATE_DATE" type="xs:string"
  298. id="a3A__DEVICES___d5e79026-1_A_UPDATE_D"/>
  299. <xs:element name="A_ADM_COMPANY" type="xs:string"
  300. id="a3A__DEVICES___d5e79027-1_A_ADM_COMP"/>
  301. <xs:element name="S_ADDRESS_CITY" type="xs:string"
  302. id="a3A__DEVICES___d5e79028-1_S_ADDRESS_"/>
  303. <xs:element name="S_ADDRESS_POST_CODE" type="xs:string"
  304. id="a3A__DEVICES___d5e79029-1_S_ADDRESS_"/>
  305. <xs:element name="S_ADDRESS_POST_OFFICE" type="xs:string"
  306. id="a3A__DEVICES___d5e79031-1_S_ADDRESS_"/>
  307. <xs:element name="S_ADDRESS_STREET" type="xs:string"
  308. id="a3A__DEVICES___d5e79032-1_S_ADDRESS_"/>
  309. <xs:element name="S_ADDRESS_HOUSE" type="xs:string"
  310. id="a3A__DEVICES___d5e79033-1_S_ADDRESS_"/>
  311. <xs:element name="S_OTHER_INFO" type="xs:string"
  312. id="a3A__DEVICES___d5e79034-1_S_OTHER_IN"/>
  313. <xs:element name="S_IP" type="xs:string" id="a3A__DEVICES___d5e79035-1_S_IP"/>
  314. <xs:element name="T_NETWORK_SERVER" type="xs:string"
  315. id="a3A__DEVICES___d5e79036-1_T_NETWORK_"/>
  316. <xs:element name="T_TOPOLOGY_PLACE" type="xs:string"
  317. id="a3A__DEVICES___d5e79037-1_T_TOPOLOGY"/>
  318. <xs:element name="T_DEVICE_SERIAL" type="xs:string"
  319. id="a3A__DEVICES___d5e79038-1_T_DEVICE_S"/>
  320. <xs:element name="T_DEVICE_TYPE"
  321. type="default_db__x3A__DEVICES:T_DEVICE_TYPE_maszyna"
  322. id="a3A__DEVICES___d5e79039-1_T_DEVICE_T"/>
  323. <xs:element name="T_DEVICE_PORTS_OK" type="xs:integer"
  324. id="a3A__DEVICES___d5e79040-1_T_DEVICE_P"/>
  325. <xs:element name="T_DEVICE_INFO" type="xs:string"
  326. id="a3A__DEVICES___d5e79041-1_T_DEVICE_I"/>
  327. <xs:element name="T_DEVICE_POWER" type="xs:string"
  328. id="a3A__DEVICES___d5e79043-1_T_DEVICE_P"/>
  329. <xs:element name="T_TELBOX_NEIGHBOUR_IN" type="xs:string"
  330. id="a3A__DEVICES___d5e79044-1_T_TELBOX_N"/>
  331. <xs:element name="T_TELBOX_NEIGHBOUR_IN_ID" type="xs:integer"
  332. id="a3A__DEVICES___d5e79045-1_T_TELBOX_N"/>
  333. <xs:element name="the_geom" type="xs:string" id="a3A__DEVICES___d5e79046-1_the_geom"/>
  334. <xs:element name="T_WORKPOINTS" type="xs:string"
  335. id="a3A__DEVICES___d5e79047-1_T_WORKPOIN"/>
  336. <xs:element name="T_WORKPOINTS_VALUE" type="xs:string"
  337. id="a3A__DEVICES___d5e79048-1_T_WORKPOIN"/>
  338. <xs:element name="T_WORKPOINTS_TYPE" type="xs:string"
  339. id="a3A__DEVICES___d5e79049-1_T_WORKPOIN"/>
  340. <xs:element name="T_WORKPOINTS_USER" type="xs:string"
  341. id="a3A__DEVICES___d5e79050-1_T_WORKPOIN"/>
  342. <xs:element name="T_WORKPOINTS_DATE" type="xs:string"
  343. id="a3A__DEVICES___d5e79051-1_T_WORKPOIN"/>
  344. <xs:element name="T_PENALTIES" type="xs:string"
  345. id="a3A__DEVICES___d5e79052-1_T_PENALTIE"/>
  346. <xs:element name="T_PENALTIES_TYPE" type="xs:string"
  347. id="a3A__DEVICES___d5e79053-1_T_PENALTIE"/>
  348. <xs:element name="T_PENALTIES_VALUE" type="xs:string"
  349. id="a3A__DEVICES___d5e79055-1_T_PENALTIE"/>
  350. <xs:element name="T_WHO_CONNECTED" type="xs:string"
  351. id="a3A__DEVICES___d5e79056-1_T_WHO_CONN"/>
  352. <xs:element name="T_WHEN_CONNECTED" type="xs:string"
  353. id="a3A__DEVICES___d5e79057-1_T_WHEN_CON"/>
  354. <xs:element name="T_PRODUCER" type="xs:string"
  355. id="a3A__DEVICES___d5e79058-1_T_PRODUCER"/>
  356. <xs:element name="T_PRODUCTION_DATE" type="xs:string"
  357. id="a3A__DEVICES___d5e79059-1_T_PRODUCTI"/>
  358. <xs:element name="T_BUY_DATE" type="xs:token"
  359. id="a3A__DEVICES___d5e79060-1_T_BUY_DATE"/>
  360. <xs:element name="T_SELLER" type="xs:string" id="a3A__DEVICES___d5e79061-1_T_SELLER"/>
  361. <xs:element name="T_OWNER" type="xs:string" id="a3A__DEVICES___d5e79062-1_T_OWNER"/>
  362. <xs:element name="T_GUARRANTY_EXPIRE" type="xs:string"
  363. id="a3A__DEVICES___d5e79063-1_T_GUARRANT"/>
  364. <xs:element name="T_PAPERBOX_LOCATION" type="xs:string"
  365. id="a3A__DEVICES___d5e79064-1_T_PAPERBOX"/>
  366. <xs:element name="F_BILL_DATE" type="xs:token"
  367. id="a3A__DEVICES___d5e79065-1_F_BILL_DAT"/>
  368. <xs:element name="F_BILL_NUMBER" type="xs:string"
  369. id="a3A__DEVICES___d5e79067-1_F_BILL_NUM"/>
  370. <xs:element name="F_BILL_POSITION" type="xs:string"
  371. id="a3A__DEVICES___d5e79068-1_F_BILL_POS"/>
  372. <xs:element name="F_BILL_COST" type="xs:double"
  373. id="a3A__DEVICES___d5e79069-1_F_BILL_COS"/>
  374. <xs:element name="F_MONTHLY_LEASE_COST" type="xs:double"
  375. id="a3A__DEVICES___d5e79070-1_F_MONTHLY_"/>
  376. <xs:element name="F_DEPTECIATION_LENGTH_YEARS" type="xs:string"
  377. id="a3A__DEVICES___d5e79071-1_F_DEPTECIA"/>
  378. <xs:element name="S_HW" type="xs:string" id="a3A__DEVICES___d5e79072-1_S_HW"/>
  379. <xs:element name="CRM_LISTA_ZASOBOW_ID" type="xs:integer"
  380. id="a3A__DEVICES___d5e79073-1_CRM_LISTA_"/>
  381. <xs:element name="CRM_LISTA_ZASOBOW_xpath" type="xs:string"
  382. id="a3A__DEVICES___d5e79074-1_CRM_LISTA_"/>
  383. <xs:element name="ID_PROJECT" type="xs:integer"
  384. id="a3A__DEVICES___d5e79075-1_ID_PROJECT"/>
  385. <xs:element name="L_APPOITMENT_DATE" type="xs:string"
  386. id="a3A__DEVICES___d5e79076-1_L_APPOITME"/>
  387. <xs:element name="L_APPOITMENT_USER" type="xs:string"
  388. id="a3A__DEVICES___d5e79077-1_L_APPOITME"/>
  389. <xs:element name="L_APPOITMENT_PERIOD" type="xs:string"
  390. id="a3A__DEVICES___d5e79079-1_L_APPOITME"/>
  391. <xs:element name="L_APPOITMENT_INFO" type="xs:string"
  392. id="a3A__DEVICES___d5e79080-1_L_APPOITME"/>
  393. <xs:element name="L_APPOITMENT_TYPE" type="xs:string"
  394. id="a3A__DEVICES___d5e79081-1_L_APPOITME"/>
  395. <xs:element name="L_CALENDAR" type="xs:string"
  396. id="a3A__DEVICES___d5e79082-1_L_CALENDAR"/>
  397. <xs:element name="P_ACCOUNT" type="xs:string"
  398. id="a3A__DEVICES___d5e79083-1_P_ACCOUNT"/>
  399. <xs:element name="ID_BILLING_USERS" type="xs:integer"
  400. id="a3A__DEVICES___d5e79084-1_ID_BILLING"/>
  401. <xs:element name="ID_SERVICES" type="xs:integer"
  402. id="a3A__DEVICES___d5e79085-1_ID_SERVICE"/>
  403. <xs:element name="A_CLASSIFIED" type="xs:string"
  404. id="a3A__DEVICES___d5e79086-1_A_CLASSIFI"/>
  405. <xs:element name="ADM_PASSWD" type="xs:string"
  406. id="a3A__DEVICES___d5e79087-1_ADM_PASSWD"/>
  407. <xs:element name="S_PASSWD" type="xs:string" id="a3A__DEVICES___d5e79088-1_S_PASSWD"/>
  408. <xs:element name="ADMIN_USERS_ID" type="xs:integer"
  409. id="a3A__DEVICES___d5e79091-1_ADMIN_USER"/>
  410. <xs:element ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS" maxOccurs="1"
  411. minOccurs="0">
  412. <xs:annotation>
  413. <xs:appinfo>
  414. <system_cache__appinfo:flat_relation_cache>
  415. <system_cache__appinfo:source system_cache__appinfo:name="ADMIN_USERS_ID" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS/ID"/>
  416. </system_cache__appinfo:flat_relation_cache>
  417. </xs:appinfo>
  418. </xs:annotation>
  419. </xs:element>
  420. </xs:sequence>
  421. <xs:attribute name="label" type="xs:string"/>
  422. <xs:assert test="@label = concat(ID, ' ', T_DEVICE_TYPE)"/>
  423. </xs:restriction>
  424. </xs:complexContent>
  425. </xs:complexType>
  426. <xs:element id="a3A__DEVICES___d5e8586-1_FORMA" name="FORMA"
  427. type="default_db__x3A__DEVICES:FORMA"/>
  428. <xs:complexType id="a3A__DEVICES___d5e8578-1_FORMA" name="FORMA">
  429. <xs:complexContent id="a3A__DEVICES___d5e8579-1">
  430. <xs:restriction base="default_db__x3A__DEVICES:DEVICES">
  431. <xs:sequence id="a3A__DEVICES___d5e79096-1">
  432. <!--<xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner"
  433. id="a3A__DEVICES___d5e79097-1">
  434. <xs:annotation>
  435. <xs:appinfo>
  436. <system_cache__appinfo:flat_relation_cache>
  437. <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER" system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/login"/>
  438. </system_cache__appinfo:flat_relation_cache>
  439. </xs:appinfo>
  440. </xs:annotation>
  441. </xs:element>-->
  442. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
  443. id="a3A__DEVICES___d5e79102-1">
  444. <xs:annotation>
  445. <xs:appinfo>
  446. <system_cache__appinfo:flat_relation_cache>
  447. <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/uid"/>
  448. </system_cache__appinfo:flat_relation_cache>
  449. </xs:appinfo>
  450. </xs:annotation>
  451. </xs:element>-->
  452. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
  453. id="a3A__DEVICES___d5e79107-1">
  454. <xs:annotation>
  455. <xs:appinfo>
  456. <system_cache__appinfo:flat_relation_cache>
  457. <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/uid"/>
  458. </system_cache__appinfo:flat_relation_cache>
  459. </xs:appinfo>
  460. </xs:annotation>
  461. </xs:element>-->
  462. <xs:element name="ID" type="xs:integer" id="a3A__DEVICES___d5e79112-1_ID"/>
  463. <xs:element name="PARENT_ID" type="xs:integer"
  464. id="a3A__DEVICES___d5e79113-1_PARENT_ID"/>
  465. <xs:element ref="default_db__x3A__DEVICES:DEVICES" minOccurs="0">
  466. <xs:annotation>
  467. <xs:appinfo>
  468. <system_cache__appinfo:flat_relation_cache>
  469. <system_cache__appinfo:source system_cache__appinfo:name="PARENT_ID" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__DEVICES:DEVICES/ID"/>
  470. </system_cache__appinfo:flat_relation_cache>
  471. </xs:appinfo>
  472. </xs:annotation>
  473. </xs:element>
  474. <xs:element name="A_RECORD_CREATE_DATE" type="xs:string"
  475. id="a3A__DEVICES___d5e79114-1_A_RECORD_C"/>
  476. <xs:element name="A_RECORD_CREATE_AUTHOR" type="xs:string"
  477. id="a3A__DEVICES___d5e79115-1_A_RECORD_C"/>
  478. <xs:element name="A_RECORD_UPDATE_DATE" type="xs:string"
  479. id="a3A__DEVICES___d5e79116-1_A_RECORD_U"/>
  480. <xs:element name="A_RECORD_UPDATE_AUTHOR" type="xs:string"
  481. id="a3A__DEVICES___d5e79117-1_A_RECORD_U"/>
  482. <xs:element name="A_PROBLEM" type="xs:string"
  483. id="a3A__DEVICES___d5e79118-1_A_PROBLEM"/>
  484. <xs:element name="A_PROBLEM_DESC" type="xs:string"
  485. id="a3A__DEVICES___d5e79119-1_A_PROBLEM_"/>
  486. <xs:element name="A_PROBLEM_DATE" type="xs:string"
  487. id="a3A__DEVICES___d5e79121-1_A_PROBLEM_"/>
  488. <xs:element name="A_STATUS" type="xs:string" id="a3A__DEVICES___d5e79122-1_A_STATUS"/>
  489. <xs:element name="A_STATUS_EV" type="xs:string"
  490. id="a3A__DEVICES___d5e79123-1_A_STATUS_E"/>
  491. <xs:element name="A_STATUS_INFO" type="xs:string"
  492. id="a3A__DEVICES___d5e79124-1_A_STATUS_I"/>
  493. <xs:element name="A_STATUS_LASTCHANGE_DATE" type="xs:string"
  494. id="a3A__DEVICES___d5e79125-1_A_STATUS_L"/>
  495. <xs:element name="IN7_DZIENNIK_KORESP_ID" type="xs:integer"
  496. id="a3A__DEVICES___d5e79126-1_IN7_DZIENN"/>
  497. <xs:element name="IN7_DZIENNIK_KORESP_ID_ZAMOWIENIE" type="xs:integer"
  498. id="a3A__DEVICES___d5e79127-1_IN7_DZIENN"/>
  499. <xs:element name="A_UPDATE_DATE" type="xs:string"
  500. id="a3A__DEVICES___d5e79128-1_A_UPDATE_D"/>
  501. <xs:element name="A_ADM_COMPANY" type="xs:string"
  502. id="a3A__DEVICES___d5e79129-1_A_ADM_COMP"/>
  503. <xs:element name="S_ADDRESS_CITY" type="xs:string"
  504. id="a3A__DEVICES___d5e79130-1_S_ADDRESS_"/>
  505. <xs:element name="S_ADDRESS_POST_CODE" type="xs:string"
  506. id="a3A__DEVICES___d5e79131-1_S_ADDRESS_"/>
  507. <xs:element name="S_ADDRESS_POST_OFFICE" type="xs:string"
  508. id="a3A__DEVICES___d5e79133-1_S_ADDRESS_"/>
  509. <xs:element name="S_ADDRESS_STREET" type="xs:string"
  510. id="a3A__DEVICES___d5e79134-1_S_ADDRESS_"/>
  511. <xs:element name="S_ADDRESS_HOUSE" type="xs:string"
  512. id="a3A__DEVICES___d5e79135-1_S_ADDRESS_"/>
  513. <xs:element name="S_OTHER_INFO" type="xs:string"
  514. id="a3A__DEVICES___d5e79136-1_S_OTHER_IN"/>
  515. <xs:element name="S_IP" type="xs:string" id="a3A__DEVICES___d5e79137-1_S_IP"/>
  516. <xs:element name="T_NETWORK_SERVER" type="xs:string"
  517. id="a3A__DEVICES___d5e79138-1_T_NETWORK_"/>
  518. <xs:element name="T_TOPOLOGY_PLACE" type="xs:string"
  519. id="a3A__DEVICES___d5e79139-1_T_TOPOLOGY"/>
  520. <xs:element name="T_DEVICE_SERIAL" type="xs:string"
  521. id="a3A__DEVICES___d5e79140-1_T_DEVICE_S"/>
  522. <xs:element name="T_DEVICE_TYPE" type="default_db__x3A__DEVICES:T_DEVICE_TYPE_forma"
  523. id="a3A__DEVICES___d5e79141-1_T_DEVICE_T"/>
  524. <xs:element name="T_DEVICE_PORTS_OK" type="xs:integer"
  525. id="a3A__DEVICES___d5e79142-1_T_DEVICE_P"/>
  526. <xs:element name="T_DEVICE_INFO" type="xs:string"
  527. id="a3A__DEVICES___d5e79143-1_T_DEVICE_I"/>
  528. <xs:element name="T_DEVICE_POWER" type="xs:string"
  529. id="a3A__DEVICES___d5e79145-1_T_DEVICE_P"/>
  530. <xs:element name="T_TELBOX_NEIGHBOUR_IN" type="xs:string"
  531. id="a3A__DEVICES___d5e79146-1_T_TELBOX_N"/>
  532. <xs:element name="T_TELBOX_NEIGHBOUR_IN_ID" type="xs:integer"
  533. id="a3A__DEVICES___d5e79147-1_T_TELBOX_N"/>
  534. <xs:element name="the_geom" type="xs:string" id="a3A__DEVICES___d5e79148-1_the_geom"/>
  535. <xs:element name="T_WORKPOINTS" type="xs:string"
  536. id="a3A__DEVICES___d5e79149-1_T_WORKPOIN"/>
  537. <xs:element name="T_WORKPOINTS_VALUE" type="xs:string"
  538. id="a3A__DEVICES___d5e79150-1_T_WORKPOIN"/>
  539. <xs:element name="T_WORKPOINTS_TYPE" type="xs:string"
  540. id="a3A__DEVICES___d5e79151-1_T_WORKPOIN"/>
  541. <xs:element name="T_WORKPOINTS_USER" type="xs:string"
  542. id="a3A__DEVICES___d5e79152-1_T_WORKPOIN"/>
  543. <xs:element name="T_WORKPOINTS_DATE" type="xs:string"
  544. id="a3A__DEVICES___d5e79153-1_T_WORKPOIN"/>
  545. <xs:element name="T_PENALTIES" type="xs:string"
  546. id="a3A__DEVICES___d5e79154-1_T_PENALTIE"/>
  547. <xs:element name="T_PENALTIES_TYPE" type="xs:string"
  548. id="a3A__DEVICES___d5e79155-1_T_PENALTIE"/>
  549. <xs:element name="T_PENALTIES_VALUE" type="xs:string"
  550. id="a3A__DEVICES___d5e79157-1_T_PENALTIE"/>
  551. <xs:element name="T_WHO_CONNECTED" type="xs:string"
  552. id="a3A__DEVICES___d5e79158-1_T_WHO_CONN"/>
  553. <xs:element name="T_WHEN_CONNECTED" type="xs:string"
  554. id="a3A__DEVICES___d5e79159-1_T_WHEN_CON"/>
  555. <xs:element name="T_PRODUCER" type="xs:string"
  556. id="a3A__DEVICES___d5e79160-1_T_PRODUCER"/>
  557. <xs:element name="T_PRODUCTION_DATE" type="xs:string"
  558. id="a3A__DEVICES___d5e79161-1_T_PRODUCTI"/>
  559. <xs:element name="T_BUY_DATE" type="xs:token"
  560. id="a3A__DEVICES___d5e79162-1_T_BUY_DATE"/>
  561. <xs:element name="T_SELLER" type="xs:string" id="a3A__DEVICES___d5e79163-1_T_SELLER"/>
  562. <xs:element name="T_OWNER" type="xs:string" id="a3A__DEVICES___d5e79164-1_T_OWNER"/>
  563. <xs:element name="T_GUARRANTY_EXPIRE" type="xs:string"
  564. id="a3A__DEVICES___d5e79165-1_T_GUARRANT"/>
  565. <xs:element name="T_PAPERBOX_LOCATION" type="xs:string"
  566. id="a3A__DEVICES___d5e79166-1_T_PAPERBOX"/>
  567. <xs:element name="F_BILL_DATE" type="xs:token"
  568. id="a3A__DEVICES___d5e79167-1_F_BILL_DAT"/>
  569. <xs:element name="F_BILL_NUMBER" type="xs:string"
  570. id="a3A__DEVICES___d5e79169-1_F_BILL_NUM"/>
  571. <xs:element name="F_BILL_POSITION" type="xs:string"
  572. id="a3A__DEVICES___d5e79170-1_F_BILL_POS"/>
  573. <xs:element name="F_BILL_COST" type="xs:double"
  574. id="a3A__DEVICES___d5e79171-1_F_BILL_COS"/>
  575. <xs:element name="F_MONTHLY_LEASE_COST" type="xs:double"
  576. id="a3A__DEVICES___d5e79172-1_F_MONTHLY_"/>
  577. <xs:element name="F_DEPTECIATION_LENGTH_YEARS" type="xs:string"
  578. id="a3A__DEVICES___d5e79173-1_F_DEPTECIA"/>
  579. <xs:element name="S_HW" type="xs:string" id="a3A__DEVICES___d5e79174-1_S_HW"/>
  580. <xs:element name="CRM_LISTA_ZASOBOW_ID" type="xs:integer"
  581. id="a3A__DEVICES___d5e79175-1_CRM_LISTA_"/>
  582. <xs:element name="CRM_LISTA_ZASOBOW_xpath" type="xs:string"
  583. id="a3A__DEVICES___d5e79176-1_CRM_LISTA_"/>
  584. <xs:element name="ID_PROJECT" type="xs:integer"
  585. id="a3A__DEVICES___d5e79177-1_ID_PROJECT"/>
  586. <xs:element name="L_APPOITMENT_DATE" type="xs:string"
  587. id="a3A__DEVICES___d5e79178-1_L_APPOITME"/>
  588. <xs:element name="L_APPOITMENT_USER" type="xs:string"
  589. id="a3A__DEVICES___d5e79179-1_L_APPOITME"/>
  590. <xs:element name="L_APPOITMENT_PERIOD" type="xs:string"
  591. id="a3A__DEVICES___d5e79181-1_L_APPOITME"/>
  592. <xs:element name="L_APPOITMENT_INFO" type="xs:string"
  593. id="a3A__DEVICES___d5e79182-1_L_APPOITME"/>
  594. <xs:element name="L_APPOITMENT_TYPE" type="xs:string"
  595. id="a3A__DEVICES___d5e79183-1_L_APPOITME"/>
  596. <xs:element name="L_CALENDAR" type="xs:string"
  597. id="a3A__DEVICES___d5e79184-1_L_CALENDAR"/>
  598. <xs:element name="P_ACCOUNT" type="xs:string"
  599. id="a3A__DEVICES___d5e79185-1_P_ACCOUNT"/>
  600. <xs:element name="ID_BILLING_USERS" type="xs:integer"
  601. id="a3A__DEVICES___d5e79186-1_ID_BILLING"/>
  602. <xs:element name="ID_SERVICES" type="xs:integer"
  603. id="a3A__DEVICES___d5e79187-1_ID_SERVICE"/>
  604. <xs:element name="A_CLASSIFIED" type="xs:string"
  605. id="a3A__DEVICES___d5e79188-1_A_CLASSIFI"/>
  606. <xs:element name="ADM_PASSWD" type="xs:string"
  607. id="a3A__DEVICES___d5e79189-1_ADM_PASSWD"/>
  608. <xs:element name="S_PASSWD" type="xs:string" id="a3A__DEVICES___d5e79190-1_S_PASSWD"/>
  609. <xs:element name="ADMIN_USERS_ID" type="xs:integer"
  610. id="a3A__DEVICES___d5e79193-1_ADMIN_USER"/>
  611. <xs:element ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS" maxOccurs="1"
  612. minOccurs="0">
  613. <xs:annotation>
  614. <xs:appinfo>
  615. <system_cache__appinfo:flat_relation_cache>
  616. <system_cache__appinfo:source system_cache__appinfo:name="ADMIN_USERS_ID" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS/ID"/>
  617. </system_cache__appinfo:flat_relation_cache>
  618. </xs:appinfo>
  619. </xs:annotation>
  620. </xs:element>
  621. </xs:sequence>
  622. <xs:attribute name="label" type="xs:string"/>
  623. <xs:assert test="@label = concat(ID, ' ', T_DEVICE_TYPE)"/>
  624. </xs:restriction>
  625. </xs:complexContent>
  626. </xs:complexType>
  627. <xs:element id="a3A__DEVICES___d5e8577-1_MASZYNA" name="MASZYNA"
  628. type="default_db__x3A__DEVICES:MASZYNA"/>
  629. <xs:element name="ID_DEVICE" type="default_db__x3A__DEVICES:DEVICES">
  630. <xs:annotation>
  631. <xs:documentation>Uzyte glownie w Korespondencji</xs:documentation>
  632. </xs:annotation>
  633. </xs:element>
  634. <xs:element name="PARENT_ID_DEVICE" type="default_db__x3A__DEVICES:DEVICES">
  635. <xs:annotation>
  636. <xs:documentation>Uzyte w telboxach do tworzenia struktury</xs:documentation>
  637. </xs:annotation>
  638. </xs:element>
  639. </xs:schema>