AccessOwner.xsd 57 KB

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