se/SE/schema/table/PROBLEMS.xsd

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
           xmlns:gml="http://www.opengis.net/gml/3.2"
           xmlns:Types__x3A__default_Default="https://biuro.biall-net.pl/wfs/default_db/Types/Default.xsd"
           xmlns:default_db__x3A__IN7_DZIENNIK_KORESP="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
           xmlns:hfp="http://www.w3.org/2001/XMLSchema-hasFacetAndProperty"
           xmlns:default_db__x3A__ADMIN_USERS="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
           xmlns:default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
           xmlns:SystemObjects__x3A__AccessGroup="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessGroup.xsd"
           xmlns:SystemObjects__x3A__AccessOwner="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessOwner.xsd"
           xmlns:default_db__x3A__PROBLEMS="https://biuro.biall-net.pl/wfs/default_db/table/PROBLEMS.xsd"
           xmlns:p5_tr_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"
           xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
           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"
           xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
           targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/PROBLEMS.xsd"
           vc:minVersion="1.1">
   <xs:import namespace="http://www.opengis.net/gml/3.2"
              schemaLocation="../Types/gml.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
              schemaLocation="../table/IN7_DZIENNIK_KORESP.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
              schemaLocation="../table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessGroup.xsd"
              schemaLocation="../SystemObjects/AccessGroup.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessOwner.xsd"
              schemaLocation="../SystemObjects/AccessOwner.xsd"/>
   <xs:simpleType name="A_STATUS_Type" id="A__PROBLEMS___d5e83840-1_A_STATUS_T">
      <xs:restriction base="xs:string">
         <xs:enumeration value="NORMAL"/>
         <xs:enumeration value="WAITING"/>
         <xs:enumeration value="MONITOR"/>
         <xs:enumeration value="DELETED"/>
         <xs:enumeration value="WARNING"/>
         <xs:enumeration value="OFF_SOFT"/>
         <xs:enumeration value="OFF_HARD"/>
      </xs:restriction>
   </xs:simpleType>
   <xs:complexType name="PROBLEMS" id="A__PROBLEMS___d5e83849-1_PROBLEMS">
      <xs:sequence id="A__PROBLEMS___d5e83850-1">
         <xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner"
                     id="A__PROBLEMS___d5e83851-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/login"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
                     id="A__PROBLEMS___d5e83856-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/uid"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
                     id="A__PROBLEMS___d5e83861-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/uid"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element name="ID" type="xs:integer" id="A__PROBLEMS___d5e83866-1_ID"/>
         <xs:element name="PARENT_ID"
                     type="xs:integer"
                     id="A__PROBLEMS___d5e83867-1_PARENT_ID"/>
         <xs:element name="ID_PROJECT"
                     type="xs:integer"
                     id="A__PROBLEMS___d5e83868-1_ID_PROJECT"/>
         <xs:element name="ID_PROJECT_path"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83869-1_ID_PROJECT"/>
         <xs:element name="REMOTE_TABLE"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83870-1_REMOTE_TAB"/>
         <xs:element name="REMOTE_TABLE_ID"
                     type="xs:integer"
                     id="A__PROBLEMS___d5e83871-1_REMOTE_TAB"/>
         <xs:element name="A_RECORD_CREATE_DATE"
                     type="xs:token"
                     id="A__PROBLEMS___d5e83872-1_A_RECORD_C"/>
         <xs:element name="A_RECORD_CREATE_AUTHOR"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83873-1_A_RECORD_C"/>
         <xs:element name="A_RECORD_UPDATE_DATE"
                     type="xs:token"
                     id="A__PROBLEMS___d5e83875-1_A_RECORD_U"/>
         <xs:element name="A_RECORD_UPDATE_AUTHOR"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83876-1_A_RECORD_U"/>
         <xs:element name="L_APPOITMENT_DATE"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83877-1_L_APPOITME"/>
         <xs:element name="L_APPOITMENT_USER"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83878-1_L_APPOITME"/>
         <xs:element name="L_APPOITMENT_PERIOD"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83879-1_L_APPOITME"/>
         <xs:element name="L_APPOITMENT_INFO"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83880-1_L_APPOITME"/>
         <xs:element name="L_APPOITMENT_TYPE"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83881-1_L_APPOITME"/>
         <xs:element name="A_PROBLEM"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83882-1_A_PROBLEM"/>
         <xs:element name="A_PROBLEM_DESC"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83883-1_A_PROBLEM_"/>
         <xs:element name="A_PROBLEM_DESC_HTML"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83884-1_A_PROBLEM_"/>
         <xs:element name="A_PROBLEM_DATE"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83885-1_A_PROBLEM_"/>
         <xs:element name="A_PROBLEM_COMPLETE_PERCENT"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83887-1_A_PROBLEM_"/>
         <xs:element name="A_PROBLEM_COMPLETE_PERCENT_CONFIRMED"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83888-1_A_PROBLEM_"/>
         <xs:element name="A_ADM_COMPANY"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83889-1_A_ADM_COMP"/>
         <xs:element name="T_WORKPOINTS"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83890-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_VALUE"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83891-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_TYPE"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83892-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_USER"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83893-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_DATE"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83894-1_T_WORKPOIN"/>
         <xs:element name="CUSTOMER_ADMIN_USER"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83895-1_CUSTOMER_A"/>
         <xs:element name="CUSTOMER_NOTES"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83896-1_CUSTOMER_N"/>
         <xs:element name="CUSTOMER_ORDERED_HOURS"
                     type="xs:integer"
                     id="A__PROBLEMS___d5e83897-1_CUSTOMER_O"/>
         <xs:element name="CUSTOMER_AGREED_PRICE"
                     type="xs:double"
                     id="A__PROBLEMS___d5e83899-1_CUSTOMER_A"/>
         <xs:element name="T_PENALTIES"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83900-1_T_PENALTIE"/>
         <xs:element name="T_PENALTIES_TYPE"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83901-1_T_PENALTIE"/>
         <xs:element name="T_PENALTIES_VALUE"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83902-1_T_PENALTIE"/>
         <xs:element name="SYNC_SQIX_STATUS"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83903-1_SYNC_SQIX_"/>
         <xs:element name="A_STATUS"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83904-1_A_STATUS"/>
         <xs:element name="A_STATUS_INFO"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83905-1_A_STATUS_I"/>
         <xs:element name="A_CLASSIFIED"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83906-1_A_CLASSIFI"/>
         <xs:element name="ID_BILLING_USERS"
                     type="xs:integer"
                     id="A__PROBLEMS___d5e83907-1_ID_BILLING"/>
         <xs:element name="the_geom"
                     type="xs:string"
                     id="A__PROBLEMS___d5e83908-1_the_geom"/>
      </xs:sequence>
   </xs:complexType>
   <xs:element name="PROBLEMS"
               type="default_db__x3A__PROBLEMS:PROBLEMS"
               id="A__PROBLEMS___d5e83909-1_PROBLEMS"/>
</xs:schema>