DEVICES.xsd 37 KB

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