SERVICES.xsd 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:gml="http://www.opengis.net/gml/3.2"
  3. xmlns:Types__x3A__default_Default="https://biuro.biall-net.pl/wfs/default_db/Types/Default.xsd"
  4. xmlns:default_db__x3A__IN7_DZIENNIK_KORESP="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
  5. xmlns:hfp="http://www.w3.org/2001/XMLSchema-hasFacetAndProperty"
  6. xmlns:default_db__x3A__ADMIN_USERS="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
  7. xmlns:default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
  8. xmlns:SystemObjects__x3A__AccessGroup="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessGroup.xsd"
  9. xmlns:SystemObjects__x3A__AccessOwner="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessOwner.xsd"
  10. xmlns:default_db__x3A__SERVICES="https://biuro.biall-net.pl/wfs/default_db/table/SERVICES.xsd"
  11. xmlns:p5_tr_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"
  12. xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
  13. xmlns:system_cache__resources_tree_generate_xsl_required_occurs_raport="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/resources_tree_generate_xsl_require_occurs_raport"
  14. xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
  15. xmlns:fix_se_defaultdb_schema="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/fix_se_defaultdb_schema/fix_se_defaultdb_schema.xsd"
  16. xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types"
  17. targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/SERVICES.xsd"
  18. vc:minVersion="1.1"
  19. xmlns:default_db__x3A__BILLING_NUMBERS_TYPE="https://biuro.biall-net.pl/wfs/default_db/table/BILLING_NUMBERS_TYPE.xsd"
  20. xmlns:default_db__x3A__DEALS_TABLE="https://biuro.biall-net.pl/wfs/default_db/table/DEALS_TABLE.xsd">
  21. <xs:import namespace="http://biuro.biall-net.pl/p5/schema/types"
  22. schemaLocation="../../../types.xsd"/>
  23. <xs:import namespace="http://www.opengis.net/gml/3.2"
  24. schemaLocation="http://www.opengis.net/gml/3.2"/>
  25. <!---->
  26. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
  27. schemaLocation="../../default_db.IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP.xsd"/>
  28. <xs:import
  29. namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
  30. schemaLocation="../../default_db.IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI.xsd"/>
  31. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/BILLING_NUMBERS_TYPE.xsd"
  32. schemaLocation="../../default_db.BILLING_NUMBERS_TYPE/BILLING_NUMBERS_TYPE/BILLING_NUMBERS_TYPE.xsd"/>
  33. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/DEALS_TABLE.xsd"
  34. schemaLocation="../../default_db.DEALS_TABLE/DEALS_TABLE/DEALS_TABLE.xsd"/>
  35. <xs:simpleType name="A_STATUS_Type" id="A__SERVICES___d5e84557-1_A_STATUS_T">
  36. <xs:restriction base="xs:string">
  37. <xs:enumeration value="NORMAL"/>
  38. <xs:enumeration value="WAITING"/>
  39. <xs:enumeration value="MONITOR"/>
  40. <xs:enumeration value="DELETED"/>
  41. <xs:enumeration value="WARNING"/>
  42. <xs:enumeration value="OFF_SOFT"/>
  43. <xs:enumeration value="OFF_HARD"/>
  44. </xs:restriction>
  45. </xs:simpleType>
  46. <xs:complexType name="SERVICES" id="A__SERVICES___d5e84566-1_SERVICES">
  47. <xs:annotation>
  48. <xs:appinfo>
  49. <system_cache__appinfo:heritage>
  50. <system_cache__appinfo:inherit system_cache__appinfo:inherit_ref="default_db:SERVICES" system_cache__appinfo:heritage_acl="true">
  51. <system_cache__appinfo:acl_rule_inherit_to_all_same_name_elements_and_refs/>
  52. <acl_rule_inherit_to_all_refs_by_primary/>
  53. <acl_rule_inherit_to_all_refs_by_local_element system_cache__appinfo:acl_rule_inherit_local_element_name="A_STATUS"/>
  54. </system_cache__appinfo:inherit>
  55. <system_cache__appinfo:exherit_all system_cache__appinfo:heritage_acl="true" system_cache__appinfo:heritage_sort="true"/>
  56. </system_cache__appinfo:heritage>
  57. </xs:appinfo>
  58. </xs:annotation>
  59. <xs:sequence id="A__SERVICES___d5e84567-1">
  60. <xs:element name="ID" type="xs:integer" id="A__SERVICES___d5e84583-1_ID"/>
  61. <xs:element name="ID_BILLING_USERS" type="xs:integer"
  62. id="A__SERVICES___d5e84584-1_ID_BILLING"/>
  63. <xs:element name="NAME_LIST_SERVICES" type="xs:string"
  64. id="A__SERVICES___d5e84585-1_NAME_LIST_"/>
  65. <xs:element name="A_STATUS" type="xs:string" id="A__SERVICES___d5e84586-1_A_STATUS"/>
  66. <xs:element name="active" type="xs:string" id="A__SERVICES___d5e84587-1_active"/>
  67. <xs:element name="TAB_UPDATE_STAT" type="xs:string"
  68. id="A__SERVICES___d5e84588-1_TAB_UPDATE"/>
  69. <xs:element name="TAB_UPDATE_DATE" type="xs:token" id="A__SERVICES___d5e84589-1_TAB_UPDATE"/>
  70. <xs:element name="TAB_UPDATE_INFO" type="xs:string"
  71. id="A__SERVICES___d5e84590-1_TAB_UPDATE"/>
  72. <xs:element name="SERVICE_TYPE" type="xs:string" id="A__SERVICES___d5e84592-1_SERVICE_TY"/>
  73. <xs:element name="ID_BILLING_NUMBERS_TYPE" type="xs:integer"
  74. id="A__SERVICES___d5e84593-1_ID_BILLING"/>
  75. <xs:element ref="default_db__x3A__BILLING_NUMBERS_TYPE:BILLING_NUMBERS_TYPE">
  76. <xs:annotation>
  77. <xs:appinfo>
  78. <system_cache__appinfo:flat_relation_cache>
  79. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ID_BILLING_NUMBERS_TYPE" system_cache__appinfo:xpath="default_db__x3A__BILLING_NUMBERS_TYPE:BILLING_NUMBERS_TYPE/ID"/>
  80. </system_cache__appinfo:flat_relation_cache>
  81. </xs:appinfo>
  82. </xs:annotation>
  83. </xs:element>
  84. <xs:element name="ABONAMENT_PERIOD" type="xs:integer"
  85. id="A__SERVICES___d5e84594-1_ABONAMENT_"/>
  86. <xs:element name="ABONAMENT_VALUE" type="xs:double"
  87. id="A__SERVICES___d5e84595-1_ABONAMENT_"/>
  88. <xs:element name="VAT" type="xs:double" id="A__SERVICES___d5e84596-1_VAT"/>
  89. <xs:element name="ID_CURRENCY" type="xs:integer" id="A__SERVICES___d5e84597-1_ID_CURRENC"/>
  90. <xs:element name="ABONAMENT_PAYMENT" type="xs:string"
  91. id="A__SERVICES___d5e84598-1_ABONAMENT_"/>
  92. <xs:element name="ABONAMENT_START" type="xs:integer"
  93. id="A__SERVICES___d5e84599-1_ABONAMENT_"/>
  94. <xs:element name="MINIMUM_BILLING_VALUE" type="xs:double"
  95. id="A__SERVICES___d5e84600-1_MINIMUM_BI"/>
  96. <xs:element name="BILLED_TILL" type="xs:token" id="A__SERVICES___d5e84601-1_BILLED_TIL"/>
  97. <xs:element name="HANGUP_FROM" type="xs:token" id="A__SERVICES___d5e84602-1_HANGUP_FRO"/>
  98. <xs:element name="HANGUP_TILL" type="xs:token" id="A__SERVICES___d5e84604-1_HANGUP_TIL"/>
  99. <xs:element name="HANGUP_STATUS" type="xs:string" id="A__SERVICES___d5e84605-1_HANGUP_STA"/>
  100. <xs:element name="HANGUP_RATIO" type="xs:double" id="A__SERVICES___d5e84606-1_HANGUP_RAT"/>
  101. <xs:element name="TIMESTAMP" type="xs:string" id="A__SERVICES___d5e84607-1_TIMESTAMP"/>
  102. <xs:element name="P_ID_SERVICES" type="xs:integer" id="A__SERVICES___d5e84608-1_P_ID_SERVI"/>
  103. <xs:element ref="default_db__x3A__SERVICES:SERVICES">
  104. <xs:annotation>
  105. <xs:appinfo>
  106. <system_cache__appinfo:flat_relation_cache>
  107. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="P_ID_SERVICES" system_cache__appinfo:xpath="default_db__x3A__SERVICES:SERVICES/ID"/>
  108. </system_cache__appinfo:flat_relation_cache>
  109. </xs:appinfo>
  110. </xs:annotation>
  111. </xs:element>
  112. <xs:element name="uwagi" type="xs:string" id="A__SERVICES___d5e84609-1_uwagi"/>
  113. <xs:element name="ID_DEALS_TABLE" type="xs:integer"
  114. id="A__SERVICES___d5e84610-1_ID_DEALS_T"/>
  115. <xs:element ref="default_db__x3A__DEALS_TABLE:DEALS_TABLE">
  116. <xs:annotation>
  117. <xs:appinfo>
  118. <system_cache__appinfo:flat_relation_cache>
  119. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ID_DEALS_TABLE" system_cache__appinfo:xpath="default_db__x3A__DEALS_TABLE:DEALS_TABLE/ID"/>
  120. </system_cache__appinfo:flat_relation_cache>
  121. </xs:appinfo>
  122. </xs:annotation>
  123. </xs:element>
  124. <xs:element name="VAT_NAME" type="xs:string" id="A__SERVICES___d5e84611-1_VAT_NAME"/>
  125. <xs:element name="id_list_sww" type="xs:integer" id="A__SERVICES___d5e84612-1_id_list_sw"/>
  126. <xs:element name="SERV_ID_BILLING_PREFIXES" type="xs:integer"
  127. id="A__SERVICES___d5e84613-1_SERV_ID_BI"/>
  128. <xs:element name="ID_OFFERS" type="xs:integer" id="A__SERVICES___d5e84614-1_ID_OFFERS"/>
  129. <xs:element name="A_RECORD_CREATE_DATE" type="xs:string"
  130. id="A__SERVICES___d5e84616-1_A_RECORD_C"/>
  131. <xs:element name="A_RECORD_CREATE_AUTHOR" type="xs:string"
  132. id="A__SERVICES___d5e84617-1_A_RECORD_C"/>
  133. <xs:element name="A_RECORD_UPDATE_DATE" type="xs:string"
  134. id="A__SERVICES___d5e84618-1_A_RECORD_U"/>
  135. <xs:element name="A_RECORD_UPDATE_AUTHOR" type="xs:string"
  136. id="A__SERVICES___d5e84619-1_A_RECORD_U"/>
  137. <xs:element name="P_SERVICE_ORDERED_INSTALL_DATE_1297" type="xs:token"
  138. id="A__SERVICES___d5e84620-1_P_SERVICE_"/>
  139. <xs:element name="A_ADM_COMPANY" type="xs:string" id="A__SERVICES___d5e84621-1_A_ADM_COMP"/>
  140. <xs:element name="L_APPOITMENT_DATE" type="xs:string"
  141. id="A__SERVICES___d5e84622-1_L_APPOITME"/>
  142. <xs:element name="L_APPOITMENT_USER" type="xs:string"
  143. id="A__SERVICES___d5e84623-1_L_APPOITME"/>
  144. <xs:element name="L_APPOITMENT_PERIOD" type="xs:string"
  145. id="A__SERVICES___d5e84624-1_L_APPOITME"/>
  146. <xs:element name="L_APPOITMENT_INFO" type="xs:string"
  147. id="A__SERVICES___d5e84625-1_L_APPOITME"/>
  148. <xs:element name="L_APPOITMENT_TYPE" type="xs:string"
  149. id="A__SERVICES___d5e84626-1_L_APPOITME"/>
  150. <xs:element name="A_PROBLEM" type="xs:string" id="A__SERVICES___d5e84628-1_A_PROBLEM"/>
  151. <xs:element name="A_PROBLEM_DESC" type="xs:string" id="A__SERVICES___d5e84629-1_A_PROBLEM_"/>
  152. <xs:element name="A_PROBLEM_DATE" type="xs:string" id="A__SERVICES___d5e84630-1_A_PROBLEM_"/>
  153. <xs:element name="A_STATUS_INFO" type="xs:string" id="A__SERVICES___d5e84631-1_A_STATUS_I"/>
  154. <xs:element name="T_WORKPOINTS" type="xs:string" id="A__SERVICES___d5e84632-1_T_WORKPOIN"/>
  155. <xs:element name="T_WORKPOINTS_VALUE" type="xs:string"
  156. id="A__SERVICES___d5e84633-1_T_WORKPOIN"/>
  157. <xs:element name="T_WORKPOINTS_TYPE" type="xs:string"
  158. id="A__SERVICES___d5e84634-1_T_WORKPOIN"/>
  159. <xs:element name="T_WORKPOINTS_USER" type="xs:string"
  160. id="A__SERVICES___d5e84635-1_T_WORKPOIN"/>
  161. <xs:element name="T_WORKPOINTS_DATE" type="xs:string"
  162. id="A__SERVICES___d5e84636-1_T_WORKPOIN"/>
  163. <xs:element name="P_ACCOUNT" type="xs:string" id="A__SERVICES___d5e84637-1_P_ACCOUNT"/>
  164. <xs:element name="A_CLASSIFIED" type="xs:string" id="A__SERVICES___d5e84638-1_A_CLASSIFI"/>
  165. <xs:element name="S_ADDRESS_STREET" type="xs:string"
  166. id="A__SERVICES___d5e84640-1_S_ADDRESS_"/>
  167. <xs:element name="OLD_ID_SERVICES" type="xs:integer"
  168. id="A__SERVICES___d5e84641-1_OLD_ID_SER"/>
  169. </xs:sequence>
  170. </xs:complexType>
  171. <xs:element name="SERVICES" type="default_db__x3A__SERVICES:SERVICES"
  172. id="A__SERVICES___d5e84642-1_SERVICES"/>
  173. </xs:schema>