se/SE/schema/table/CRM_TESTY.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__CRM_TESTY="https://biuro.biall-net.pl/wfs/default_db/table/CRM_TESTY.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/CRM_TESTY.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="__CRM_TESTY___d5e78184-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="CRM_TESTY" id="__CRM_TESTY___d5e78193-1_CRM_TESTY">
      <xs:sequence id="__CRM_TESTY___d5e78194-1">
         <xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner"
                     id="__CRM_TESTY___d5e78195-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="__CRM_TESTY___d5e78200-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="__CRM_TESTY___d5e78205-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="__CRM_TESTY___d5e78210-1_ID"/>
         <xs:element name="ID_TESTER"
                     type="xs:integer"
                     id="__CRM_TESTY___d5e78211-1_ID_TESTER"/>
         <xs:element name="ID_PROCES_INIT"
                     type="xs:integer"
                     id="__CRM_TESTY___d5e78212-1_ID_PROCES_"/>
         <xs:element name="ID_STANOWISKO"
                     type="xs:integer"
                     id="__CRM_TESTY___d5e78213-1_ID_STANOWI"/>
         <xs:element name="TEST_INIT"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78214-1_TEST_INIT"/>
         <xs:element name="TEST_START"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78215-1_TEST_START"/>
         <xs:element name="TEST_END"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78216-1_TEST_END"/>
         <xs:element name="UWAGI" type="xs:string" id="__CRM_TESTY___d5e78217-1_UWAGI"/>
         <xs:element name="OCENA" type="xs:double" id="__CRM_TESTY___d5e78219-1_OCENA"/>
         <xs:element name="COST" type="xs:double" id="__CRM_TESTY___d5e78220-1_COST"/>
         <xs:element name="DISCOUNT"
                     type="xs:double"
                     id="__CRM_TESTY___d5e78221-1_DISCOUNT"/>
         <xs:element name="ID_ORGANIZER"
                     type="xs:integer"
                     id="__CRM_TESTY___d5e78222-1_ID_ORGANIZ"/>
         <xs:element name="TEST_PLACE"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78223-1_TEST_PLACE"/>
         <xs:element name="A_STATUS"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78224-1_A_STATUS"/>
         <xs:element name="ADM_AREA"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78225-1_ADM_AREA"/>
         <xs:element name="A_RECORD_CREATE_AUTHOR"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78226-1_A_RECORD_C"/>
         <xs:element name="A_RECORD_CREATE_DATE"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78227-1_A_RECORD_C"/>
         <xs:element name="A_RECORD_UPDATE_AUTHOR"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78228-1_A_RECORD_U"/>
         <xs:element name="A_RECORD_UPDATE_DATE"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78229-1_A_RECORD_U"/>
         <xs:element name="TEST_TYPE"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78231-1_TEST_TYPE"/>
         <xs:element name="TEST_ONLYUPDATE"
                     type="xs:integer"
                     id="__CRM_TESTY___d5e78232-1_TEST_ONLYU"/>
         <xs:element name="L_APPOITMENT_DATE"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78233-1_L_APPOITME"/>
         <xs:element name="L_APPOITMENT_USER"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78234-1_L_APPOITME"/>
         <xs:element name="L_APPOITMENT_PERIOD"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78235-1_L_APPOITME"/>
         <xs:element name="L_APPOITMENT_INFO"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78236-1_L_APPOITME"/>
         <xs:element name="L_APPOITMENT_TYPE"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78237-1_L_APPOITME"/>
         <xs:element name="A_PROBLEM"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78238-1_A_PROBLEM"/>
         <xs:element name="A_PROBLEM_DESC"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78239-1_A_PROBLEM_"/>
         <xs:element name="A_PROBLEM_DATE"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78240-1_A_PROBLEM_"/>
         <xs:element name="A_STATUS_INFO"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78241-1_A_STATUS_I"/>
         <xs:element name="A_ADM_COMPANY"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78243-1_A_ADM_COMP"/>
         <xs:element name="T_WORKPOINTS"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78244-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_VALUE"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78245-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_TYPE"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78246-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_USER"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78247-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_DATE"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78248-1_T_WORKPOIN"/>
         <xs:element name="P_ACCOUNT"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78249-1_P_ACCOUNT"/>
         <xs:element name="SHOW_IN_CERT"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78250-1_SHOW_IN_CE"/>
         <xs:element name="SYNC_SQIX_STATUS"
                     type="xs:string"
                     id="__CRM_TESTY___d5e78251-1_SYNC_SQIX_"/>
         <xs:element name="ID_TEST_TO_FIX"
                     type="xs:integer"
                     id="__CRM_TESTY___d5e78252-1_ID_TEST_TO"/>
      </xs:sequence>
   </xs:complexType>
   <xs:element name="CRM_TESTY"
               type="default_db__x3A__CRM_TESTY:CRM_TESTY"
               id="__CRM_TESTY___d5e78253-1_CRM_TESTY"/>
</xs:schema>