crm_addresses.xsd 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317
  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_addresses.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_addresstypes.xsd"
  53. schemaLocation="default_db__x3A__crm_addresstypes.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. <import namespace="https://biuro.biall-net.pl/wfs/default_db/table/crm_voivodeships.xsd"
  57. schemaLocation="default_db__x3A__crm_voivodeships.xsd"/>
  58. <xs:complexType xmlns:xs="http://www.w3.org/2001/XMLSchema"
  59. system_cache__appinfo:restriction_path_TODEL=""
  60. name="crm_addresses"
  61. id="default_d___d5e4178-1_crm_addres"
  62. system_cache__appinfo:sort="0"
  63. system_cache__appinfo:root_element_in_schema="true"
  64. system_cache__appinfo:prefix="default_db"
  65. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"><!--#139 to include -->
  66. <xs:sequence system_cache__appinfo:restriction_path_TODEL=""
  67. id="default_d___d5e4179-1"
  68. system_cache__appinfo:sort="1"
  69. system_cache__appinfo:root_element_in_schema="true"
  70. system_cache__appinfo:prefix="default_db"
  71. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table">
  72. <xs:element system_cache__appinfo:sort="1"
  73. system_cache__appinfo:prefix="default_db"
  74. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  75. id="default_d___d5e4180-1_Id"
  76. name="Id"
  77. minOccurs="0"
  78. type="p5Type:integer"
  79. system_cache__appinfo:xpath_local="p5Type:integer"
  80. system_cache__appinfo:restriction_path=""/>
  81. <xs:element system_cache__appinfo:sort="1"
  82. system_cache__appinfo:prefix="default_db"
  83. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  84. id="default_d___d5e4181-1_CreatedByU"
  85. name="CreatedByUserId"
  86. minOccurs="0"
  87. type="p5Type:integer"
  88. system_cache__appinfo:xpath_local="p5Type:integer"
  89. system_cache__appinfo:restriction_path=""/>
  90. <xs:element system_cache__appinfo:sort="1"
  91. system_cache__appinfo:prefix="default_db"
  92. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  93. id="default_d___d5e4182-1_CreatedDat"
  94. name="CreatedDateTime"
  95. minOccurs="0"
  96. default="CURRENT_TIMESTAMP"
  97. type="p5Type:dateTime"
  98. system_cache__appinfo:xpath_local="p5Type:dateTime"
  99. system_cache__appinfo:restriction_path=""/>
  100. <xs:element system_cache__appinfo:sort="1"
  101. system_cache__appinfo:prefix="default_db"
  102. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  103. id="default_d___d5e4183-1_LastUpdate"
  104. name="LastUpdateUserId"
  105. minOccurs="0"
  106. nillable="true"
  107. default=""
  108. type="p5Type:integer"
  109. system_cache__appinfo:xpath_local="p5Type:integer"
  110. system_cache__appinfo:restriction_path=""/>
  111. <xs:element system_cache__appinfo:sort="1"
  112. system_cache__appinfo:prefix="default_db"
  113. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  114. id="default_d___d5e4184-1_LastUpdate"
  115. name="LastUpdateDateTime"
  116. minOccurs="0"
  117. default="CURRENT_TIMESTAMP"
  118. type="p5Type:integer"
  119. system_cache__appinfo:xpath_local="p5Type:integer"
  120. system_cache__appinfo:restriction_path=""/>
  121. <xs:element system_cache__appinfo:sort="1"
  122. system_cache__appinfo:prefix="default_db"
  123. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  124. id="default_d___d5e4185-1_IsDeleted"
  125. name="IsDeleted"
  126. minOccurs="0"
  127. default="0"
  128. type="p5Type:integer"
  129. system_cache__appinfo:xpath_local="p5Type:integer"
  130. system_cache__appinfo:restriction_path=""/>
  131. <xs:element system_cache__appinfo:sort="1"
  132. system_cache__appinfo:prefix="default_db"
  133. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  134. id="default_d___d5e4186-1_AddressTyp"
  135. name="AddressTypeId"
  136. minOccurs="0"
  137. nillable="true"
  138. default=""
  139. type="p5Type:integer"
  140. system_cache__appinfo:xpath_local="p5Type:integer"
  141. system_cache__appinfo:restriction_path=""/>
  142. <xs:element system_cache__appinfo:sort="1"
  143. system_cache__appinfo:prefix="default_db"
  144. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  145. id="default_d___d5e4187-1_City"
  146. name="City"
  147. minOccurs="0"
  148. nillable="true"
  149. default=""
  150. type="p5Type:string"
  151. system_cache__appinfo:xpath_local="p5Type:string"
  152. system_cache__appinfo:restriction_path=""/>
  153. <xs:element system_cache__appinfo:sort="1"
  154. system_cache__appinfo:prefix="default_db"
  155. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  156. id="default_d___d5e4188-1_Street"
  157. name="Street"
  158. minOccurs="0"
  159. nillable="true"
  160. default=""
  161. type="p5Type:string"
  162. system_cache__appinfo:xpath_local="p5Type:string"
  163. system_cache__appinfo:restriction_path=""/>
  164. <xs:element system_cache__appinfo:sort="1"
  165. system_cache__appinfo:prefix="default_db"
  166. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  167. id="default_d___d5e4189-1_BuildingNu"
  168. name="BuildingNumber"
  169. minOccurs="0"
  170. nillable="true"
  171. default=""
  172. type="p5Type:string"
  173. system_cache__appinfo:xpath_local="p5Type:string"
  174. system_cache__appinfo:restriction_path=""/>
  175. <xs:element system_cache__appinfo:sort="1"
  176. system_cache__appinfo:prefix="default_db"
  177. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  178. id="default_d___d5e4190-1_ApartmentN"
  179. name="ApartmentNumber"
  180. minOccurs="0"
  181. nillable="true"
  182. default=""
  183. type="p5Type:string"
  184. system_cache__appinfo:xpath_local="p5Type:string"
  185. system_cache__appinfo:restriction_path=""/>
  186. <xs:element system_cache__appinfo:sort="1"
  187. system_cache__appinfo:prefix="default_db"
  188. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  189. id="default_d___d5e4192-1_PostCode"
  190. name="PostCode"
  191. minOccurs="0"
  192. nillable="true"
  193. default=""
  194. type="p5Type:string"
  195. system_cache__appinfo:xpath_local="p5Type:string"
  196. system_cache__appinfo:restriction_path=""/>
  197. <xs:element system_cache__appinfo:sort="1"
  198. system_cache__appinfo:prefix="default_db"
  199. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  200. id="default_d___d5e4193-1_PostCity"
  201. name="PostCity"
  202. minOccurs="0"
  203. nillable="true"
  204. default=""
  205. type="p5Type:string"
  206. system_cache__appinfo:xpath_local="p5Type:string"
  207. system_cache__appinfo:restriction_path=""/>
  208. <xs:element system_cache__appinfo:sort="1"
  209. system_cache__appinfo:prefix="default_db"
  210. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  211. id="default_d___d5e4194-1_RegionId"
  212. name="RegionId"
  213. minOccurs="0"
  214. nillable="true"
  215. default=""
  216. type="p5Type:integer"
  217. system_cache__appinfo:xpath_local="p5Type:integer"
  218. system_cache__appinfo:restriction_path=""/>
  219. <xs:element system_cache__appinfo:sort="1"
  220. system_cache__appinfo:prefix="default_db"
  221. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  222. id="default_d___d5e4195-1_Community"
  223. name="Community"
  224. minOccurs="0"
  225. nillable="true"
  226. default=""
  227. type="p5Type:string"
  228. system_cache__appinfo:xpath_local="p5Type:string"
  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___d5e4196-1_County"
  234. name="County"
  235. minOccurs="0"
  236. nillable="true"
  237. default=""
  238. type="p5Type:string"
  239. system_cache__appinfo:xpath_local="p5Type:string"
  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___d5e4197-1"
  245. ref="default_db__x3A__crm_addresstypes:crm_addresstypes"
  246. system_cache__appinfo:xpath_local="default_db:crm_addresstypes"
  247. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  248. <xs:annotation>
  249. <xs:appinfo>
  250. <system_cache__appinfo:flat_relation_cache>
  251. <system_cache__appinfo:source system_cache__appinfo:name="AddressTypeId"
  252. system_cache__appinfo:xpath="default_db__x3A__crm_addresses__x3A__crm_addresstypes:crm_addresstypes/Id"/>
  253. </system_cache__appinfo:flat_relation_cache>
  254. </xs:appinfo>
  255. </xs:annotation>
  256. </xs:element>
  257. <xs:element system_cache__appinfo:sort="1"
  258. system_cache__appinfo:prefix="default_db"
  259. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  260. id="default_d___d5e4201-1"
  261. ref="default_db__x3A__sys_users:sys_users"
  262. system_cache__appinfo:xpath_local="default_db:sys_users"
  263. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  264. <xs:annotation>
  265. <xs:appinfo>
  266. <system_cache__appinfo:flat_relation_cache>
  267. <system_cache__appinfo:source system_cache__appinfo:name="CreatedByUserId"
  268. system_cache__appinfo:xpath="default_db__x3A__crm_addresses__x3A__sys_users:sys_users/UserId"/>
  269. </system_cache__appinfo:flat_relation_cache>
  270. </xs:appinfo>
  271. </xs:annotation>
  272. </xs:element>
  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___d5e4205-1"
  277. ref="default_db__x3A__sys_users:sys_users"
  278. system_cache__appinfo:xpath_local="default_db:sys_users"
  279. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  280. <xs:annotation>
  281. <xs:appinfo>
  282. <system_cache__appinfo:flat_relation_cache>
  283. <system_cache__appinfo:source system_cache__appinfo:name="LastUpdateUserId"
  284. system_cache__appinfo:xpath="default_db__x3A__crm_addresses__x3A__sys_users:sys_users/UserId"/>
  285. </system_cache__appinfo:flat_relation_cache>
  286. </xs:appinfo>
  287. </xs:annotation>
  288. </xs:element>
  289. <xs:element system_cache__appinfo:sort="1"
  290. system_cache__appinfo:prefix="default_db"
  291. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  292. id="default_d___d5e4209-1"
  293. ref="default_db__x3A__crm_voivodeships:crm_voivodeships"
  294. system_cache__appinfo:xpath_local="default_db:crm_voivodeships"
  295. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  296. <xs:annotation>
  297. <xs:appinfo>
  298. <system_cache__appinfo:flat_relation_cache>
  299. <system_cache__appinfo:source system_cache__appinfo:name="RegionId"
  300. system_cache__appinfo:xpath="default_db__x3A__crm_addresses__x3A__crm_voivodeships:crm_voivodeships/Id"/>
  301. </system_cache__appinfo:flat_relation_cache>
  302. </xs:appinfo>
  303. </xs:annotation>
  304. </xs:element>
  305. </xs:sequence>
  306. </xs:complexType>
  307. <xs:element xmlns:xs="http://www.w3.org/2001/XMLSchema"
  308. name="crm_addresses"
  309. type="default_db__x3A__crm_addresses:crm_addresses"
  310. id="default_d___d5e4213-1_crm_addres"
  311. system_cache__appinfo:root_element_in_schema="true"
  312. system_cache__appinfo:xpath_local=""
  313. system_cache__appinfo:sort="1"
  314. system_cache__appinfo:prefix="default_db"
  315. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  316. system_cache__appinfo:restriction_path=""><!--#139 to include --></xs:element>
  317. </schema>