se/SE/schema/table/USERS2_DEALS.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__USERS2_DEALS="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_DEALS.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/USERS2_DEALS.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="SERS2_DEALS___d5e89248-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="USERS2_DEALS" id="SERS2_DEALS___d5e89257-1_USERS2_DEA">
      <xs:sequence id="SERS2_DEALS___d5e89258-1">
         <xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner"
                     id="SERS2_DEALS___d5e89259-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="SERS2_DEALS___d5e89264-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="SERS2_DEALS___d5e89269-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="SERS2_DEALS___d5e89274-1_ID"/>
         <xs:element name="P_ID" type="xs:integer" id="SERS2_DEALS___d5e89275-1_P_ID"/>
         <xs:element name="M_DIST_FILES"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89276-1_M_DIST_FIL"/>
         <xs:element name="A_RECORD_CREATE_DATE"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89277-1_A_RECORD_C"/>
         <xs:element name="A_RECORD_CREATE_AUTHOR"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89278-1_A_RECORD_C"/>
         <xs:element name="A_RECORD_UPDATE_DATE"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89279-1_A_RECORD_U"/>
         <xs:element name="A_RECORD_UPDATE_AUTHOR"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89280-1_A_RECORD_U"/>
         <xs:element name="TAB_UPDATE_STAT"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89281-1_TAB_UPDATE"/>
         <xs:element name="TAB_UPDATE_DATE"
                     type="xs:token"
                     id="SERS2_DEALS___d5e89283-1_TAB_UPDATE"/>
         <xs:element name="TAB_UPDATE_INFO"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89284-1_TAB_UPDATE"/>
         <xs:element name="L_APPOITMENT_DATE"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89285-1_L_APPOITME"/>
         <xs:element name="L_APPOITMENT_USER"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89286-1_L_APPOITME"/>
         <xs:element name="L_APPOITMENT_PERIOD"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89287-1_L_APPOITME"/>
         <xs:element name="L_APPOITMENT_INFO"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89288-1_L_APPOITME"/>
         <xs:element name="L_APPOITMENT_TYPE"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89289-1_L_APPOITME"/>
         <xs:element name="A_PROBLEM"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89290-1_A_PROBLEM"/>
         <xs:element name="A_PROBLEM_DESC"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89291-1_A_PROBLEM_"/>
         <xs:element name="A_PROBLEM_DATE"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89292-1_A_PROBLEM_"/>
         <xs:element name="A_STATUS"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89293-1_A_STATUS"/>
         <xs:element name="A_STATUS_CURRENT"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89295-1_A_STATUS_C"/>
         <xs:element name="A_STATUS_INFO"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89296-1_A_STATUS_I"/>
         <xs:element name="A_STATUS_LASTCHANGE_DATE"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89297-1_A_STATUS_L"/>
         <xs:element name="A_UPDATE_DATE"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89298-1_A_UPDATE_D"/>
         <xs:element name="A_ADM_COMPANY"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89299-1_A_ADM_COMP"/>
         <xs:element name="DATA_DOK"
                     type="xs:token"
                     id="SERS2_DEALS___d5e89300-1_DATA_DOK"/>
         <xs:element name="S_ALIAS"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89301-1_S_ALIAS"/>
         <xs:element name="S_ADDRESS_CITY"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89302-1_S_ADDRESS_"/>
         <xs:element name="S_ADDRESS_STREET"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89303-1_S_ADDRESS_"/>
         <xs:element name="S_OTHER_INFO"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89304-1_S_OTHER_IN"/>
         <xs:element name="T_WORKPOINTS"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89305-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_PROCES"
                     type="xs:integer"
                     id="SERS2_DEALS___d5e89307-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_VALUE"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89308-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_TYPE"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89309-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_USER"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89310-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_DATE"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89311-1_T_WORKPOIN"/>
         <xs:element name="T_PENALTIES"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89312-1_T_PENALTIE"/>
         <xs:element name="T_PENALTIES_TYPE"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89313-1_T_PENALTIE"/>
         <xs:element name="T_PENALTIES_VALUE"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89314-1_T_PENALTIE"/>
         <xs:element name="ID_BILLING_USERS_OLD"
                     type="xs:integer"
                     id="SERS2_DEALS___d5e89315-1_ID_BILLING"/>
         <xs:element name="ID_BILLING_USERS_NEW"
                     type="xs:integer"
                     id="SERS2_DEALS___d5e89316-1_ID_BILLING"/>
         <xs:element name="ID_SERVICES_OLD"
                     type="xs:integer"
                     id="SERS2_DEALS___d5e89317-1_ID_SERVICE"/>
         <xs:element name="ID_SERVICES_NEW"
                     type="xs:integer"
                     id="SERS2_DEALS___d5e89319-1_ID_SERVICE"/>
         <xs:element name="P_SERVICE"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89320-1_P_SERVICE"/>
         <xs:element name="P_SERVICE_COMPANY"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89321-1_P_SERVICE_"/>
         <xs:element name="P_SERVICE_NAME"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89322-1_P_SERVICE_"/>
         <xs:element name="P_OFFER_ID_OLD"
                     type="xs:integer"
                     id="SERS2_DEALS___d5e89323-1_P_OFFER_ID"/>
         <xs:element name="P_OFFER_ID_NEW"
                     type="xs:integer"
                     id="SERS2_DEALS___d5e89324-1_P_OFFER_ID"/>
         <xs:element name="P_DEAL_DATE_OLD"
                     type="xs:token"
                     id="SERS2_DEALS___d5e89325-1_P_DEAL_DAT"/>
         <xs:element name="P_DEAL_DATE_NEW"
                     type="xs:token"
                     id="SERS2_DEALS___d5e89326-1_P_DEAL_DAT"/>
         <xs:element name="P_DEALNUMBER_OLD"
                     type="xs:integer"
                     id="SERS2_DEALS___d5e89327-1_P_DEALNUMB"/>
         <xs:element name="P_DEALNUMBER_NEW"
                     type="xs:integer"
                     id="SERS2_DEALS___d5e89328-1_P_DEALNUMB"/>
         <xs:element name="P_DEALTERM_OLD"
                     type="xs:token"
                     id="SERS2_DEALS___d5e89329-1_P_DEALTERM"/>
         <xs:element name="P_DEALTERM_NEW"
                     type="xs:token"
                     id="SERS2_DEALS___d5e89331-1_P_DEALTERM"/>
         <xs:element name="OLD_L2_HANGUP_STATUS"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89332-1_OLD_L2_HAN"/>
         <xs:element name="NEW_L2_HANGUP_STATUS"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89333-1_NEW_L2_HAN"/>
         <xs:element name="OLD_L2_HANGUP_FROM"
                     type="xs:token"
                     id="SERS2_DEALS___d5e89334-1_OLD_L2_HAN"/>
         <xs:element name="NEW_L2_HANGUP_FROM"
                     type="xs:token"
                     id="SERS2_DEALS___d5e89335-1_NEW_L2_HAN"/>
         <xs:element name="MONTH_COST_OLD"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89336-1_MONTH_COST"/>
         <xs:element name="MONTH_COST_NEW"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89337-1_MONTH_COST"/>
         <xs:element name="INICJALY_HANDLOWCA"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89338-1_INICJALY_H"/>
         <xs:element name="RODZAJ_DZIALANIA_HANDLOWEGO"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89339-1_RODZAJ_DZI"/>
         <xs:element name="P_ACCOUNT"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89340-1_P_ACCOUNT"/>
         <xs:element name="A_CLASSIFIED"
                     type="xs:string"
                     id="SERS2_DEALS___d5e89341-1_A_CLASSIFI"/>
      </xs:sequence>
   </xs:complexType>
   <xs:element name="USERS2_DEALS"
               type="default_db__x3A__USERS2_DEALS:USERS2_DEALS"
               id="SERS2_DEALS___d5e89342-1_USERS2_DEA"/>
</xs:schema>