se/SE/schema/table/COMPANIES.xsd

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
           xmlns:default_db__x3A__COMPANIES="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
           xmlns:gml="http://www.opengis.net/gml/3.2"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           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"
           xmlns:p5opr="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/object_parent_relations/object_parent_relations.xsd"
           xmlns:p5_simpleSchema_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_simpleSchema_map.xsd"
           elementFormDefault="qualified"
           targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
           vc:minVersion="1.1">
   <xs:import namespace="http://www.opengis.net/gml/3.2"
              schemaLocation="../Types/gml.xsd"/>
   <xs:complexType name="COMPANIES" id="__COMPANIES___d5e7424-1_COMPANIES">
      <xs:annotation>
         <xs:documentation>TODO do rozbudowy, obiekt konatku dla firmy lub kowalskiego, trzeba
            dobrze zamodelowac </xs:documentation>
         <xs:appinfo>
            <system_cache__appinfo:heritage>
               <system_cache__appinfo:inherit system_cache__appinfo:inherit_ref="default_db:COMPANIES"
                                              system_cache__appinfo:heritage_acl="true">
                  <system_cache__appinfo:acl_rule_inherit_to_all_same_name_elements_and_refs/>
                  <acl_rule_inherit_to_all_refs_by_primary/>
                  <acl_rule_inherit_to_all_refs_by_local_element system_cache__appinfo:acl_rule_inherit_local_element_name="P_NAME"/>
               </system_cache__appinfo:inherit>
               <system_cache__appinfo:exherit_all system_cache__appinfo:heritage_acl="true"
                                                  system_cache__appinfo:heritage_sort="true"/>
            </system_cache__appinfo:heritage>
         </xs:appinfo>
      </xs:annotation>
      <xs:sequence id="__COMPANIES___d5e7428-1">
         <xs:element name="ID" type="xs:int" id="__COMPANIES___d5e7429-1_ID"/>
         <xs:element maxOccurs="1"
                     minOccurs="0"
                     name="P_NAME"
                     id="__COMPANIES___d5e7430-1_P_NAME">
            <xs:simpleType id="__COMPANIES___d5e7431-1">
               <xs:restriction base="xs:string">
                  <xs:maxLength value="100"/>
               </xs:restriction>
            </xs:simpleType>
         </xs:element>
         <xs:element maxOccurs="1"
                     minOccurs="0"
                     name="P_NAME_SECOND"
                     id="__COMPANIES___d5e7434-1_P_NAME_SEC">
            <xs:simpleType id="__COMPANIES___d5e7435-1">
               <xs:restriction base="xs:string">
                  <xs:maxLength value="255"/>
               </xs:restriction>
            </xs:simpleType>
         </xs:element>
         <xs:element maxOccurs="1"
                     minOccurs="0"
                     name="P_NIP"
                     id="__COMPANIES___d5e7438-1_P_NIP">
            <xs:simpleType id="__COMPANIES___d5e7439-1">
               <xs:restriction base="xs:string">
                  <xs:maxLength value="100"/>
               </xs:restriction>
            </xs:simpleType>
         </xs:element>
         <xs:element maxOccurs="1"
                     minOccurs="0"
                     name="P_OTHER_DOC"
                     id="__COMPANIES___d5e7442-1_P_OTHER_DO">
            <xs:simpleType id="__COMPANIES___d5e7443-1">
               <xs:restriction base="xs:string">
                  <xs:maxLength value="40"/>
               </xs:restriction>
            </xs:simpleType>
         </xs:element>
         <xs:element maxOccurs="1"
                     minOccurs="0"
                     name="P_PHONE"
                     id="__COMPANIES___d5e7446-1_P_PHONE">
            <xs:simpleType id="__COMPANIES___d5e7447-1">
               <xs:restriction base="xs:string">
                  <xs:maxLength value="100"/>
               </xs:restriction>
            </xs:simpleType>
         </xs:element>
         <xs:element maxOccurs="1"
                     minOccurs="0"
                     name="P_PHONE_SMS"
                     id="__COMPANIES___d5e7450-1_P_PHONE_SM">
            <xs:simpleType id="__COMPANIES___d5e7451-1">
               <xs:restriction base="xs:string">
                  <xs:maxLength value="100"/>
               </xs:restriction>
            </xs:simpleType>
         </xs:element>
         <xs:element maxOccurs="1"
                     minOccurs="0"
                     name="P_FAX"
                     id="__COMPANIES___d5e7454-1_P_FAX">
            <xs:simpleType id="__COMPANIES___d5e7455-1">
               <xs:restriction base="xs:string">
                  <xs:maxLength value="100"/>
               </xs:restriction>
            </xs:simpleType>
         </xs:element>
         <xs:element maxOccurs="1"
                     minOccurs="0"
                     name="P_CONTACT_PERSON"
                     id="__COMPANIES___d5e7458-1_P_CONTACT_">
            <xs:simpleType id="__COMPANIES___d5e7459-1">
               <xs:restriction base="xs:string"/>
            </xs:simpleType>
         </xs:element>
      </xs:sequence>
      <xs:attribute name="label" type="xs:string" id="__COMPANIES___d15e3104-1_label"/>
      <xs:assert test="@label = concat(P_NAME, ' ', P_NAME_SECOND)"
                 id="__COMPANIES___d15e3105-1"/>
   </xs:complexType>
   <xs:element name="COMPANIES"
               type="default_db__x3A__COMPANIES:COMPANIES"
               id="__COMPANIES___d5e7461-1_COMPANIES">
      <xs:key name="COMPANIES">
         <xs:selector xpath="."/>
         <xs:field xpath="P_NAME"/>
         <xs:field xpath="P_NAME_SECOND"/>
      </xs:key>
   </xs:element>
   <xs:element name="ID_BILLING_USERS"
               id="__COMPANIES___d5e7466-1_ID_BILLING"
               type="default_db__x3A__COMPANIES:COMPANIES">
      <xs:key name="ID_BILLING_USERS">
         <xs:selector xpath="."/>
         <xs:field xpath="P_NAME"/>
         <xs:field xpath="P_NAME_SECOND"/>
      </xs:key>
   </xs:element>
   <xs:element name="KONTRAHENT"
               type="default_db__x3A__COMPANIES:COMPANIES"
               id="__COMPANIES___d5e7475-1_KONTRAHENT">
      <xs:key name="KONTRAHENT">
         <xs:selector xpath="."/>
         <xs:field xpath="P_NAME"/>
         <xs:field xpath="P_NAME_SECOND"/>
      </xs:key>
   </xs:element>
</xs:schema>