crm_families.xsd 36 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599
  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/crm_families.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/crm_coordinators.xsd"
  53. schemaLocation="default_db__x3A__crm_coordinators.xsd"/>
  54. <import namespace="https://biuro.biall-net.pl/wfs/default_db/table/sys_users.xsd"
  55. schemaLocation="default_db__x3A__sys_users.xsd"/>
  56. <xs:complexType xmlns:xs="http://www.w3.org/2001/XMLSchema"
  57. system_cache__appinfo:restriction_path_TODEL=""
  58. name="crm_families"
  59. id="default_d___d5e4793-1_crm_famili"
  60. system_cache__appinfo:sort="0"
  61. system_cache__appinfo:root_element_in_schema="true"
  62. system_cache__appinfo:prefix="default_db"
  63. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"><!--#139 to include -->
  64. <xs:sequence system_cache__appinfo:restriction_path_TODEL=""
  65. id="default_d___d5e4794-1"
  66. system_cache__appinfo:sort="1"
  67. system_cache__appinfo:root_element_in_schema="true"
  68. system_cache__appinfo:prefix="default_db"
  69. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table">
  70. <xs:element system_cache__appinfo:sort="1"
  71. system_cache__appinfo:prefix="default_db"
  72. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  73. id="default_d___d5e4795-1_Id"
  74. name="Id"
  75. minOccurs="0"
  76. type="p5Type:integer"
  77. system_cache__appinfo:xpath_local="p5Type:integer"
  78. system_cache__appinfo:restriction_path=""/>
  79. <xs:element system_cache__appinfo:sort="1"
  80. system_cache__appinfo:prefix="default_db"
  81. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  82. id="default_d___d5e4796-1_CreatedByU"
  83. name="CreatedByUserId"
  84. minOccurs="0"
  85. type="p5Type:integer"
  86. system_cache__appinfo:xpath_local="p5Type:integer"
  87. system_cache__appinfo:restriction_path=""/>
  88. <xs:element system_cache__appinfo:sort="1"
  89. system_cache__appinfo:prefix="default_db"
  90. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  91. id="default_d___d5e4797-1_CreatedDat"
  92. name="CreatedDateTime"
  93. minOccurs="0"
  94. default="CURRENT_TIMESTAMP"
  95. type="p5Type:dateTime"
  96. system_cache__appinfo:xpath_local="p5Type:dateTime"
  97. system_cache__appinfo:restriction_path=""/>
  98. <xs:element system_cache__appinfo:sort="1"
  99. system_cache__appinfo:prefix="default_db"
  100. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  101. id="default_d___d5e4798-1_LastUpdate"
  102. name="LastUpdateUserId"
  103. minOccurs="0"
  104. nillable="true"
  105. default=""
  106. type="p5Type:integer"
  107. system_cache__appinfo:xpath_local="p5Type:integer"
  108. system_cache__appinfo:restriction_path=""/>
  109. <xs:element system_cache__appinfo:sort="1"
  110. system_cache__appinfo:prefix="default_db"
  111. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  112. id="default_d___d5e4799-1_LastUpdate"
  113. name="LastUpdateDateTime"
  114. minOccurs="0"
  115. default="CURRENT_TIMESTAMP"
  116. type="p5Type:integer"
  117. system_cache__appinfo:xpath_local="p5Type:integer"
  118. system_cache__appinfo:restriction_path=""/>
  119. <xs:element system_cache__appinfo:sort="1"
  120. system_cache__appinfo:prefix="default_db"
  121. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  122. id="default_d___d5e4800-1_IsDeleted"
  123. name="IsDeleted"
  124. minOccurs="0"
  125. default="0"
  126. type="p5Type:integer"
  127. system_cache__appinfo:xpath_local="p5Type:integer"
  128. system_cache__appinfo:restriction_path=""/>
  129. <xs:element system_cache__appinfo:sort="1"
  130. system_cache__appinfo:prefix="default_db"
  131. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  132. id="default_d___d5e4801-1_FamilyName"
  133. name="FamilyName"
  134. minOccurs="0"
  135. type="p5Type:string"
  136. system_cache__appinfo:xpath_local="p5Type:string"
  137. system_cache__appinfo:restriction_path=""/>
  138. <xs:element system_cache__appinfo:sort="1"
  139. system_cache__appinfo:prefix="default_db"
  140. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  141. id="default_d___d5e4802-1_WardFirstN"
  142. name="WardFirstName"
  143. minOccurs="0"
  144. nillable="true"
  145. default=""
  146. type="p5Type:string"
  147. system_cache__appinfo:xpath_local="p5Type:string"
  148. system_cache__appinfo:restriction_path=""/>
  149. <xs:element system_cache__appinfo:sort="1"
  150. system_cache__appinfo:prefix="default_db"
  151. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  152. id="default_d___d5e4803-1_WardSecond"
  153. name="WardSecondName"
  154. minOccurs="0"
  155. nillable="true"
  156. default=""
  157. type="p5Type:string"
  158. system_cache__appinfo:xpath_local="p5Type:string"
  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___d5e4804-1_WardSurNam"
  164. name="WardSurName"
  165. minOccurs="0"
  166. nillable="true"
  167. default=""
  168. type="p5Type:string"
  169. system_cache__appinfo:xpath_local="p5Type:string"
  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___d5e4805-1_WardBirthD"
  175. name="WardBirthDate"
  176. minOccurs="0"
  177. nillable="true"
  178. default=""
  179. type="p5Type:date"
  180. system_cache__appinfo:xpath_local="p5Type:date"
  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___d5e4807-1_WardHeight"
  186. name="WardHeight"
  187. minOccurs="0"
  188. nillable="true"
  189. default=""
  190. type="p5Type:integer"
  191. system_cache__appinfo:xpath_local="p5Type:integer"
  192. system_cache__appinfo:restriction_path=""/>
  193. <xs:element system_cache__appinfo:sort="1"
  194. system_cache__appinfo:prefix="default_db"
  195. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  196. id="default_d___d5e4808-1_WardWeight"
  197. name="WardWeight"
  198. minOccurs="0"
  199. nillable="true"
  200. default=""
  201. type="p5Type:integer"
  202. system_cache__appinfo:xpath_local="p5Type:integer"
  203. system_cache__appinfo:restriction_path=""/>
  204. <xs:element system_cache__appinfo:sort="1"
  205. system_cache__appinfo:prefix="default_db"
  206. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  207. id="default_d___d5e4809-1_PayerFirst"
  208. name="PayerFirstName"
  209. minOccurs="0"
  210. nillable="true"
  211. default=""
  212. type="p5Type:string"
  213. system_cache__appinfo:xpath_local="p5Type:string"
  214. system_cache__appinfo:restriction_path=""/>
  215. <xs:element system_cache__appinfo:sort="1"
  216. system_cache__appinfo:prefix="default_db"
  217. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  218. id="default_d___d5e4810-1_PayerSecon"
  219. name="PayerSecondName"
  220. minOccurs="0"
  221. nillable="true"
  222. default=""
  223. type="p5Type:string"
  224. system_cache__appinfo:xpath_local="p5Type:string"
  225. system_cache__appinfo:restriction_path=""/>
  226. <xs:element system_cache__appinfo:sort="1"
  227. system_cache__appinfo:prefix="default_db"
  228. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  229. id="default_d___d5e4811-1_PayerSurNa"
  230. name="PayerSurName"
  231. minOccurs="0"
  232. nillable="true"
  233. default=""
  234. type="p5Type:string"
  235. system_cache__appinfo:xpath_local="p5Type:string"
  236. system_cache__appinfo:restriction_path=""/>
  237. <xs:element system_cache__appinfo:sort="1"
  238. system_cache__appinfo:prefix="default_db"
  239. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  240. id="default_d___d5e4812-1_Phone1"
  241. name="Phone1"
  242. minOccurs="0"
  243. nillable="true"
  244. default=""
  245. type="p5Type:string"
  246. system_cache__appinfo:xpath_local="p5Type:string"
  247. system_cache__appinfo:restriction_path=""/>
  248. <xs:element system_cache__appinfo:sort="1"
  249. system_cache__appinfo:prefix="default_db"
  250. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  251. id="default_d___d5e4813-1_Phone2"
  252. name="Phone2"
  253. minOccurs="0"
  254. nillable="true"
  255. default=""
  256. type="p5Type:string"
  257. system_cache__appinfo:xpath_local="p5Type:string"
  258. system_cache__appinfo:restriction_path=""/>
  259. <xs:element system_cache__appinfo:sort="1"
  260. system_cache__appinfo:prefix="default_db"
  261. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  262. id="default_d___d5e4814-1_EMail"
  263. name="EMail"
  264. minOccurs="0"
  265. nillable="true"
  266. default=""
  267. type="p5Type:string"
  268. system_cache__appinfo:xpath_local="p5Type:string"
  269. system_cache__appinfo:restriction_path=""/>
  270. <xs:element system_cache__appinfo:sort="1"
  271. system_cache__appinfo:prefix="default_db"
  272. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  273. id="default_d___d5e4815-1_CoordId"
  274. name="CoordId"
  275. minOccurs="0"
  276. nillable="true"
  277. default=""
  278. type="p5Type:integer"
  279. system_cache__appinfo:xpath_local="p5Type:integer"
  280. system_cache__appinfo:restriction_path=""/>
  281. <xs:element system_cache__appinfo:sort="1"
  282. system_cache__appinfo:prefix="default_db"
  283. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  284. id="default_d___d5e4816-1_HealthStat"
  285. name="HealthState"
  286. minOccurs="0"
  287. nillable="true"
  288. default=""
  289. type="p5Type:string"
  290. system_cache__appinfo:xpath_local="p5Type:string"
  291. system_cache__appinfo:restriction_path=""/>
  292. <xs:element system_cache__appinfo:sort="1"
  293. system_cache__appinfo:prefix="default_db"
  294. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  295. id="default_d___d5e4817-1_Info"
  296. name="Info"
  297. minOccurs="0"
  298. nillable="true"
  299. default=""
  300. type="p5Type:text"
  301. system_cache__appinfo:xpath_local="p5Type:text"
  302. system_cache__appinfo:restriction_path=""/>
  303. <xs:element system_cache__appinfo:sort="1"
  304. system_cache__appinfo:prefix="default_db"
  305. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  306. id="default_d___d5e4819-1_Ward2First"
  307. name="Ward2FirstName"
  308. minOccurs="0"
  309. nillable="true"
  310. default=""
  311. type="p5Type:string"
  312. system_cache__appinfo:xpath_local="p5Type:string"
  313. system_cache__appinfo:restriction_path=""/>
  314. <xs:element system_cache__appinfo:sort="1"
  315. system_cache__appinfo:prefix="default_db"
  316. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  317. id="default_d___d5e4820-1_Ward2Secon"
  318. name="Ward2SecondName"
  319. minOccurs="0"
  320. nillable="true"
  321. default=""
  322. type="p5Type:string"
  323. system_cache__appinfo:xpath_local="p5Type:string"
  324. system_cache__appinfo:restriction_path=""/>
  325. <xs:element system_cache__appinfo:sort="1"
  326. system_cache__appinfo:prefix="default_db"
  327. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  328. id="default_d___d5e4821-1_Ward2SurNa"
  329. name="Ward2SurName"
  330. minOccurs="0"
  331. nillable="true"
  332. default=""
  333. type="p5Type:string"
  334. system_cache__appinfo:xpath_local="p5Type:string"
  335. system_cache__appinfo:restriction_path=""/>
  336. <xs:element system_cache__appinfo:sort="1"
  337. system_cache__appinfo:prefix="default_db"
  338. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  339. id="default_d___d5e4822-1_Ward2Birth"
  340. name="Ward2BirthDate"
  341. minOccurs="0"
  342. nillable="true"
  343. default=""
  344. type="p5Type:date"
  345. system_cache__appinfo:xpath_local="p5Type:date"
  346. system_cache__appinfo:restriction_path=""/>
  347. <xs:element system_cache__appinfo:sort="1"
  348. system_cache__appinfo:prefix="default_db"
  349. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  350. id="default_d___d5e4823-1_Ward2Heigh"
  351. name="Ward2Height"
  352. minOccurs="0"
  353. nillable="true"
  354. default=""
  355. type="p5Type:integer"
  356. system_cache__appinfo:xpath_local="p5Type:integer"
  357. system_cache__appinfo:restriction_path=""/>
  358. <xs:element system_cache__appinfo:sort="1"
  359. system_cache__appinfo:prefix="default_db"
  360. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  361. id="default_d___d5e4824-1_Ward2Weigh"
  362. name="Ward2Weight"
  363. minOccurs="0"
  364. nillable="true"
  365. default=""
  366. type="p5Type:integer"
  367. system_cache__appinfo:xpath_local="p5Type:integer"
  368. system_cache__appinfo:restriction_path=""/>
  369. <xs:element system_cache__appinfo:sort="1"
  370. system_cache__appinfo:prefix="default_db"
  371. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  372. id="default_d___d5e4825-1_ReqGenderI"
  373. name="ReqGenderId"
  374. minOccurs="0"
  375. nillable="true"
  376. default="0"
  377. type="p5Type:integer"
  378. system_cache__appinfo:xpath_local="p5Type:integer"
  379. system_cache__appinfo:restriction_path=""/>
  380. <xs:element system_cache__appinfo:sort="1"
  381. system_cache__appinfo:prefix="default_db"
  382. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  383. id="default_d___d5e4826-1_ReqLanguag"
  384. name="ReqLanguageLevelId"
  385. minOccurs="0"
  386. nillable="true"
  387. default="1"
  388. type="p5Type:integer"
  389. system_cache__appinfo:xpath_local="p5Type:integer"
  390. system_cache__appinfo:restriction_path=""/>
  391. <xs:element system_cache__appinfo:sort="1"
  392. system_cache__appinfo:prefix="default_db"
  393. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  394. id="default_d___d5e4827-1_ReqNotSmok"
  395. name="ReqNotSmoking"
  396. minOccurs="0"
  397. default="0"
  398. type="p5Type:integer"
  399. system_cache__appinfo:xpath_local="p5Type:integer"
  400. system_cache__appinfo:restriction_path=""/>
  401. <xs:element system_cache__appinfo:sort="1"
  402. system_cache__appinfo:prefix="default_db"
  403. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  404. id="default_d___d5e4828-1_ReqDriveLi"
  405. name="ReqDriveLicence"
  406. minOccurs="0"
  407. default="0"
  408. type="p5Type:integer"
  409. system_cache__appinfo:xpath_local="p5Type:integer"
  410. system_cache__appinfo:restriction_path=""/>
  411. <xs:element system_cache__appinfo:sort="1"
  412. system_cache__appinfo:prefix="default_db"
  413. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  414. id="default_d___d5e4829-1_ReqExperie"
  415. name="ReqExperience"
  416. minOccurs="0"
  417. default="0"
  418. type="p5Type:integer"
  419. system_cache__appinfo:xpath_local="p5Type:integer"
  420. system_cache__appinfo:restriction_path=""/>
  421. <xs:element system_cache__appinfo:sort="1"
  422. system_cache__appinfo:prefix="default_db"
  423. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  424. id="default_d___d5e4831-1_ReqPrefere"
  425. name="ReqPreferedAgeId"
  426. minOccurs="0"
  427. default="0"
  428. type="p5Type:integer"
  429. system_cache__appinfo:xpath_local="p5Type:integer"
  430. system_cache__appinfo:restriction_path=""/>
  431. <xs:element system_cache__appinfo:sort="1"
  432. system_cache__appinfo:prefix="default_db"
  433. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  434. id="default_d___d5e4832-1_AccountNum"
  435. name="AccountNumber"
  436. minOccurs="0"
  437. nillable="true"
  438. default=""
  439. type="p5Type:string"
  440. system_cache__appinfo:xpath_local="p5Type:string"
  441. system_cache__appinfo:restriction_path=""/>
  442. <xs:element system_cache__appinfo:sort="1"
  443. system_cache__appinfo:prefix="default_db"
  444. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  445. id="default_d___d5e4833-1_HealthStat"
  446. name="HealthState2"
  447. minOccurs="0"
  448. nillable="true"
  449. default=""
  450. type="p5Type:string"
  451. system_cache__appinfo:xpath_local="p5Type:string"
  452. system_cache__appinfo:restriction_path=""/>
  453. <xs:element system_cache__appinfo:sort="1"
  454. system_cache__appinfo:prefix="default_db"
  455. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  456. id="default_d___d5e4834-1_MainPhoneN"
  457. name="MainPhoneNumber"
  458. minOccurs="0"
  459. nillable="true"
  460. default=""
  461. type="p5Type:string"
  462. system_cache__appinfo:xpath_local="p5Type:string"
  463. system_cache__appinfo:restriction_path=""/>
  464. <xs:element system_cache__appinfo:sort="1"
  465. system_cache__appinfo:prefix="default_db"
  466. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  467. id="default_d___d5e4835-1_DateStart"
  468. name="DateStart"
  469. minOccurs="0"
  470. nillable="true"
  471. default=""
  472. type="p5Type:date"
  473. system_cache__appinfo:xpath_local="p5Type:date"
  474. system_cache__appinfo:restriction_path=""/>
  475. <xs:element system_cache__appinfo:sort="1"
  476. system_cache__appinfo:prefix="default_db"
  477. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  478. id="default_d___d5e4836-1_DateEnd"
  479. name="DateEnd"
  480. minOccurs="0"
  481. nillable="true"
  482. default=""
  483. type="p5Type:date"
  484. system_cache__appinfo:xpath_local="p5Type:date"
  485. system_cache__appinfo:restriction_path=""/>
  486. <xs:element system_cache__appinfo:sort="1"
  487. system_cache__appinfo:prefix="default_db"
  488. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  489. id="default_d___d5e4837-1_DaysCalcul"
  490. name="DaysCalculationTypeId"
  491. minOccurs="0"
  492. default="4"
  493. type="p5Type:integer"
  494. system_cache__appinfo:xpath_local="p5Type:integer"
  495. system_cache__appinfo:restriction_path=""/>
  496. <xs:element system_cache__appinfo:sort="1"
  497. system_cache__appinfo:prefix="default_db"
  498. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  499. id="default_d___d5e4838-1_IsActive"
  500. name="IsActive"
  501. minOccurs="0"
  502. default="1"
  503. type="p5Type:integer"
  504. system_cache__appinfo:xpath_local="p5Type:integer"
  505. system_cache__appinfo:restriction_path=""/>
  506. <xs:element system_cache__appinfo:sort="1"
  507. system_cache__appinfo:prefix="default_db"
  508. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  509. id="default_d___d5e4839-1_CloseReaso"
  510. name="CloseReason"
  511. minOccurs="0"
  512. nillable="true"
  513. default=""
  514. type="p5Type:string"
  515. system_cache__appinfo:xpath_local="p5Type:string"
  516. system_cache__appinfo:restriction_path=""/>
  517. <xs:element system_cache__appinfo:sort="1"
  518. system_cache__appinfo:prefix="default_db"
  519. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  520. id="default_d___d5e4840-1_ClosedByUs"
  521. name="ClosedByUserID"
  522. minOccurs="0"
  523. nillable="true"
  524. default=""
  525. type="p5Type:integer"
  526. system_cache__appinfo:xpath_local="p5Type:integer"
  527. system_cache__appinfo:restriction_path=""/>
  528. <xs:element system_cache__appinfo:sort="1"
  529. system_cache__appinfo:prefix="default_db"
  530. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  531. id="default_d___d5e4841-1_CompanyId"
  532. name="CompanyId"
  533. minOccurs="0"
  534. nillable="true"
  535. default=""
  536. type="p5Type:integer"
  537. system_cache__appinfo:xpath_local="p5Type:integer"
  538. system_cache__appinfo:restriction_path=""/>
  539. <xs:element system_cache__appinfo:sort="1"
  540. system_cache__appinfo:prefix="default_db"
  541. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  542. id="default_d___d5e4843-1"
  543. ref="default_db__x3A__crm_coordinators:crm_coordinators"
  544. system_cache__appinfo:xpath_local="default_db:crm_coordinators"
  545. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  546. <xs:annotation>
  547. <xs:appinfo>
  548. <system_cache__appinfo:flat_relation_cache>
  549. <system_cache__appinfo:source system_cache__appinfo:name="CoordId"
  550. system_cache__appinfo:xpath="default_db__x3A__crm_families__x3A__crm_coordinators:crm_coordinators/Id"/>
  551. </system_cache__appinfo:flat_relation_cache>
  552. </xs:appinfo>
  553. </xs:annotation>
  554. </xs:element>
  555. <xs:element system_cache__appinfo:sort="1"
  556. system_cache__appinfo:prefix="default_db"
  557. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  558. id="default_d___d5e4847-1"
  559. ref="default_db__x3A__sys_users:sys_users"
  560. system_cache__appinfo:xpath_local="default_db:sys_users"
  561. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  562. <xs:annotation>
  563. <xs:appinfo>
  564. <system_cache__appinfo:flat_relation_cache>
  565. <system_cache__appinfo:source system_cache__appinfo:name="CreatedByUserId"
  566. system_cache__appinfo:xpath="default_db__x3A__crm_families__x3A__sys_users:sys_users/UserId"/>
  567. </system_cache__appinfo:flat_relation_cache>
  568. </xs:appinfo>
  569. </xs:annotation>
  570. </xs:element>
  571. <xs:element system_cache__appinfo:sort="1"
  572. system_cache__appinfo:prefix="default_db"
  573. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  574. id="default_d___d5e4851-1"
  575. ref="default_db__x3A__sys_users:sys_users"
  576. system_cache__appinfo:xpath_local="default_db:sys_users"
  577. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  578. <xs:annotation>
  579. <xs:appinfo>
  580. <system_cache__appinfo:flat_relation_cache>
  581. <system_cache__appinfo:source system_cache__appinfo:name="LastUpdateUserId"
  582. system_cache__appinfo:xpath="default_db__x3A__crm_families__x3A__sys_users:sys_users/UserId"/>
  583. </system_cache__appinfo:flat_relation_cache>
  584. </xs:appinfo>
  585. </xs:annotation>
  586. </xs:element>
  587. </xs:sequence>
  588. </xs:complexType>
  589. <xs:element xmlns:xs="http://www.w3.org/2001/XMLSchema"
  590. name="crm_families"
  591. type="default_db__x3A__crm_families:crm_families"
  592. id="default_d___d5e4855-1_crm_famili"
  593. system_cache__appinfo:root_element_in_schema="true"
  594. system_cache__appinfo:xpath_local=""
  595. system_cache__appinfo:sort="1"
  596. system_cache__appinfo:prefix="default_db"
  597. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  598. system_cache__appinfo:restriction_path=""><!--#139 to include --></xs:element>
  599. </schema>