crm_newcontractrequests.xsd 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270
  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_newcontractrequests="https://biuro.biall-net.pl/wfs/default_db/table/crm_newcontractrequests.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_newcontractrequests.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. <import namespace="https://biuro.biall-net.pl/wfs/default_db/table/car_carrers.xsd"
  56. schemaLocation="default_db__x3A__car_carrers.xsd"/>
  57. <xs:complexType xmlns:xs="http://www.w3.org/2001/XMLSchema"
  58. system_cache__appinfo:restriction_path_TODEL=""
  59. name="crm_newcontractrequests"
  60. id="default_d___d5e5000-1_crm_newcon"
  61. system_cache__appinfo:sort="0"
  62. system_cache__appinfo:root_element_in_schema="true"
  63. system_cache__appinfo:prefix="default_db"
  64. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"><!--#139 to include -->
  65. <xs:sequence system_cache__appinfo:restriction_path_TODEL=""
  66. id="default_d___d5e5001-1"
  67. system_cache__appinfo:sort="1"
  68. system_cache__appinfo:root_element_in_schema="true"
  69. system_cache__appinfo:prefix="default_db"
  70. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table">
  71. <xs:element system_cache__appinfo:sort="1"
  72. system_cache__appinfo:prefix="default_db"
  73. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  74. id="default_d___d5e5002-1_Id"
  75. name="Id"
  76. minOccurs="0"
  77. type="p5Type:integer"
  78. system_cache__appinfo:xpath_local="p5Type:integer"
  79. system_cache__appinfo:restriction_path=""/>
  80. <xs:element system_cache__appinfo:sort="1"
  81. system_cache__appinfo:prefix="default_db"
  82. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  83. id="default_d___d5e5003-1_CreatedByU"
  84. name="CreatedByUserId"
  85. minOccurs="0"
  86. type="p5Type:integer"
  87. system_cache__appinfo:xpath_local="p5Type:integer"
  88. system_cache__appinfo:restriction_path=""/>
  89. <xs:element system_cache__appinfo:sort="1"
  90. system_cache__appinfo:prefix="default_db"
  91. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  92. id="default_d___d5e5004-1_CreatedDat"
  93. name="CreatedDateTime"
  94. minOccurs="0"
  95. default="CURRENT_TIMESTAMP"
  96. type="p5Type:dateTime"
  97. system_cache__appinfo:xpath_local="p5Type:dateTime"
  98. system_cache__appinfo:restriction_path=""/>
  99. <xs:element system_cache__appinfo:sort="1"
  100. system_cache__appinfo:prefix="default_db"
  101. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  102. id="default_d___d5e5005-1_LastUpdate"
  103. name="LastUpdateUserId"
  104. minOccurs="0"
  105. nillable="true"
  106. default=""
  107. type="p5Type:integer"
  108. system_cache__appinfo:xpath_local="p5Type:integer"
  109. system_cache__appinfo:restriction_path=""/>
  110. <xs:element system_cache__appinfo:sort="1"
  111. system_cache__appinfo:prefix="default_db"
  112. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  113. id="default_d___d5e5006-1_LastUpdate"
  114. name="LastUpdateDateTime"
  115. minOccurs="0"
  116. default="CURRENT_TIMESTAMP"
  117. type="p5Type:integer"
  118. system_cache__appinfo:xpath_local="p5Type:integer"
  119. system_cache__appinfo:restriction_path=""/>
  120. <xs:element system_cache__appinfo:sort="1"
  121. system_cache__appinfo:prefix="default_db"
  122. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  123. id="default_d___d5e5007-1_IsDeleted"
  124. name="IsDeleted"
  125. minOccurs="0"
  126. default="0"
  127. type="p5Type:integer"
  128. system_cache__appinfo:xpath_local="p5Type:integer"
  129. system_cache__appinfo:restriction_path=""/>
  130. <xs:element system_cache__appinfo:sort="1"
  131. system_cache__appinfo:prefix="default_db"
  132. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  133. id="default_d___d5e5008-1_CarrerId"
  134. name="CarrerId"
  135. minOccurs="0"
  136. nillable="true"
  137. default=""
  138. type="p5Type:integer"
  139. system_cache__appinfo:xpath_local="p5Type:integer"
  140. system_cache__appinfo:restriction_path=""/>
  141. <xs:element system_cache__appinfo:sort="1"
  142. system_cache__appinfo:prefix="default_db"
  143. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  144. id="default_d___d5e5009-1_DateStart"
  145. name="DateStart"
  146. minOccurs="0"
  147. type="p5Type:date"
  148. system_cache__appinfo:xpath_local="p5Type:date"
  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___d5e5010-1_CoordUserI"
  154. name="CoordUserId"
  155. minOccurs="0"
  156. nillable="true"
  157. default=""
  158. type="p5Type:integer"
  159. system_cache__appinfo:xpath_local="p5Type:integer"
  160. system_cache__appinfo:restriction_path=""/>
  161. <xs:element system_cache__appinfo:sort="1"
  162. system_cache__appinfo:prefix="default_db"
  163. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  164. id="default_d___d5e5011-1_ProcessedI"
  165. name="ProcessedId"
  166. minOccurs="0"
  167. nillable="true"
  168. default=""
  169. type="p5Type:integer"
  170. system_cache__appinfo:xpath_local="p5Type:integer"
  171. system_cache__appinfo:restriction_path=""/>
  172. <xs:element system_cache__appinfo:sort="1"
  173. system_cache__appinfo:prefix="default_db"
  174. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  175. id="default_d___d5e5012-1_ProcessedD"
  176. name="ProcessedDateTime"
  177. minOccurs="0"
  178. nillable="true"
  179. default=""
  180. type="p5Type:dateTime"
  181. system_cache__appinfo:xpath_local="p5Type:dateTime"
  182. system_cache__appinfo:restriction_path=""/>
  183. <xs:element system_cache__appinfo:sort="1"
  184. system_cache__appinfo:prefix="default_db"
  185. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  186. id="default_d___d5e5014-1_FamilyId"
  187. name="FamilyId"
  188. minOccurs="0"
  189. nillable="true"
  190. default=""
  191. type="p5Type:integer"
  192. system_cache__appinfo:xpath_local="p5Type:integer"
  193. system_cache__appinfo:restriction_path=""/>
  194. <xs:element system_cache__appinfo:sort="1"
  195. system_cache__appinfo:prefix="default_db"
  196. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  197. id="default_d___d5e5015-1"
  198. ref="default_db__x3A__sys_users:sys_users"
  199. system_cache__appinfo:xpath_local="default_db:sys_users"
  200. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  201. <xs:annotation>
  202. <xs:appinfo>
  203. <system_cache__appinfo:flat_relation_cache>
  204. <system_cache__appinfo:source system_cache__appinfo:name="CoordUserId"
  205. system_cache__appinfo:xpath="default_db__x3A__crm_newcontractrequests__x3A__sys_users:sys_users/UserId"/>
  206. </system_cache__appinfo:flat_relation_cache>
  207. </xs:appinfo>
  208. </xs:annotation>
  209. </xs:element>
  210. <xs:element system_cache__appinfo:sort="1"
  211. system_cache__appinfo:prefix="default_db"
  212. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  213. id="default_d___d5e5019-1"
  214. ref="default_db__x3A__car_carrers:car_carrers"
  215. system_cache__appinfo:xpath_local="default_db:car_carrers"
  216. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  217. <xs:annotation>
  218. <xs:appinfo>
  219. <system_cache__appinfo:flat_relation_cache>
  220. <system_cache__appinfo:source system_cache__appinfo:name="CarrerId"
  221. system_cache__appinfo:xpath="default_db__x3A__crm_newcontractrequests__x3A__car_carrers:car_carrers/CarrerId"/>
  222. </system_cache__appinfo:flat_relation_cache>
  223. </xs:appinfo>
  224. </xs:annotation>
  225. </xs:element>
  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___d5e5023-1"
  230. ref="default_db__x3A__sys_users:sys_users"
  231. system_cache__appinfo:xpath_local="default_db:sys_users"
  232. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  233. <xs:annotation>
  234. <xs:appinfo>
  235. <system_cache__appinfo:flat_relation_cache>
  236. <system_cache__appinfo:source system_cache__appinfo:name="CreatedByUserId"
  237. system_cache__appinfo:xpath="default_db__x3A__crm_newcontractrequests__x3A__sys_users:sys_users/UserId"/>
  238. </system_cache__appinfo:flat_relation_cache>
  239. </xs:appinfo>
  240. </xs:annotation>
  241. </xs:element>
  242. <xs:element system_cache__appinfo:sort="1"
  243. system_cache__appinfo:prefix="default_db"
  244. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  245. id="default_d___d5e5027-1"
  246. ref="default_db__x3A__sys_users:sys_users"
  247. system_cache__appinfo:xpath_local="default_db:sys_users"
  248. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  249. <xs:annotation>
  250. <xs:appinfo>
  251. <system_cache__appinfo:flat_relation_cache>
  252. <system_cache__appinfo:source system_cache__appinfo:name="LastUpdateUserId"
  253. system_cache__appinfo:xpath="default_db__x3A__crm_newcontractrequests__x3A__sys_users:sys_users/UserId"/>
  254. </system_cache__appinfo:flat_relation_cache>
  255. </xs:appinfo>
  256. </xs:annotation>
  257. </xs:element>
  258. </xs:sequence>
  259. </xs:complexType>
  260. <xs:element xmlns:xs="http://www.w3.org/2001/XMLSchema"
  261. name="crm_newcontractrequests"
  262. type="default_db__x3A__crm_newcontractrequests:crm_newcontractrequests"
  263. id="default_d___d5e5031-1_crm_newcon"
  264. system_cache__appinfo:root_element_in_schema="true"
  265. system_cache__appinfo:xpath_local=""
  266. system_cache__appinfo:sort="1"
  267. system_cache__appinfo:prefix="default_db"
  268. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  269. system_cache__appinfo:restriction_path=""><!--#139 to include --></xs:element>
  270. </schema>