sys_users.xsd 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <schema xmlns="http://www.w3.org/2001/XMLSchema"
  3. xmlns:default_db__x3A__sys_users="https://biuro.biall-net.pl/wfs/default_db/table/sys_users.xsd"
  4. xmlns:default_db__x3A__crm_educationlevels="https://biuro.biall-net.pl/wfs/default_db/table/crm_educationlevels.xsd"
  5. xmlns:default_db__x3A__crm_genders="https://biuro.biall-net.pl/wfs/default_db/table/crm_genders.xsd"
  6. xmlns:default_db__x3A__crm_languagelevels="https://biuro.biall-net.pl/wfs/default_db/table/crm_languagelevels.xsd"
  7. xmlns:default_db__x3A__crm_carrerstatuses="https://biuro.biall-net.pl/wfs/default_db/table/crm_carrerstatuses.xsd"
  8. xmlns:default_db__x3A__crm_addresstypes="https://biuro.biall-net.pl/wfs/default_db/table/crm_addresstypes.xsd"
  9. xmlns:default_db__x3A__crm_voivodeships="https://biuro.biall-net.pl/wfs/default_db/table/crm_voivodeships.xsd"
  10. xmlns:default_db__x3A__crm_addresses="https://biuro.biall-net.pl/wfs/default_db/table/crm_addresses.xsd"
  11. xmlns:default_db__x3A__crm_families="https://biuro.biall-net.pl/wfs/default_db/table/crm_families.xsd"
  12. xmlns:default_db__x3A__crm_transportcompanies="https://biuro.biall-net.pl/wfs/default_db/table/crm_transportcompanies.xsd"
  13. xmlns:default_db__x3A__car_carrers="https://biuro.biall-net.pl/wfs/default_db/table/car_carrers.xsd"
  14. xmlns:default_db__x3A__crm_currencys="https://biuro.biall-net.pl/wfs/default_db/table/crm_currencys.xsd"
  15. xmlns:default_db__x3A__crm_notes="https://biuro.biall-net.pl/wfs/default_db/table/crm_notes.xsd"
  16. xmlns:default_db__x3A__crm_contracts="https://biuro.biall-net.pl/wfs/default_db/table/crm_contracts.xsd"
  17. xmlns:default_db__x3A__crm_contracttermtypes="https://biuro.biall-net.pl/wfs/default_db/table/crm_contracttermtypes.xsd"
  18. xmlns:default_db__x3A__crm_orderstatuses="https://biuro.biall-net.pl/wfs/default_db/table/crm_orderstatuses.xsd"
  19. xmlns:default_db__x3A__crm_doctemplatecategories="https://biuro.biall-net.pl/wfs/default_db/table/crm_doctemplatecategories.xsd"
  20. xmlns:default_db__x3A__crm_doctemplates="https://biuro.biall-net.pl/wfs/default_db/table/crm_doctemplates.xsd"
  21. xmlns:default_db__x3A__crm_coordinators="https://biuro.biall-net.pl/wfs/default_db/table/crm_coordinators.xsd"
  22. xmlns:default_db__x3A__fin_familiepayments="https://biuro.biall-net.pl/wfs/default_db/table/fin_familiepayments.xsd"
  23. xmlns:default_db__x3A__crm_filetypes="https://biuro.biall-net.pl/wfs/default_db/table/crm_filetypes.xsd"
  24. xmlns:default_db__x3A__crm_files="https://biuro.biall-net.pl/wfs/default_db/table/crm_files.xsd"
  25. xmlns:default_db__x3A__crm_notetypes="https://biuro.biall-net.pl/wfs/default_db/table/crm_notetypes.xsd"
  26. xmlns:default_db__x3A__crm_transports="https://biuro.biall-net.pl/wfs/default_db/table/crm_transports.xsd"
  27. xmlns:default_db__x3A__crm_transfersgroups="https://biuro.biall-net.pl/wfs/default_db/table/crm_transfersgroups.xsd"
  28. xmlns:default_db__x3A__crm_carrerbankdetails="https://biuro.biall-net.pl/wfs/default_db/table/crm_carrerbankdetails.xsd"
  29. xmlns:default_db__x3A__crm_transfergroupssparts="https://biuro.biall-net.pl/wfs/default_db/table/crm_transfergroupssparts.xsd"
  30. xmlns:default_db__x3A__crm_companies="https://biuro.biall-net.pl/wfs/default_db/table/crm_companies.xsd"
  31. xmlns:default_db__x3A__crm_transportstatuses="https://biuro.biall-net.pl/wfs/default_db/table/crm_transportstatuses.xsd"
  32. xmlns:default_db__x3A__crm_warddiseases="https://biuro.biall-net.pl/wfs/default_db/table/crm_warddiseases.xsd"
  33. xmlns:default_db__x3A__fin_invoices="https://biuro.biall-net.pl/wfs/default_db/table/fin_invoices.xsd"
  34. xmlns:default_db__x3A__crm_orderdayscalculationtypes="https://biuro.biall-net.pl/wfs/default_db/table/crm_orderdayscalculationtypes.xsd"
  35. xmlns:default_db__x3A__fin_paymenttypes="https://biuro.biall-net.pl/wfs/default_db/table/fin_paymenttypes.xsd"
  36. xmlns:default_db__x3A__imp_companies="https://biuro.biall-net.pl/wfs/default_db/table/imp_companies.xsd"
  37. xmlns:default_db__x3A__imp_users="https://biuro.biall-net.pl/wfs/default_db/table/imp_users.xsd"
  38. xmlns:default_db__x3A__sys_applications="https://biuro.biall-net.pl/wfs/default_db/table/sys_applications.xsd"
  39. xmlns:default_db__x3A__sys_accesses="https://biuro.biall-net.pl/wfs/default_db/table/sys_accesses.xsd"
  40. xmlns:default_db__x3A__sys_userstatuses="https://biuro.biall-net.pl/wfs/default_db/table/sys_userstatuses.xsd"
  41. xmlns:default_db__x3A__web_companies="https://biuro.biall-net.pl/wfs/default_db/table/web_companies.xsd"
  42. xmlns:default_db__x3A__web_users="https://biuro.biall-net.pl/wfs/default_db/table/web_users.xsd"
  43. xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
  44. xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types"
  45. targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/sys_users.xsd"
  46. system_cache__appinfo:restriction_path_TODEL=""
  47. system_cache__appinfo:sort="0"
  48. system_cache__appinfo:root_element_in_schema="true"
  49. system_cache__appinfo:prefix="default_db"
  50. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  51. system_cache__appinfo:document-uri-orig="/bravecom/bravecom_ele.xsd">
  52. <import namespace="https://biuro.biall-net.pl/wfs/default_db/table/sys_userstatuses.xsd"
  53. schemaLocation="default_db__x3A__sys_userstatuses.xsd"/>
  54. <xs:complexType xmlns:xs="http://www.w3.org/2001/XMLSchema"
  55. system_cache__appinfo:restriction_path_TODEL=""
  56. name="sys_users"
  57. id="default_d___d5e6178-1_sys_users"
  58. system_cache__appinfo:sort="0"
  59. system_cache__appinfo:root_element_in_schema="true"
  60. system_cache__appinfo:prefix="default_db"
  61. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"><!--#139 to include -->
  62. <xs:sequence system_cache__appinfo:restriction_path_TODEL=""
  63. id="default_d___d5e6179-1"
  64. system_cache__appinfo:sort="1"
  65. system_cache__appinfo:root_element_in_schema="true"
  66. system_cache__appinfo:prefix="default_db"
  67. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table">
  68. <xs:element system_cache__appinfo:sort="1"
  69. system_cache__appinfo:prefix="default_db"
  70. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  71. id="default_d___d5e6180-1_UserId"
  72. name="UserId"
  73. minOccurs="0"
  74. type="p5Type:integer"
  75. system_cache__appinfo:xpath_local="p5Type:integer"
  76. system_cache__appinfo:restriction_path=""/>
  77. <xs:element system_cache__appinfo:sort="1"
  78. system_cache__appinfo:prefix="default_db"
  79. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  80. id="default_d___d5e6181-1_UserStatus"
  81. name="UserStatusId"
  82. minOccurs="0"
  83. default="1"
  84. type="p5Type:integer"
  85. system_cache__appinfo:xpath_local="p5Type:integer"
  86. system_cache__appinfo:restriction_path=""/>
  87. <xs:element system_cache__appinfo:sort="1"
  88. system_cache__appinfo:prefix="default_db"
  89. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  90. id="default_d___d5e6182-1_CreatedDat"
  91. name="CreatedDateTime"
  92. minOccurs="0"
  93. default="CURRENT_TIMESTAMP"
  94. type="p5Type:dateTime"
  95. system_cache__appinfo:xpath_local="p5Type:dateTime"
  96. system_cache__appinfo:restriction_path=""/>
  97. <xs:element system_cache__appinfo:sort="1"
  98. system_cache__appinfo:prefix="default_db"
  99. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  100. id="default_d___d5e6183-1_LastUpdate"
  101. name="LastUpdateDateTime"
  102. minOccurs="0"
  103. nillable="true"
  104. default="CURRENT_TIMESTAMP"
  105. type="p5Type:integer"
  106. system_cache__appinfo:xpath_local="p5Type:integer"
  107. system_cache__appinfo:restriction_path=""/>
  108. <xs:element system_cache__appinfo:sort="1"
  109. system_cache__appinfo:prefix="default_db"
  110. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  111. id="default_d___d5e6184-1_Logon"
  112. name="Logon"
  113. minOccurs="0"
  114. type="p5Type:string"
  115. system_cache__appinfo:xpath_local="p5Type:string"
  116. system_cache__appinfo:restriction_path=""/>
  117. <xs:element system_cache__appinfo:sort="1"
  118. system_cache__appinfo:prefix="default_db"
  119. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  120. id="default_d___d5e6185-1_Passwd"
  121. name="Passwd"
  122. minOccurs="0"
  123. nillable="true"
  124. default=""
  125. type="p5Type:string"
  126. system_cache__appinfo:xpath_local="p5Type:string"
  127. system_cache__appinfo:restriction_path=""/>
  128. <xs:element system_cache__appinfo:sort="1"
  129. system_cache__appinfo:prefix="default_db"
  130. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  131. id="default_d___d5e6186-1_DisplayNam"
  132. name="DisplayName"
  133. minOccurs="0"
  134. nillable="true"
  135. default=""
  136. type="p5Type:string"
  137. system_cache__appinfo:xpath_local="p5Type:string"
  138. system_cache__appinfo:restriction_path=""/>
  139. <xs:element system_cache__appinfo:sort="1"
  140. system_cache__appinfo:prefix="default_db"
  141. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  142. id="default_d___d5e6187-1_Info"
  143. name="Info"
  144. minOccurs="0"
  145. nillable="true"
  146. default=""
  147. type="p5Type:text"
  148. system_cache__appinfo:xpath_local="p5Type:text"
  149. system_cache__appinfo:restriction_path=""/>
  150. <xs:element system_cache__appinfo:sort="1"
  151. system_cache__appinfo:prefix="default_db"
  152. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  153. id="default_d___d5e6188-1_IsAdmin"
  154. name="IsAdmin"
  155. minOccurs="0"
  156. default="0"
  157. type="p5Type:integer"
  158. system_cache__appinfo:xpath_local="p5Type:integer"
  159. system_cache__appinfo:restriction_path=""/>
  160. <xs:element system_cache__appinfo:sort="1"
  161. system_cache__appinfo:prefix="default_db"
  162. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  163. id="default_d___d5e6189-1_CreatedByU"
  164. name="CreatedByUserId"
  165. minOccurs="0"
  166. nillable="true"
  167. default=""
  168. type="p5Type:integer"
  169. system_cache__appinfo:xpath_local="p5Type:integer"
  170. system_cache__appinfo:restriction_path=""/>
  171. <xs:element system_cache__appinfo:sort="1"
  172. system_cache__appinfo:prefix="default_db"
  173. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  174. id="default_d___d5e6190-1_LastUpdate"
  175. name="LastUpdateUserId"
  176. minOccurs="0"
  177. nillable="true"
  178. default=""
  179. type="p5Type:integer"
  180. system_cache__appinfo:xpath_local="p5Type:integer"
  181. system_cache__appinfo:restriction_path=""/>
  182. <xs:element system_cache__appinfo:sort="1"
  183. system_cache__appinfo:prefix="default_db"
  184. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  185. id="default_d___d5e6192-1_IsDeleted"
  186. name="IsDeleted"
  187. minOccurs="0"
  188. default="0"
  189. type="p5Type:integer"
  190. system_cache__appinfo:xpath_local="p5Type:integer"
  191. system_cache__appinfo:restriction_path=""/>
  192. <xs:element system_cache__appinfo:sort="1"
  193. system_cache__appinfo:prefix="default_db"
  194. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  195. id="default_d___d5e6193-1_IsRekruit"
  196. name="IsRekruit"
  197. minOccurs="0"
  198. nillable="true"
  199. default="0"
  200. type="p5Type:integer"
  201. system_cache__appinfo:xpath_local="p5Type:integer"
  202. system_cache__appinfo:restriction_path=""/>
  203. <xs:element system_cache__appinfo:sort="1"
  204. system_cache__appinfo:prefix="default_db"
  205. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  206. id="default_d___d5e6194-1_IsCoordyna"
  207. name="IsCoordynator"
  208. minOccurs="0"
  209. nillable="true"
  210. default="0"
  211. type="p5Type:integer"
  212. system_cache__appinfo:xpath_local="p5Type:integer"
  213. system_cache__appinfo:restriction_path=""/>
  214. <xs:element system_cache__appinfo:sort="1"
  215. system_cache__appinfo:prefix="default_db"
  216. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  217. id="default_d___d5e6195-1_IsContract"
  218. name="IsContractsManager"
  219. minOccurs="0"
  220. nillable="true"
  221. default="0"
  222. type="p5Type:integer"
  223. system_cache__appinfo:xpath_local="p5Type:integer"
  224. system_cache__appinfo:restriction_path=""/>
  225. <xs:element system_cache__appinfo:sort="1"
  226. system_cache__appinfo:prefix="default_db"
  227. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  228. id="default_d___d5e6196-1_IsManager"
  229. name="IsManager"
  230. minOccurs="0"
  231. nillable="true"
  232. default="0"
  233. type="p5Type:integer"
  234. system_cache__appinfo:xpath_local="p5Type:integer"
  235. system_cache__appinfo:restriction_path=""/>
  236. <xs:element system_cache__appinfo:sort="1"
  237. system_cache__appinfo:prefix="default_db"
  238. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  239. id="default_d___d5e6197-1_IdCardNumb"
  240. name="IdCardNumber"
  241. minOccurs="0"
  242. nillable="true"
  243. default=""
  244. type="p5Type:string"
  245. system_cache__appinfo:xpath_local="p5Type:string"
  246. system_cache__appinfo:restriction_path=""/>
  247. <xs:element system_cache__appinfo:sort="1"
  248. system_cache__appinfo:prefix="default_db"
  249. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  250. id="default_d___d5e6198-1_PESEL"
  251. name="PESEL"
  252. minOccurs="0"
  253. nillable="true"
  254. default=""
  255. type="p5Type:string"
  256. system_cache__appinfo:xpath_local="p5Type:string"
  257. system_cache__appinfo:restriction_path=""/>
  258. <xs:element system_cache__appinfo:sort="1"
  259. system_cache__appinfo:prefix="default_db"
  260. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  261. id="default_d___d5e6199-1"
  262. ref="default_db__x3A__sys_userstatuses:sys_userstatuses"
  263. system_cache__appinfo:xpath_local="default_db:sys_userstatuses"
  264. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  265. <xs:annotation>
  266. <xs:appinfo>
  267. <system_cache__appinfo:flat_relation_cache>
  268. <system_cache__appinfo:source system_cache__appinfo:name="UserStatusId"
  269. system_cache__appinfo:xpath="default_db__x3A__sys_users__x3A__sys_userstatuses:sys_userstatuses/UserStatusId"/>
  270. </system_cache__appinfo:flat_relation_cache>
  271. </xs:appinfo>
  272. </xs:annotation>
  273. </xs:element>
  274. </xs:sequence>
  275. </xs:complexType>
  276. <xs:element xmlns:xs="http://www.w3.org/2001/XMLSchema"
  277. name="sys_users"
  278. type="default_db__x3A__sys_users:sys_users"
  279. id="default_d___d5e6203-1_sys_users"
  280. system_cache__appinfo:root_element_in_schema="true"
  281. system_cache__appinfo:xpath_local=""
  282. system_cache__appinfo:sort="1"
  283. system_cache__appinfo:prefix="default_db"
  284. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  285. system_cache__appinfo:restriction_path=""><!--#139 to include --></xs:element>
  286. </schema>