crm_a1s.xsd 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360
  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:default_db__x3A__crm_a1s="https://biuro.biall-net.pl/wfs/default_db/table/crm_a1s.xsd"
  44. xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
  45. xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types"
  46. targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/crm_a1s.xsd"
  47. system_cache__appinfo:restriction_path_TODEL=""
  48. system_cache__appinfo:sort="0"
  49. system_cache__appinfo:root_element_in_schema="true"
  50. system_cache__appinfo:prefix="default_db"
  51. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  52. system_cache__appinfo:document-uri-orig="/bravecom/bravecom_ele.xsd">
  53. <import namespace="https://biuro.biall-net.pl/wfs/default_db/table/sys_users.xsd"
  54. schemaLocation="default_db__x3A__sys_users.xsd"/>
  55. <xs:complexType xmlns:xs="http://www.w3.org/2001/XMLSchema"
  56. system_cache__appinfo:restriction_path_TODEL=""
  57. name="crm_a1s"
  58. id="default_d___d5e4141-1_crm_a1s"
  59. system_cache__appinfo:sort="0"
  60. system_cache__appinfo:root_element_in_schema="true"
  61. system_cache__appinfo:prefix="default_db"
  62. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"><!--#139 to include -->
  63. <xs:sequence system_cache__appinfo:restriction_path_TODEL=""
  64. id="default_d___d5e4142-1"
  65. system_cache__appinfo:sort="1"
  66. system_cache__appinfo:root_element_in_schema="true"
  67. system_cache__appinfo:prefix="default_db"
  68. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table">
  69. <xs:element system_cache__appinfo:sort="1"
  70. system_cache__appinfo:prefix="default_db"
  71. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  72. id="default_d___d5e4143-1_Id"
  73. name="Id"
  74. minOccurs="0"
  75. type="p5Type:integer"
  76. system_cache__appinfo:xpath_local="p5Type:integer"
  77. system_cache__appinfo:restriction_path=""/>
  78. <xs:element system_cache__appinfo:sort="1"
  79. system_cache__appinfo:prefix="default_db"
  80. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  81. id="default_d___d5e4144-1_CreatedByU"
  82. name="CreatedByUserId"
  83. minOccurs="0"
  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___d5e4145-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___d5e4146-1_LastUpdate"
  101. name="LastUpdateUserId"
  102. minOccurs="0"
  103. nillable="true"
  104. default=""
  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___d5e4147-1_LastUpdate"
  112. name="LastUpdateDateTime"
  113. minOccurs="0"
  114. default="CURRENT_TIMESTAMP"
  115. type="p5Type:integer"
  116. system_cache__appinfo:xpath_local="p5Type:integer"
  117. system_cache__appinfo:restriction_path=""/>
  118. <xs:element system_cache__appinfo:sort="1"
  119. system_cache__appinfo:prefix="default_db"
  120. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  121. id="default_d___d5e4148-1_IsDeleted"
  122. name="IsDeleted"
  123. minOccurs="0"
  124. default="0"
  125. type="p5Type:integer"
  126. system_cache__appinfo:xpath_local="p5Type:integer"
  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___d5e4149-1_CarrerId"
  132. name="CarrerId"
  133. minOccurs="0"
  134. type="p5Type:integer"
  135. system_cache__appinfo:xpath_local="p5Type:integer"
  136. system_cache__appinfo:restriction_path=""/>
  137. <xs:element system_cache__appinfo:sort="1"
  138. system_cache__appinfo:prefix="default_db"
  139. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  140. id="default_d___d5e4150-1_DateStart"
  141. name="DateStart"
  142. minOccurs="0"
  143. type="p5Type:date"
  144. system_cache__appinfo:xpath_local="p5Type:date"
  145. system_cache__appinfo:restriction_path=""/>
  146. <xs:element system_cache__appinfo:sort="1"
  147. system_cache__appinfo:prefix="default_db"
  148. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  149. id="default_d___d5e4151-1_DateEnd"
  150. name="DateEnd"
  151. minOccurs="0"
  152. type="p5Type:date"
  153. system_cache__appinfo:xpath_local="p5Type:date"
  154. system_cache__appinfo:restriction_path=""/>
  155. <xs:element system_cache__appinfo:sort="1"
  156. system_cache__appinfo:prefix="default_db"
  157. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  158. id="default_d___d5e4152-1_Number"
  159. name="Number"
  160. minOccurs="0"
  161. nillable="true"
  162. default=""
  163. type="p5Type:string"
  164. system_cache__appinfo:xpath_local="p5Type:string"
  165. system_cache__appinfo:restriction_path=""/>
  166. <xs:element system_cache__appinfo:sort="1"
  167. system_cache__appinfo:prefix="default_db"
  168. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  169. id="default_d___d5e4153-1_Info"
  170. name="Info"
  171. minOccurs="0"
  172. nillable="true"
  173. default=""
  174. type="p5Type:text"
  175. system_cache__appinfo:xpath_local="p5Type:text"
  176. system_cache__appinfo:restriction_path=""/>
  177. <xs:element system_cache__appinfo:sort="1"
  178. system_cache__appinfo:prefix="default_db"
  179. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  180. id="default_d___d5e4155-1_StatusId"
  181. name="StatusId"
  182. minOccurs="0"
  183. nillable="true"
  184. default="1"
  185. type="p5Type:integer"
  186. system_cache__appinfo:xpath_local="p5Type:integer"
  187. system_cache__appinfo:restriction_path=""/>
  188. <xs:element system_cache__appinfo:sort="1"
  189. system_cache__appinfo:prefix="default_db"
  190. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  191. id="default_d___d5e4156-1_SentToAcco"
  192. name="SentToAccountants"
  193. minOccurs="0"
  194. default="0"
  195. type="p5Type:integer"
  196. system_cache__appinfo:xpath_local="p5Type:integer"
  197. system_cache__appinfo:restriction_path=""/>
  198. <xs:element system_cache__appinfo:sort="1"
  199. system_cache__appinfo:prefix="default_db"
  200. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  201. id="default_d___d5e4157-1_SentToAccD"
  202. name="SentToAccDate"
  203. minOccurs="0"
  204. nillable="true"
  205. default=""
  206. type="p5Type:date"
  207. system_cache__appinfo:xpath_local="p5Type:date"
  208. system_cache__appinfo:restriction_path=""/>
  209. <xs:element system_cache__appinfo:sort="1"
  210. system_cache__appinfo:prefix="default_db"
  211. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  212. id="default_d___d5e4158-1_SentToAccU"
  213. name="SentToAccUser"
  214. minOccurs="0"
  215. nillable="true"
  216. default=""
  217. type="p5Type:integer"
  218. system_cache__appinfo:xpath_local="p5Type:integer"
  219. system_cache__appinfo:restriction_path=""/>
  220. <xs:element system_cache__appinfo:sort="1"
  221. system_cache__appinfo:prefix="default_db"
  222. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  223. id="default_d___d5e4159-1_ReciveFrom"
  224. name="ReciveFromAcc"
  225. minOccurs="0"
  226. default="0"
  227. type="p5Type:integer"
  228. system_cache__appinfo:xpath_local="p5Type:integer"
  229. system_cache__appinfo:restriction_path=""/>
  230. <xs:element system_cache__appinfo:sort="1"
  231. system_cache__appinfo:prefix="default_db"
  232. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  233. id="default_d___d5e4160-1_ReciveFrom"
  234. name="ReciveFromAccDate"
  235. minOccurs="0"
  236. nillable="true"
  237. default=""
  238. type="p5Type:date"
  239. system_cache__appinfo:xpath_local="p5Type:date"
  240. system_cache__appinfo:restriction_path=""/>
  241. <xs:element system_cache__appinfo:sort="1"
  242. system_cache__appinfo:prefix="default_db"
  243. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  244. id="default_d___d5e4161-1_ReciveFrom"
  245. name="ReciveFromAccUser"
  246. minOccurs="0"
  247. nillable="true"
  248. default=""
  249. type="p5Type:integer"
  250. system_cache__appinfo:xpath_local="p5Type:integer"
  251. system_cache__appinfo:restriction_path=""/>
  252. <xs:element system_cache__appinfo:sort="1"
  253. system_cache__appinfo:prefix="default_db"
  254. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  255. id="default_d___d5e4162-1_SentToZUS"
  256. name="SentToZUS"
  257. minOccurs="0"
  258. default="0"
  259. type="p5Type:integer"
  260. system_cache__appinfo:xpath_local="p5Type:integer"
  261. system_cache__appinfo:restriction_path=""/>
  262. <xs:element system_cache__appinfo:sort="1"
  263. system_cache__appinfo:prefix="default_db"
  264. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  265. id="default_d___d5e4163-1_SentToZUSD"
  266. name="SentToZUSDate"
  267. minOccurs="0"
  268. nillable="true"
  269. default=""
  270. type="p5Type:date"
  271. system_cache__appinfo:xpath_local="p5Type:date"
  272. system_cache__appinfo:restriction_path=""/>
  273. <xs:element system_cache__appinfo:sort="1"
  274. system_cache__appinfo:prefix="default_db"
  275. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  276. id="default_d___d5e4164-1_SentToZUSU"
  277. name="SentToZUSUser"
  278. minOccurs="0"
  279. nillable="true"
  280. default=""
  281. type="p5Type:string"
  282. system_cache__appinfo:xpath_local="p5Type:string"
  283. system_cache__appinfo:restriction_path=""/>
  284. <xs:element system_cache__appinfo:sort="1"
  285. system_cache__appinfo:prefix="default_db"
  286. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  287. id="default_d___d5e4165-1_ReciveFrom"
  288. name="ReciveFromZUS"
  289. minOccurs="0"
  290. default="0"
  291. type="p5Type:integer"
  292. system_cache__appinfo:xpath_local="p5Type:integer"
  293. system_cache__appinfo:restriction_path=""/>
  294. <xs:element system_cache__appinfo:sort="1"
  295. system_cache__appinfo:prefix="default_db"
  296. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  297. id="default_d___d5e4167-1_ReciveFrom"
  298. name="ReciveFromZUSDate"
  299. minOccurs="0"
  300. nillable="true"
  301. default=""
  302. type="p5Type:date"
  303. system_cache__appinfo:xpath_local="p5Type:date"
  304. system_cache__appinfo:restriction_path=""/>
  305. <xs:element system_cache__appinfo:sort="1"
  306. system_cache__appinfo:prefix="default_db"
  307. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  308. id="default_d___d5e4168-1_ReciveFrom"
  309. name="ReciveFromZUSUser"
  310. minOccurs="0"
  311. nillable="true"
  312. default=""
  313. type="p5Type:integer"
  314. system_cache__appinfo:xpath_local="p5Type:integer"
  315. system_cache__appinfo:restriction_path=""/>
  316. <xs:element system_cache__appinfo:sort="1"
  317. system_cache__appinfo:prefix="default_db"
  318. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  319. id="default_d___d5e4169-1"
  320. ref="default_db__x3A__sys_users:sys_users"
  321. system_cache__appinfo:xpath_local="default_db:sys_users"
  322. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  323. <xs:annotation>
  324. <xs:appinfo>
  325. <system_cache__appinfo:flat_relation_cache>
  326. <system_cache__appinfo:source system_cache__appinfo:name="CreatedByUserId"
  327. system_cache__appinfo:xpath="default_db__x3A__crm_a1s__x3A__sys_users:sys_users/UserId"/>
  328. </system_cache__appinfo:flat_relation_cache>
  329. </xs:appinfo>
  330. </xs:annotation>
  331. </xs:element>
  332. <xs:element system_cache__appinfo:sort="1"
  333. system_cache__appinfo:prefix="default_db"
  334. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  335. id="default_d___d5e4173-1"
  336. ref="default_db__x3A__sys_users:sys_users"
  337. system_cache__appinfo:xpath_local="default_db:sys_users"
  338. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  339. <xs:annotation>
  340. <xs:appinfo>
  341. <system_cache__appinfo:flat_relation_cache>
  342. <system_cache__appinfo:source system_cache__appinfo:name="LastUpdateUserId"
  343. system_cache__appinfo:xpath="default_db__x3A__crm_a1s__x3A__sys_users:sys_users/UserId"/>
  344. </system_cache__appinfo:flat_relation_cache>
  345. </xs:appinfo>
  346. </xs:annotation>
  347. </xs:element>
  348. </xs:sequence>
  349. </xs:complexType>
  350. <xs:element xmlns:xs="http://www.w3.org/2001/XMLSchema"
  351. name="crm_a1s"
  352. type="default_db__x3A__crm_a1s:crm_a1s"
  353. id="default_d___d5e4177-1_crm_a1s"
  354. system_cache__appinfo:root_element_in_schema="true"
  355. system_cache__appinfo:xpath_local=""
  356. system_cache__appinfo:sort="1"
  357. system_cache__appinfo:prefix="default_db"
  358. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  359. system_cache__appinfo:restriction_path=""><!--#139 to include --></xs:element>
  360. </schema>