ADMIN_USERS.xsd 63 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
  3. xmlns:default_db__x3A__ADMIN_USERS="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
  4. xmlns:gml="http://www.opengis.net/gml/3.2"
  5. xmlns:SystemObjects__x3A__AccessGroup="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessGroup.xsd"
  6. xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
  7. xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
  8. xmlns:default_db__x3A__DEVICES="https://biuro.biall-net.pl/wfs/default_db/table/DEVICES.xsd"
  9. xmlns:default_db__x3A__PROBLEMS="https://biuro.biall-net.pl/wfs/default_db/table/PROBLEMS.xsd"
  10. xmlns:default_db__x3A__USERS2_MARKETING="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_MARKETING.xsd"
  11. xmlns:default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
  12. xmlns:fix_se_defaultdb_schema="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/fix_se_defaultdb_schema/fix_se_defaultdb_schema.xsd"
  13. xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types" elementFormDefault="qualified"
  14. targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
  15. vc:minVersion="1.1">
  16. <xs:import namespace="http://biuro.biall-net.pl/p5/schema/types"
  17. schemaLocation="../../../types.xsd"/>
  18. <xs:import namespace="http://www.opengis.net/gml/3.2"
  19. schemaLocation="http://www.opengis.net/gml/3.2"/>
  20. <xs:annotation>
  21. <!--<xs:appinfo>
  22. <system_cache__appinfo:binding bindPolicy="single">
  23. <system_cache__appinfo:prefix>p5_default_db</system_cache__appinfo:prefix>
  24. <system_cache__appinfo:api type="wfs">https://biuro.biall-net.pl/SE/version-git/wfs-data.php</system_cache__appinfo:api>
  25. </system_cache__appinfo:binding>
  26. </xs:appinfo>-->
  27. <xs:documentation>Shcematy dla kont systemowych / pracownikow, ktorzy moga byc przywiazywani do stanowisk oraz moga dla nich byc zapewniane zasoby w rocumieniu odpowiedzialnosci</xs:documentation>
  28. </xs:annotation>
  29. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW.xsd"
  30. schemaLocation="../../default_db.CRM_LISTA_ZASOBOW/CRM_LISTA_ZASOBOW/CRM_LISTA_ZASOBOW.xsd"/>
  31. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/DEVICES.xsd"
  32. schemaLocation="../../default_db.DEVICES/DEVICES/DEVICES.xsd"/>
  33. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_MARKETING.xsd"
  34. schemaLocation="../../default_db.USERS2_MARKETING/USERS2_MARKETING/USERS2_MARKETING.xsd"/>
  35. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/PROBLEMS.xsd"
  36. schemaLocation="../../default_db.PROBLEMS/PROBLEMS/PROBLEMS.xsd"/>
  37. <xs:import
  38. namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
  39. schemaLocation="../../default_db.IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI.xsd"/>
  40. <xs:simpleType name="ADMIN_USERS__EMPLOYE_TYPE">
  41. <xs:restriction base="xs:string">
  42. <xs:enumeration value=""/>
  43. <xs:enumeration value="Pracownik"/>
  44. <xs:enumeration value="Kandydat"/>
  45. <xs:enumeration value="Partner"/>
  46. <xs:enumeration value="Anonymous"/>
  47. <xs:enumeration value="Kontakt"/>
  48. </xs:restriction>
  49. </xs:simpleType>
  50. <xs:simpleType name="ADMIN_USERS__EMPLOYE_TYPE__person_contact_with_details">
  51. <xs:restriction base="default_db__x3A__ADMIN_USERS:ADMIN_USERS__EMPLOYE_TYPE">
  52. <xs:enumeration value="Kontakt"/>
  53. </xs:restriction>
  54. </xs:simpleType>
  55. <xs:simpleType name="ADMIN_USERS__EMPLOYE_TYPE__worker">
  56. <xs:restriction base="default_db__x3A__ADMIN_USERS:ADMIN_USERS__EMPLOYE_TYPE">
  57. <xs:enumeration value="Pracownik"/>
  58. </xs:restriction>
  59. </xs:simpleType>
  60. <xs:simpleType name="ADMIN_USERS__A_STATUS">
  61. <xs:restriction base="xs:string">
  62. <xs:enumeration value="WAITING"/>
  63. <xs:enumeration value="NORMAL"/>
  64. <xs:enumeration value="MONITOR"/>
  65. <xs:enumeration value="WARNING"/>
  66. <xs:enumeration value="OFF_SOFT"/>
  67. <xs:enumeration value="OFF_HARD"/>
  68. <xs:enumeration value="DELETED"/>
  69. </xs:restriction>
  70. </xs:simpleType>
  71. <xs:simpleType name="ADMIN_USERS__A_STATUS_NORMAL">
  72. <xs:restriction base="default_db__x3A__ADMIN_USERS:ADMIN_USERS__A_STATUS">
  73. <xs:enumeration value="NORMAL"/>
  74. </xs:restriction>
  75. </xs:simpleType>
  76. <xs:simpleType name="ADMIN_USERS__A_STATUS_OFF_HARD">
  77. <xs:restriction base="default_db__x3A__ADMIN_USERS:ADMIN_USERS__A_STATUS">
  78. <xs:enumeration value="OFF_HARD"/>
  79. </xs:restriction>
  80. </xs:simpleType>
  81. <xs:complexType name="ADMIN_USERS" system_cache__appinfo:primaryKey="ID">
  82. <xs:annotation>
  83. <xs:appinfo>
  84. <system_cache__appinfo:heritage>
  85. <system_cache__appinfo:inherit system_cache__appinfo:inherit_ref="default_db:ADMIN_USERS" system_cache__appinfo:heritage_acl="true">
  86. <system_cache__appinfo:acl_rule_inherit_to_all_same_name_elements_and_refs/>
  87. <acl_rule_inherit_to_all_refs_by_primary/>
  88. <acl_rule_inherit_to_all_refs_by_local_element system_cache__appinfo:acl_rule_inherit_local_element_name="A_STATUS"/>
  89. </system_cache__appinfo:inherit>
  90. <system_cache__appinfo:exherit_all system_cache__appinfo:heritage_acl="true" system_cache__appinfo:heritage_sort="true"/>
  91. </system_cache__appinfo:heritage>
  92. </xs:appinfo>
  93. </xs:annotation>
  94. <xs:sequence>
  95. <xs:element name="ID" type="xs:int"/>
  96. <xs:element maxOccurs="1" minOccurs="1" name="ADM_NAME" type="xs:string"/>
  97. <xs:element maxOccurs="1" minOccurs="1" name="ADM_ACCOUNT" type="xs:string"/>
  98. <xs:element name="ADM_PASSWD" type="xs:string" minOccurs="0"/>
  99. <xs:element name="A_STATUS" type="default_db__x3A__ADMIN_USERS:ADMIN_USERS__A_STATUS"/>
  100. <xs:element name="EMPLOYEE_TYPE"
  101. type="default_db__x3A__ADMIN_USERS:ADMIN_USERS__EMPLOYE_TYPE"/>
  102. <xs:element name="ADM_OTHER_DOC" minOccurs="0" type="xs:string">
  103. <xs:annotation>
  104. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users
  105. </xs:documentation>
  106. </xs:annotation>
  107. </xs:element>
  108. <xs:element name="ADM_PESEL" minOccurs="0" type="xs:string">
  109. <xs:annotation>
  110. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users
  111. </xs:documentation>
  112. </xs:annotation>
  113. </xs:element>
  114. <xs:element name="ADM_PHONE" minOccurs="0" type="xs:string">
  115. <xs:annotation>
  116. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users</xs:documentation>
  117. </xs:annotation>
  118. </xs:element>
  119. <xs:element minOccurs="0" name="DEFAULT_ACL_GROUP" type="xs:string">
  120. <xs:annotation>
  121. <xs:documentation>todo make ref</xs:documentation>
  122. </xs:annotation>
  123. </xs:element>
  124. <xs:element minOccurs="0" name="A_CLASSIFIED" type="xs:string">
  125. <xs:annotation>
  126. <xs:documentation>todo make ref</xs:documentation>
  127. </xs:annotation>
  128. </xs:element>
  129. <xs:element minOccurs="0" name="A_ADM_COMPANY" type="xs:string">
  130. <xs:annotation>
  131. <xs:documentation>todo make ref</xs:documentation>
  132. </xs:annotation>
  133. </xs:element>
  134. <xs:element name="EMAIL_LOCAL_ACCOUNT_ADDRESS" type="xs:string"/>
  135. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
  136. id="ADMIN_USERS___d4e4166-1">
  137. <xs:annotation>
  138. <xs:appinfo>
  139. <system_cache__appinfo:flat_relation_cache>
  140. <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED"
  141. system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
  142. </system_cache__appinfo:flat_relation_cache>
  143. </xs:appinfo>
  144. </xs:annotation>
  145. </xs:element>-->
  146. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
  147. id="ADMIN_USERS___d4e4171-1">
  148. <xs:annotation>
  149. <xs:appinfo>
  150. <system_cache__appinfo:flat_relation_cache>
  151. <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY"
  152. system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
  153. </system_cache__appinfo:flat_relation_cache>
  154. </xs:appinfo>
  155. </xs:annotation>
  156. </xs:element>-->
  157. <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER">
  158. <xs:annotation>
  159. <xs:appinfo>
  160. <system_cache__appinfo:flat_relation_cache>
  161. <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"/>
  162. </system_cache__appinfo:flat_relation_cache>
  163. </xs:appinfo>
  164. <xs:documentation>
  165. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
  166. </xs:documentation>
  167. </xs:annotation>
  168. </xs:element>
  169. <xs:element maxOccurs="unbounded" minOccurs="0" ref="default_db__x3A__DEVICES:DEVICES">
  170. <xs:annotation>
  171. <xs:appinfo>
  172. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  173. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"/>
  174. </system_cache__appinfo:flat_relation_cache>
  175. </xs:appinfo>
  176. </xs:annotation>
  177. </xs:element>
  178. <xs:element ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING" maxOccurs="unbounded"
  179. minOccurs="0">
  180. <xs:annotation>
  181. <xs:appinfo>
  182. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  183. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"/>
  184. </system_cache__appinfo:flat_relation_cache>
  185. </xs:appinfo>
  186. </xs:annotation>
  187. </xs:element>
  188. <xs:element maxOccurs="unbounded" minOccurs="0" ref="default_db__x3A__PROBLEMS:PROBLEMS">
  189. <xs:annotation>
  190. <xs:appinfo>
  191. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  192. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"/>
  193. </system_cache__appinfo:flat_relation_cache>
  194. </xs:appinfo>
  195. </xs:annotation>
  196. </xs:element>
  197. <xs:element maxOccurs="unbounded" minOccurs="0"
  198. ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI">
  199. <xs:annotation>
  200. <xs:appinfo>
  201. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  202. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ADM_ACCOUNT" system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI/L_APPOITMENT_USER"/>
  203. </system_cache__appinfo:flat_relation_cache>
  204. </xs:appinfo>
  205. </xs:annotation>
  206. </xs:element>
  207. </xs:sequence>
  208. </xs:complexType>
  209. <xs:element name="ADMIN_USERS" type="default_db__x3A__ADMIN_USERS:ADMIN_USERS"/>
  210. <xs:element name="ADMIN_USERS_ID" type="default_db__x3A__ADMIN_USERS:ADMIN_USERS">
  211. <xs:annotation>
  212. <xs:documentation>Uzywane w TELBOXES jako osoba odpowiadajaca za sprzet</xs:documentation>
  213. </xs:annotation>
  214. </xs:element>
  215. <xs:complexType name="user" system_cache__appinfo:primaryKey="ID">
  216. <xs:annotation>
  217. <xs:documentation>@20160708 bindera: na bazie jsona Piotrowego, do testow GUI
  218. Kombinacja: bazowa</xs:documentation>
  219. </xs:annotation>
  220. <xs:complexContent>
  221. <xs:restriction base="default_db__x3A__ADMIN_USERS:ADMIN_USERS">
  222. <xs:sequence>
  223. <xs:element name="ID" type="xs:int"/>
  224. <xs:element maxOccurs="1" minOccurs="1" name="ADM_NAME" type="xs:string"/>
  225. <xs:element maxOccurs="1" minOccurs="1" name="ADM_ACCOUNT" type="xs:string"/>
  226. <xs:element name="ADM_PASSWD" type="xs:string"/>
  227. <xs:element name="A_STATUS" type="default_db__x3A__ADMIN_USERS:ADMIN_USERS__A_STATUS"/>
  228. <xs:element name="EMPLOYEE_TYPE"
  229. type="default_db__x3A__ADMIN_USERS:ADMIN_USERS__EMPLOYE_TYPE"/>
  230. <xs:element name="ADM_OTHER_DOC" minOccurs="0" type="xs:string">
  231. <xs:annotation>
  232. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users
  233. </xs:documentation>
  234. </xs:annotation>
  235. </xs:element>
  236. <xs:element name="ADM_PESEL" minOccurs="0" type="xs:string">
  237. <xs:annotation>
  238. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users
  239. </xs:documentation>
  240. </xs:annotation>
  241. </xs:element>
  242. <xs:element name="ADM_PHONE" minOccurs="0" type="xs:string">
  243. <xs:annotation>
  244. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users</xs:documentation>
  245. </xs:annotation>
  246. </xs:element>
  247. <xs:element minOccurs="0" name="DEFAULT_ACL_GROUP" type="xs:string">
  248. <xs:annotation>
  249. <xs:documentation>todo make ref</xs:documentation>
  250. </xs:annotation>
  251. </xs:element>
  252. <xs:element minOccurs="0" name="A_CLASSIFIED" type="xs:string">
  253. <xs:annotation>
  254. <xs:documentation>todo make ref</xs:documentation>
  255. </xs:annotation>
  256. </xs:element>
  257. <xs:element minOccurs="0" name="A_ADM_COMPANY" type="xs:string">
  258. <xs:annotation>
  259. <xs:documentation>todo make ref</xs:documentation>
  260. </xs:annotation>
  261. </xs:element>
  262. <xs:element name="EMAIL_LOCAL_ACCOUNT_ADDRESS" type="xs:string"/>
  263. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
  264. id="ADMIN_USERS___d4e4166-1">
  265. <xs:annotation>
  266. <xs:appinfo>
  267. <system_cache__appinfo:flat_relation_cache>
  268. <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED"
  269. system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
  270. </system_cache__appinfo:flat_relation_cache>
  271. </xs:appinfo>
  272. </xs:annotation>
  273. </xs:element>-->
  274. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
  275. id="ADMIN_USERS___d4e4171-1">
  276. <xs:annotation>
  277. <xs:appinfo>
  278. <system_cache__appinfo:flat_relation_cache>
  279. <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY"
  280. system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
  281. </system_cache__appinfo:flat_relation_cache>
  282. </xs:appinfo>
  283. </xs:annotation>
  284. </xs:element>-->
  285. <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER">
  286. <xs:annotation>
  287. <xs:appinfo>
  288. <system_cache__appinfo:flat_relation_cache>
  289. <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"/>
  290. </system_cache__appinfo:flat_relation_cache>
  291. </xs:appinfo>
  292. <xs:documentation>
  293. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
  294. </xs:documentation>
  295. </xs:annotation>
  296. </xs:element>
  297. <xs:element maxOccurs="unbounded" minOccurs="0"
  298. ref="default_db__x3A__DEVICES:DEVICES">
  299. <xs:annotation>
  300. <xs:appinfo>
  301. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  302. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"/>
  303. </system_cache__appinfo:flat_relation_cache>
  304. </xs:appinfo>
  305. </xs:annotation>
  306. </xs:element>
  307. <xs:element ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING"
  308. maxOccurs="unbounded" minOccurs="0">
  309. <xs:annotation>
  310. <xs:appinfo>
  311. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  312. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"/>
  313. </system_cache__appinfo:flat_relation_cache>
  314. </xs:appinfo>
  315. </xs:annotation>
  316. </xs:element>
  317. <xs:element maxOccurs="unbounded" minOccurs="0"
  318. ref="default_db__x3A__PROBLEMS:PROBLEMS">
  319. <xs:annotation>
  320. <xs:appinfo>
  321. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  322. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"/>
  323. </system_cache__appinfo:flat_relation_cache>
  324. </xs:appinfo>
  325. </xs:annotation>
  326. </xs:element>
  327. <xs:element maxOccurs="unbounded" minOccurs="0"
  328. ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI">
  329. <xs:annotation>
  330. <xs:appinfo>
  331. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  332. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ADM_ACCOUNT" system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI/L_APPOITMENT_USER"/>
  333. </system_cache__appinfo:flat_relation_cache>
  334. </xs:appinfo>
  335. </xs:annotation>
  336. </xs:element>
  337. </xs:sequence>
  338. </xs:restriction>
  339. </xs:complexContent>
  340. </xs:complexType>
  341. <xs:complexType name="user_status__NORMAL" system_cache__appinfo:primaryKey="ID">
  342. <xs:annotation>
  343. <xs:documentation>do generowania : typ obiektu na NORMAL do tworzenia kombinacji</xs:documentation>
  344. </xs:annotation>
  345. <xs:complexContent>
  346. <xs:restriction base="default_db__x3A__ADMIN_USERS:user">
  347. <xs:sequence>
  348. <xs:element name="ID" type="xs:int"/>
  349. <xs:element maxOccurs="1" minOccurs="1" name="ADM_NAME" type="xs:string"/>
  350. <xs:element maxOccurs="1" minOccurs="1" name="ADM_ACCOUNT" type="xs:string"/>
  351. <xs:element name="ADM_PASSWD" type="xs:string"/>
  352. <xs:element name="A_STATUS"
  353. type="default_db__x3A__ADMIN_USERS:ADMIN_USERS__A_STATUS_NORMAL"/>
  354. <xs:element name="EMPLOYEE_TYPE"
  355. type="default_db__x3A__ADMIN_USERS:ADMIN_USERS__EMPLOYE_TYPE"/>
  356. <xs:element name="ADM_OTHER_DOC" minOccurs="0" type="xs:string">
  357. <xs:annotation>
  358. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users
  359. </xs:documentation>
  360. </xs:annotation>
  361. </xs:element>
  362. <xs:element name="ADM_PESEL" minOccurs="0" type="xs:string">
  363. <xs:annotation>
  364. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users
  365. </xs:documentation>
  366. </xs:annotation>
  367. </xs:element>
  368. <xs:element name="ADM_PHONE" minOccurs="0" type="xs:string">
  369. <xs:annotation>
  370. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users</xs:documentation>
  371. </xs:annotation>
  372. </xs:element>
  373. <xs:element minOccurs="0" name="DEFAULT_ACL_GROUP" type="xs:string">
  374. <xs:annotation>
  375. <xs:documentation>todo make ref</xs:documentation>
  376. </xs:annotation>
  377. </xs:element>
  378. <xs:element minOccurs="0" name="A_CLASSIFIED" type="xs:string">
  379. <xs:annotation>
  380. <xs:documentation>todo make ref</xs:documentation>
  381. </xs:annotation>
  382. </xs:element>
  383. <xs:element minOccurs="0" name="A_ADM_COMPANY" type="xs:string">
  384. <xs:annotation>
  385. <xs:documentation>todo make ref</xs:documentation>
  386. </xs:annotation>
  387. </xs:element>
  388. <xs:element name="EMAIL_LOCAL_ACCOUNT_ADDRESS" type="xs:string"/>
  389. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
  390. id="ADMIN_USERS___d4e4219-1">
  391. <xs:annotation>
  392. <xs:appinfo>
  393. <system_cache__appinfo:flat_relation_cache>
  394. <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED"
  395. system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
  396. </system_cache__appinfo:flat_relation_cache>
  397. </xs:appinfo>
  398. </xs:annotation>
  399. </xs:element>-->
  400. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
  401. id="ADMIN_USERS___d4e4224-1">
  402. <xs:annotation>
  403. <xs:appinfo>
  404. <system_cache__appinfo:flat_relation_cache>
  405. <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY"
  406. system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
  407. </system_cache__appinfo:flat_relation_cache>
  408. </xs:appinfo>
  409. </xs:annotation>
  410. </xs:element>-->
  411. <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER">
  412. <xs:annotation>
  413. <xs:appinfo>
  414. <system_cache__appinfo:flat_relation_cache>
  415. <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"/>
  416. </system_cache__appinfo:flat_relation_cache>
  417. </xs:appinfo>
  418. <xs:documentation>
  419. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
  420. </xs:documentation>
  421. </xs:annotation>
  422. </xs:element>
  423. <xs:element maxOccurs="unbounded" minOccurs="0"
  424. ref="default_db__x3A__DEVICES:DEVICES">
  425. <xs:annotation>
  426. <xs:appinfo>
  427. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  428. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"/>
  429. </system_cache__appinfo:flat_relation_cache>
  430. </xs:appinfo>
  431. </xs:annotation>
  432. </xs:element>
  433. <xs:element ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING"
  434. maxOccurs="unbounded" minOccurs="0">
  435. <xs:annotation>
  436. <xs:appinfo>
  437. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  438. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"/>
  439. </system_cache__appinfo:flat_relation_cache>
  440. </xs:appinfo>
  441. </xs:annotation>
  442. </xs:element>
  443. <xs:element maxOccurs="unbounded" minOccurs="0"
  444. ref="default_db__x3A__PROBLEMS:PROBLEMS">
  445. <xs:annotation>
  446. <xs:appinfo>
  447. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  448. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"/>
  449. </system_cache__appinfo:flat_relation_cache>
  450. </xs:appinfo>
  451. </xs:annotation>
  452. </xs:element>
  453. </xs:sequence>
  454. </xs:restriction>
  455. </xs:complexContent>
  456. </xs:complexType>
  457. <xs:element name="user_status__NORMAL" type="default_db__x3A__ADMIN_USERS:user_status__NORMAL"/>
  458. <xs:complexType name="user_status__OFF_HARD" system_cache__appinfo:primaryKey="ID">
  459. <xs:complexContent>
  460. <xs:restriction base="default_db__x3A__ADMIN_USERS:user">
  461. <xs:sequence>
  462. <xs:element name="ID" type="xs:int"/>
  463. <xs:element maxOccurs="1" minOccurs="1" name="ADM_NAME" type="xs:string"/>
  464. <xs:element maxOccurs="1" minOccurs="1" name="ADM_ACCOUNT" type="xs:string"/>
  465. <xs:element name="ADM_PASSWD" type="xs:string"/>
  466. <xs:element name="A_STATUS"
  467. type="default_db__x3A__ADMIN_USERS:ADMIN_USERS__A_STATUS_OFF_HARD"/>
  468. <xs:element name="EMPLOYEE_TYPE"
  469. type="default_db__x3A__ADMIN_USERS:ADMIN_USERS__EMPLOYE_TYPE"/>
  470. <xs:element name="ADM_OTHER_DOC" minOccurs="0" type="xs:string">
  471. <xs:annotation>
  472. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users
  473. </xs:documentation>
  474. </xs:annotation>
  475. </xs:element>
  476. <xs:element name="ADM_PESEL" minOccurs="0" type="xs:string">
  477. <xs:annotation>
  478. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users
  479. </xs:documentation>
  480. </xs:annotation>
  481. </xs:element>
  482. <xs:element name="ADM_PHONE" minOccurs="0" type="xs:string">
  483. <xs:annotation>
  484. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users</xs:documentation>
  485. </xs:annotation>
  486. </xs:element>
  487. <xs:element minOccurs="0" name="DEFAULT_ACL_GROUP" type="xs:string">
  488. <xs:annotation>
  489. <xs:documentation>todo make ref</xs:documentation>
  490. </xs:annotation>
  491. </xs:element>
  492. <xs:element minOccurs="0" name="A_CLASSIFIED" type="xs:string">
  493. <xs:annotation>
  494. <xs:documentation>todo make ref</xs:documentation>
  495. </xs:annotation>
  496. </xs:element>
  497. <xs:element minOccurs="0" name="A_ADM_COMPANY" type="xs:string">
  498. <xs:annotation>
  499. <xs:documentation>todo make ref</xs:documentation>
  500. </xs:annotation>
  501. </xs:element>
  502. <xs:element name="EMAIL_LOCAL_ACCOUNT_ADDRESS" type="xs:string"/>
  503. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
  504. id="ADMIN_USERS___d4e4271-1">
  505. <xs:annotation>
  506. <xs:appinfo>
  507. <system_cache__appinfo:flat_relation_cache>
  508. <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED"
  509. system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
  510. </system_cache__appinfo:flat_relation_cache>
  511. </xs:appinfo>
  512. </xs:annotation>
  513. </xs:element>-->
  514. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
  515. id="ADMIN_USERS___d4e4276-1">
  516. <xs:annotation>
  517. <xs:appinfo>
  518. <system_cache__appinfo:flat_relation_cache>
  519. <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY"
  520. system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
  521. </system_cache__appinfo:flat_relation_cache>
  522. </xs:appinfo>
  523. </xs:annotation>
  524. </xs:element>-->
  525. <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER">
  526. <xs:annotation>
  527. <xs:appinfo>
  528. <system_cache__appinfo:flat_relation_cache>
  529. <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"/>
  530. </system_cache__appinfo:flat_relation_cache>
  531. </xs:appinfo>
  532. <xs:documentation>
  533. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
  534. </xs:documentation>
  535. </xs:annotation>
  536. </xs:element>
  537. <xs:element maxOccurs="unbounded" minOccurs="0"
  538. ref="default_db__x3A__DEVICES:DEVICES">
  539. <xs:annotation>
  540. <xs:appinfo>
  541. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  542. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"/>
  543. </system_cache__appinfo:flat_relation_cache>
  544. </xs:appinfo>
  545. <xs:documentation>
  546. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #555544
  547. </xs:documentation>
  548. </xs:annotation>
  549. </xs:element>
  550. <xs:element ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING"
  551. maxOccurs="unbounded" minOccurs="0">
  552. <xs:annotation>
  553. <xs:appinfo>
  554. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  555. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"/>
  556. </system_cache__appinfo:flat_relation_cache>
  557. </xs:appinfo>
  558. </xs:annotation>
  559. </xs:element>
  560. <xs:element maxOccurs="unbounded" minOccurs="0"
  561. ref="default_db__x3A__PROBLEMS:PROBLEMS">
  562. <xs:annotation>
  563. <xs:appinfo>
  564. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  565. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"/>
  566. </system_cache__appinfo:flat_relation_cache>
  567. </xs:appinfo>
  568. </xs:annotation>
  569. </xs:element>
  570. <xs:element maxOccurs="unbounded" minOccurs="0"
  571. ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI">
  572. <xs:annotation>
  573. <xs:appinfo>
  574. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  575. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ADM_ACCOUNT" system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI/L_APPOITMENT_USER"/>
  576. </system_cache__appinfo:flat_relation_cache>
  577. </xs:appinfo>
  578. </xs:annotation>
  579. </xs:element>
  580. </xs:sequence>
  581. </xs:restriction>
  582. </xs:complexContent>
  583. </xs:complexType>
  584. <xs:element name="user_status__OFF_HARD"
  585. type="default_db__x3A__ADMIN_USERS:user_status__OFF_HARD"/>
  586. <xs:element name="user" type="default_db__x3A__ADMIN_USERS:user"/>
  587. <xs:element name="AccessOwner" type="default_db__x3A__ADMIN_USERS:user">
  588. <xs:annotation>
  589. <xs:documentation>Odpowiednik L_APPOITMENT_USER</xs:documentation>
  590. </xs:annotation>
  591. </xs:element>
  592. <xs:complexType name="person_contatct" system_cache__appinfo:primaryKey="ID">
  593. <xs:annotation>
  594. <xs:documentation>TODO podstawowy obiekt do wprowadzania jako kontakt do osoby fizycznej z mozliwoscia ewnetualnego logowania i widzenia spraw powiazanych
  595. Kombinacja: EMPLOYE TYPE Kontakt</xs:documentation>
  596. </xs:annotation>
  597. <xs:complexContent>
  598. <xs:restriction base="default_db__x3A__ADMIN_USERS:user">
  599. <xs:sequence>
  600. <xs:element name="ID" type="xs:int"/>
  601. <xs:element maxOccurs="1" minOccurs="1" name="ADM_NAME" type="xs:string"/>
  602. <xs:element maxOccurs="1" minOccurs="1" name="ADM_ACCOUNT" type="xs:string"/>
  603. <xs:element name="ADM_PASSWD" type="xs:string"/>
  604. <xs:element name="A_STATUS" type="default_db__x3A__ADMIN_USERS:ADMIN_USERS__A_STATUS"/>
  605. <xs:element name="EMPLOYEE_TYPE"
  606. type="default_db__x3A__ADMIN_USERS:ADMIN_USERS__EMPLOYE_TYPE"/>
  607. <xs:element name="ADM_OTHER_DOC" minOccurs="0" type="xs:string">
  608. <xs:annotation>
  609. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users
  610. </xs:documentation>
  611. </xs:annotation>
  612. </xs:element>
  613. <xs:element name="ADM_PESEL" minOccurs="0" type="xs:string">
  614. <xs:annotation>
  615. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users
  616. </xs:documentation>
  617. </xs:annotation>
  618. </xs:element>
  619. <xs:element name="ADM_PHONE" minOccurs="0" type="xs:string">
  620. <xs:annotation>
  621. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users</xs:documentation>
  622. </xs:annotation>
  623. </xs:element>
  624. <xs:element minOccurs="0" name="DEFAULT_ACL_GROUP" type="xs:string">
  625. <xs:annotation>
  626. <xs:documentation>todo make ref</xs:documentation>
  627. </xs:annotation>
  628. </xs:element>
  629. <xs:element minOccurs="0" name="A_CLASSIFIED" type="xs:string">
  630. <xs:annotation>
  631. <xs:documentation>todo make ref</xs:documentation>
  632. </xs:annotation>
  633. </xs:element>
  634. <xs:element minOccurs="0" name="A_ADM_COMPANY" type="xs:string">
  635. <xs:annotation>
  636. <xs:documentation>todo make ref</xs:documentation>
  637. </xs:annotation>
  638. </xs:element>
  639. <xs:element name="EMAIL_LOCAL_ACCOUNT_ADDRESS" type="xs:string"/>
  640. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
  641. id="ADMIN_USERS___d4e4330-1">
  642. <xs:annotation>
  643. <xs:appinfo>
  644. <system_cache__appinfo:flat_relation_cache>
  645. <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED"
  646. system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
  647. </system_cache__appinfo:flat_relation_cache>
  648. </xs:appinfo>
  649. </xs:annotation>
  650. </xs:element>-->
  651. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
  652. id="ADMIN_USERS___d4e4335-1">
  653. <xs:annotation>
  654. <xs:appinfo>
  655. <system_cache__appinfo:flat_relation_cache>
  656. <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY"
  657. system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
  658. </system_cache__appinfo:flat_relation_cache>
  659. </xs:appinfo>
  660. </xs:annotation>
  661. </xs:element>-->
  662. <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER">
  663. <xs:annotation>
  664. <xs:appinfo>
  665. <system_cache__appinfo:flat_relation_cache>
  666. <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"/>
  667. </system_cache__appinfo:flat_relation_cache>
  668. </xs:appinfo>
  669. <xs:documentation>
  670. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
  671. </xs:documentation>
  672. </xs:annotation>
  673. </xs:element>
  674. <xs:element maxOccurs="unbounded" minOccurs="0"
  675. ref="default_db__x3A__DEVICES:DEVICES">
  676. <xs:annotation>
  677. <xs:appinfo>
  678. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  679. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"/>
  680. </system_cache__appinfo:flat_relation_cache>
  681. </xs:appinfo>
  682. </xs:annotation>
  683. </xs:element>
  684. <xs:element ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING"
  685. maxOccurs="unbounded" minOccurs="0">
  686. <xs:annotation>
  687. <xs:appinfo>
  688. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  689. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"/>
  690. </system_cache__appinfo:flat_relation_cache>
  691. </xs:appinfo>
  692. </xs:annotation>
  693. </xs:element>
  694. <xs:element maxOccurs="unbounded" minOccurs="0"
  695. ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI">
  696. <xs:annotation>
  697. <xs:appinfo>
  698. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  699. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ADM_ACCOUNT" system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI/L_APPOITMENT_USER"/>
  700. </system_cache__appinfo:flat_relation_cache>
  701. </xs:appinfo>
  702. </xs:annotation>
  703. </xs:element>
  704. </xs:sequence>
  705. </xs:restriction>
  706. </xs:complexContent>
  707. </xs:complexType>
  708. <xs:element name="person_contatct" type="default_db__x3A__ADMIN_USERS:person_contatct"/>
  709. <xs:complexType name="person_contact_with_details" system_cache__appinfo:primaryKey="ID">
  710. <xs:annotation>
  711. <xs:documentation>Kontakt do dodawania do umow, rozszerzony o pesel i dane dokładne adresowe zamieszkania
  712. Kombinacja: EMPLOYE TYPE Kontakt</xs:documentation>
  713. </xs:annotation>
  714. <xs:complexContent>
  715. <xs:restriction base="default_db__x3A__ADMIN_USERS:user">
  716. <xs:sequence>
  717. <xs:element name="ID" type="xs:int"/>
  718. <xs:element maxOccurs="1" minOccurs="1" name="ADM_NAME" type="xs:string"/>
  719. <xs:element maxOccurs="1" minOccurs="1" name="ADM_ACCOUNT" type="xs:string"/>
  720. <xs:element name="ADM_PASSWD" type="xs:string"/>
  721. <xs:element name="A_STATUS" type="default_db__x3A__ADMIN_USERS:ADMIN_USERS__A_STATUS"/>
  722. <xs:element name="EMPLOYEE_TYPE"
  723. type="default_db__x3A__ADMIN_USERS:ADMIN_USERS__EMPLOYE_TYPE"/>
  724. <xs:element name="ADM_OTHER_DOC" minOccurs="0" type="xs:string">
  725. <xs:annotation>
  726. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users
  727. </xs:documentation>
  728. </xs:annotation>
  729. </xs:element>
  730. <xs:element name="ADM_PESEL" minOccurs="0" type="xs:string">
  731. <xs:annotation>
  732. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users
  733. </xs:documentation>
  734. </xs:annotation>
  735. </xs:element>
  736. <xs:element name="ADM_PHONE" minOccurs="1" type="xs:string">
  737. <xs:annotation>
  738. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users</xs:documentation>
  739. </xs:annotation>
  740. </xs:element>
  741. <xs:element minOccurs="0" name="DEFAULT_ACL_GROUP" type="xs:string">
  742. <xs:annotation>
  743. <xs:documentation>todo make ref</xs:documentation>
  744. </xs:annotation>
  745. </xs:element>
  746. <xs:element minOccurs="0" name="A_CLASSIFIED" type="xs:string">
  747. <xs:annotation>
  748. <xs:documentation>todo make ref</xs:documentation>
  749. </xs:annotation>
  750. </xs:element>
  751. <xs:element minOccurs="0" name="A_ADM_COMPANY" type="xs:string">
  752. <xs:annotation>
  753. <xs:documentation>todo make ref</xs:documentation>
  754. </xs:annotation>
  755. </xs:element>
  756. <xs:element name="EMAIL_LOCAL_ACCOUNT_ADDRESS" type="xs:string"/>
  757. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
  758. id="ADMIN_USERS___d4e4384-1">
  759. <xs:annotation>
  760. <xs:appinfo>
  761. <system_cache__appinfo:flat_relation_cache>
  762. <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED"
  763. system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
  764. </system_cache__appinfo:flat_relation_cache>
  765. </xs:appinfo>
  766. </xs:annotation>
  767. </xs:element>-->
  768. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
  769. id="ADMIN_USERS___d4e4389-1">
  770. <xs:annotation>
  771. <xs:appinfo>
  772. <system_cache__appinfo:flat_relation_cache>
  773. <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY"
  774. system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
  775. </system_cache__appinfo:flat_relation_cache>
  776. </xs:appinfo>
  777. </xs:annotation>
  778. </xs:element>-->
  779. <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER">
  780. <xs:annotation>
  781. <xs:appinfo>
  782. <system_cache__appinfo:flat_relation_cache>
  783. <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"/>
  784. </system_cache__appinfo:flat_relation_cache>
  785. </xs:appinfo>
  786. <xs:documentation>
  787. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
  788. </xs:documentation>
  789. </xs:annotation>
  790. </xs:element>
  791. <xs:element maxOccurs="unbounded" minOccurs="0"
  792. ref="default_db__x3A__DEVICES:DEVICES">
  793. <xs:annotation>
  794. <xs:appinfo>
  795. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  796. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"/>
  797. </system_cache__appinfo:flat_relation_cache>
  798. </xs:appinfo>
  799. </xs:annotation>
  800. </xs:element>
  801. <xs:element ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING"
  802. maxOccurs="unbounded" minOccurs="0">
  803. <xs:annotation>
  804. <xs:appinfo>
  805. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  806. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"/>
  807. </system_cache__appinfo:flat_relation_cache>
  808. </xs:appinfo>
  809. </xs:annotation>
  810. </xs:element>
  811. <xs:element maxOccurs="unbounded" minOccurs="0"
  812. ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI">
  813. <xs:annotation>
  814. <xs:appinfo>
  815. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  816. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ADM_ACCOUNT" system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI/L_APPOITMENT_USER"/>
  817. </system_cache__appinfo:flat_relation_cache>
  818. </xs:appinfo>
  819. </xs:annotation>
  820. </xs:element>
  821. </xs:sequence>
  822. </xs:restriction>
  823. </xs:complexContent>
  824. </xs:complexType>
  825. <xs:element name="person_contact_with_details"
  826. type="default_db__x3A__ADMIN_USERS:person_contact_with_details"/>
  827. <xs:complexType name="worker" system_cache__appinfo:primaryKey="ID">
  828. <xs:annotation>
  829. <xs:documentation>kombinacja - jest to EMPLOYEE TYPE = Pracownik</xs:documentation>
  830. </xs:annotation>
  831. <xs:complexContent>
  832. <xs:restriction base="default_db__x3A__ADMIN_USERS:user">
  833. <xs:sequence>
  834. <xs:element name="ID" type="xs:int"/>
  835. <xs:element maxOccurs="1" minOccurs="1" name="ADM_NAME" type="xs:string"/>
  836. <xs:element maxOccurs="1" minOccurs="1" name="ADM_ACCOUNT" type="xs:string"/>
  837. <xs:element name="ADM_PASSWD" type="xs:string"/>
  838. <xs:element name="A_STATUS"
  839. type="default_db__x3A__ADMIN_USERS:ADMIN_USERS__A_STATUS_NORMAL"/>
  840. <xs:element name="EMPLOYEE_TYPE"
  841. type="default_db__x3A__ADMIN_USERS:ADMIN_USERS__EMPLOYE_TYPE__worker"/>
  842. <xs:element name="ADM_OTHER_DOC" minOccurs="0" type="xs:string">
  843. <xs:annotation>
  844. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users
  845. </xs:documentation>
  846. </xs:annotation>
  847. </xs:element>
  848. <xs:element name="ADM_PESEL" minOccurs="0" type="xs:string">
  849. <xs:annotation>
  850. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users
  851. </xs:documentation>
  852. </xs:annotation>
  853. </xs:element>
  854. <xs:element name="ADM_PHONE" minOccurs="0" type="xs:string">
  855. <xs:annotation>
  856. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users</xs:documentation>
  857. </xs:annotation>
  858. </xs:element>
  859. <xs:element minOccurs="0" name="DEFAULT_ACL_GROUP" type="xs:string">
  860. <xs:annotation>
  861. <xs:documentation>todo make ref</xs:documentation>
  862. </xs:annotation>
  863. </xs:element>
  864. <xs:element minOccurs="0" name="A_CLASSIFIED" type="xs:string">
  865. <xs:annotation>
  866. <xs:documentation>todo make ref</xs:documentation>
  867. </xs:annotation>
  868. </xs:element>
  869. <xs:element minOccurs="0" name="A_ADM_COMPANY" type="xs:string">
  870. <xs:annotation>
  871. <xs:documentation>todo make ref</xs:documentation>
  872. </xs:annotation>
  873. </xs:element>
  874. <xs:element name="EMAIL_LOCAL_ACCOUNT_ADDRESS" type="xs:string"/>
  875. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
  876. id="ADMIN_USERS___d4e4438-1">
  877. <xs:annotation>
  878. <xs:appinfo>
  879. <system_cache__appinfo:flat_relation_cache>
  880. <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED"
  881. system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
  882. </system_cache__appinfo:flat_relation_cache>
  883. </xs:appinfo>
  884. </xs:annotation>
  885. </xs:element>-->
  886. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
  887. id="ADMIN_USERS___d4e4443-1">
  888. <xs:annotation>
  889. <xs:appinfo>
  890. <system_cache__appinfo:flat_relation_cache>
  891. <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY"
  892. system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
  893. </system_cache__appinfo:flat_relation_cache>
  894. </xs:appinfo>
  895. </xs:annotation>
  896. </xs:element>-->
  897. <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER">
  898. <xs:annotation>
  899. <xs:appinfo>
  900. <system_cache__appinfo:flat_relation_cache>
  901. <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"/>
  902. </system_cache__appinfo:flat_relation_cache>
  903. </xs:appinfo>
  904. <xs:documentation>
  905. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
  906. </xs:documentation>
  907. </xs:annotation>
  908. </xs:element>
  909. <xs:element maxOccurs="unbounded" minOccurs="0"
  910. ref="default_db__x3A__DEVICES:DEVICES">
  911. <xs:annotation>
  912. <xs:appinfo>
  913. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  914. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"/>
  915. </system_cache__appinfo:flat_relation_cache>
  916. </xs:appinfo>
  917. </xs:annotation>
  918. </xs:element>
  919. <xs:element ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING"
  920. maxOccurs="unbounded" minOccurs="0">
  921. <xs:annotation>
  922. <xs:appinfo>
  923. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  924. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"/>
  925. </system_cache__appinfo:flat_relation_cache>
  926. </xs:appinfo>
  927. </xs:annotation>
  928. </xs:element>
  929. <xs:element maxOccurs="unbounded" minOccurs="0"
  930. ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI">
  931. <xs:annotation>
  932. <xs:appinfo>
  933. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
  934. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ADM_ACCOUNT" system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI/L_APPOITMENT_USER"/>
  935. </system_cache__appinfo:flat_relation_cache>
  936. </xs:appinfo>
  937. </xs:annotation>
  938. </xs:element>
  939. </xs:sequence>
  940. </xs:restriction>
  941. </xs:complexContent>
  942. </xs:complexType>
  943. <xs:element name="worker" type="default_db__x3A__ADMIN_USERS:worker"
  944. substitutionGroup="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"/>
  945. <xs:element name="L_APPOITMENT_USER" type="default_db__x3A__ADMIN_USERS:worker"/>
  946. <xs:element name="CUSTOMER_ADMIN_USER" type="default_db__x3A__ADMIN_USERS:worker">
  947. <xs:annotation>
  948. <xs:documentation>GLownie w zadaniach jest taka relacja</xs:documentation>
  949. </xs:annotation>
  950. </xs:element>
  951. <xs:complexType name="ADMIN_USERS_ID_AUTHORIZES">
  952. <xs:annotation>
  953. <xs:documentation>Osoba która kogoś upoważnia</xs:documentation>
  954. </xs:annotation>
  955. <xs:complexContent>
  956. <xs:restriction base="default_db__x3A__ADMIN_USERS:ADMIN_USERS">
  957. <xs:sequence>
  958. <xs:element name="ID" type="xs:int"/>
  959. <xs:element maxOccurs="1" minOccurs="1" name="ADM_NAME" type="xs:string"/>
  960. <xs:element maxOccurs="1" minOccurs="1" name="ADM_ACCOUNT" type="xs:string"/>
  961. <xs:element name="A_STATUS" type="default_db__x3A__ADMIN_USERS:ADMIN_USERS__A_STATUS"/>
  962. <xs:element name="EMPLOYEE_TYPE"
  963. type="default_db__x3A__ADMIN_USERS:ADMIN_USERS__EMPLOYE_TYPE"/>
  964. <xs:element name="ADM_OTHER_DOC" minOccurs="1" type="xs:string">
  965. <xs:annotation>
  966. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users
  967. </xs:documentation>
  968. </xs:annotation>
  969. </xs:element>
  970. <xs:element name="ADM_PESEL" minOccurs="0" type="xs:string">
  971. <xs:annotation>
  972. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users
  973. </xs:documentation>
  974. </xs:annotation>
  975. </xs:element>
  976. <xs:element name="ADM_PHONE" minOccurs="0" type="xs:string">
  977. <xs:annotation>
  978. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users</xs:documentation>
  979. </xs:annotation>
  980. </xs:element>
  981. <xs:element minOccurs="0" name="DEFAULT_ACL_GROUP" type="xs:string">
  982. <xs:annotation>
  983. <xs:documentation>todo make ref</xs:documentation>
  984. </xs:annotation>
  985. </xs:element>
  986. <xs:element minOccurs="0" name="A_CLASSIFIED" type="xs:string">
  987. <xs:annotation>
  988. <xs:documentation>todo make ref</xs:documentation>
  989. </xs:annotation>
  990. </xs:element>
  991. <xs:element minOccurs="0" name="A_ADM_COMPANY" type="xs:string">
  992. <xs:annotation>
  993. <xs:documentation>todo make ref</xs:documentation>
  994. </xs:annotation>
  995. </xs:element>
  996. <xs:element name="EMAIL_LOCAL_ACCOUNT_ADDRESS" type="xs:string"/>
  997. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
  998. id="ADMIN_USERS___d4e4166-1">
  999. <xs:annotation>
  1000. <xs:appinfo>
  1001. <system_cache__appinfo:flat_relation_cache>
  1002. <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED"
  1003. system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
  1004. </system_cache__appinfo:flat_relation_cache>
  1005. </xs:appinfo>
  1006. </xs:annotation>
  1007. </xs:element>-->
  1008. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
  1009. id="ADMIN_USERS___d4e4171-1">
  1010. <xs:annotation>
  1011. <xs:appinfo>
  1012. <system_cache__appinfo:flat_relation_cache>
  1013. <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY"
  1014. system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
  1015. </system_cache__appinfo:flat_relation_cache>
  1016. </xs:appinfo>
  1017. </xs:annotation>
  1018. </xs:element>-->
  1019. <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER">
  1020. <xs:annotation>
  1021. <xs:appinfo>
  1022. <system_cache__appinfo:flat_relation_cache>
  1023. <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"/>
  1024. </system_cache__appinfo:flat_relation_cache>
  1025. </xs:appinfo>
  1026. <xs:documentation>
  1027. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
  1028. </xs:documentation>
  1029. </xs:annotation>
  1030. </xs:element>
  1031. </xs:sequence>
  1032. </xs:restriction>
  1033. </xs:complexContent>
  1034. </xs:complexType>
  1035. <xs:element name="ADMIN_USERS_ID_AUTHORIZES"
  1036. type="default_db__x3A__ADMIN_USERS:ADMIN_USERS_ID_AUTHORIZES"/>
  1037. <xs:complexType name="ADMIN_USERS_ID_AUTHORIZED">
  1038. <xs:annotation>
  1039. <xs:documentation>Osoba która jest upoważniana do czegoś przez kogoś</xs:documentation>
  1040. </xs:annotation>
  1041. <xs:complexContent>
  1042. <xs:restriction base="default_db__x3A__ADMIN_USERS:ADMIN_USERS">
  1043. <xs:sequence>
  1044. <xs:element name="ID" type="xs:int"/>
  1045. <xs:element maxOccurs="1" minOccurs="1" name="ADM_NAME" type="xs:string"/>
  1046. <xs:element maxOccurs="1" minOccurs="1" name="ADM_ACCOUNT" type="xs:string"/>
  1047. <xs:element name="A_STATUS" type="default_db__x3A__ADMIN_USERS:ADMIN_USERS__A_STATUS"/>
  1048. <xs:element name="EMPLOYEE_TYPE"
  1049. type="default_db__x3A__ADMIN_USERS:ADMIN_USERS__EMPLOYE_TYPE"/>
  1050. <xs:element name="ADM_OTHER_DOC" minOccurs="0" type="xs:string">
  1051. <xs:annotation>
  1052. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users
  1053. </xs:documentation>
  1054. </xs:annotation>
  1055. </xs:element>
  1056. <xs:element name="ADM_PESEL" minOccurs="0" type="xs:string">
  1057. <xs:annotation>
  1058. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users
  1059. </xs:documentation>
  1060. </xs:annotation>
  1061. </xs:element>
  1062. <xs:element name="ADM_PHONE" minOccurs="0" type="xs:string">
  1063. <xs:annotation>
  1064. <xs:documentation>todo: nalezy zdefiniowac komorke w admin users</xs:documentation>
  1065. </xs:annotation>
  1066. </xs:element>
  1067. <xs:element minOccurs="0" name="DEFAULT_ACL_GROUP" type="xs:string">
  1068. <xs:annotation>
  1069. <xs:documentation>todo make ref</xs:documentation>
  1070. </xs:annotation>
  1071. </xs:element>
  1072. <xs:element minOccurs="0" name="A_CLASSIFIED" type="xs:string">
  1073. <xs:annotation>
  1074. <xs:documentation>todo make ref</xs:documentation>
  1075. </xs:annotation>
  1076. </xs:element>
  1077. <xs:element minOccurs="0" name="A_ADM_COMPANY" type="xs:string">
  1078. <xs:annotation>
  1079. <xs:documentation>todo make ref</xs:documentation>
  1080. </xs:annotation>
  1081. </xs:element>
  1082. <xs:element name="EMAIL_LOCAL_ACCOUNT_ADDRESS" type="xs:string"/>
  1083. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
  1084. id="ADMIN_USERS___d4e4166-1">
  1085. <xs:annotation>
  1086. <xs:appinfo>
  1087. <system_cache__appinfo:flat_relation_cache>
  1088. <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED"
  1089. system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
  1090. </system_cache__appinfo:flat_relation_cache>
  1091. </xs:appinfo>
  1092. </xs:annotation>
  1093. </xs:element>-->
  1094. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
  1095. id="ADMIN_USERS___d4e4171-1">
  1096. <xs:annotation>
  1097. <xs:appinfo>
  1098. <system_cache__appinfo:flat_relation_cache>
  1099. <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY"
  1100. system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
  1101. </system_cache__appinfo:flat_relation_cache>
  1102. </xs:appinfo>
  1103. </xs:annotation>
  1104. </xs:element>-->
  1105. <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER">
  1106. <xs:annotation>
  1107. <xs:appinfo>
  1108. <system_cache__appinfo:flat_relation_cache>
  1109. <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"/>
  1110. </system_cache__appinfo:flat_relation_cache>
  1111. </xs:appinfo>
  1112. <xs:documentation>
  1113. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
  1114. </xs:documentation>
  1115. </xs:annotation>
  1116. </xs:element>
  1117. </xs:sequence>
  1118. </xs:restriction>
  1119. </xs:complexContent>
  1120. </xs:complexType>
  1121. <xs:element name="ADMIN_USERS_ID_AUTHORIZED"
  1122. type="default_db__x3A__ADMIN_USERS:ADMIN_USERS_ID_AUTHORIZED"/>
  1123. </xs:schema>