project-bravecare/schema/ant-object/default_db.crm_companies/crm_companies/crm_companies.xsd

<?xml version="1.0" encoding="UTF-8"?>
<schema xmlns="http://www.w3.org/2001/XMLSchema"
        xmlns:default_db__x3A__sys_users="https://biuro.biall-net.pl/wfs/default_db/table/sys_users.xsd"
        xmlns:default_db__x3A__crm_educationlevels="https://biuro.biall-net.pl/wfs/default_db/table/crm_educationlevels.xsd"
        xmlns:default_db__x3A__crm_genders="https://biuro.biall-net.pl/wfs/default_db/table/crm_genders.xsd"
        xmlns:default_db__x3A__crm_languagelevels="https://biuro.biall-net.pl/wfs/default_db/table/crm_languagelevels.xsd"
        xmlns:default_db__x3A__crm_carrerstatuses="https://biuro.biall-net.pl/wfs/default_db/table/crm_carrerstatuses.xsd"
        xmlns:default_db__x3A__crm_addresstypes="https://biuro.biall-net.pl/wfs/default_db/table/crm_addresstypes.xsd"
        xmlns:default_db__x3A__crm_voivodeships="https://biuro.biall-net.pl/wfs/default_db/table/crm_voivodeships.xsd"
        xmlns:default_db__x3A__crm_addresses="https://biuro.biall-net.pl/wfs/default_db/table/crm_addresses.xsd"
        xmlns:default_db__x3A__crm_families="https://biuro.biall-net.pl/wfs/default_db/table/crm_families.xsd"
        xmlns:default_db__x3A__crm_transportcompanies="https://biuro.biall-net.pl/wfs/default_db/table/crm_transportcompanies.xsd"
        xmlns:default_db__x3A__car_carrers="https://biuro.biall-net.pl/wfs/default_db/table/car_carrers.xsd"
        xmlns:default_db__x3A__crm_currencys="https://biuro.biall-net.pl/wfs/default_db/table/crm_currencys.xsd"
        xmlns:default_db__x3A__crm_notes="https://biuro.biall-net.pl/wfs/default_db/table/crm_notes.xsd"
        xmlns:default_db__x3A__crm_contracts="https://biuro.biall-net.pl/wfs/default_db/table/crm_contracts.xsd"
        xmlns:default_db__x3A__crm_contracttermtypes="https://biuro.biall-net.pl/wfs/default_db/table/crm_contracttermtypes.xsd"
        xmlns:default_db__x3A__crm_orderstatuses="https://biuro.biall-net.pl/wfs/default_db/table/crm_orderstatuses.xsd"
        xmlns:default_db__x3A__crm_doctemplatecategories="https://biuro.biall-net.pl/wfs/default_db/table/crm_doctemplatecategories.xsd"
        xmlns:default_db__x3A__crm_doctemplates="https://biuro.biall-net.pl/wfs/default_db/table/crm_doctemplates.xsd"
        xmlns:default_db__x3A__crm_coordinators="https://biuro.biall-net.pl/wfs/default_db/table/crm_coordinators.xsd"
        xmlns:default_db__x3A__fin_familiepayments="https://biuro.biall-net.pl/wfs/default_db/table/fin_familiepayments.xsd"
        xmlns:default_db__x3A__crm_filetypes="https://biuro.biall-net.pl/wfs/default_db/table/crm_filetypes.xsd"
        xmlns:default_db__x3A__crm_files="https://biuro.biall-net.pl/wfs/default_db/table/crm_files.xsd"
        xmlns:default_db__x3A__crm_notetypes="https://biuro.biall-net.pl/wfs/default_db/table/crm_notetypes.xsd"
        xmlns:default_db__x3A__crm_transports="https://biuro.biall-net.pl/wfs/default_db/table/crm_transports.xsd"
        xmlns:default_db__x3A__crm_transfersgroups="https://biuro.biall-net.pl/wfs/default_db/table/crm_transfersgroups.xsd"
        xmlns:default_db__x3A__crm_carrerbankdetails="https://biuro.biall-net.pl/wfs/default_db/table/crm_carrerbankdetails.xsd"
        xmlns:default_db__x3A__crm_transfergroupssparts="https://biuro.biall-net.pl/wfs/default_db/table/crm_transfergroupssparts.xsd"
        xmlns:default_db__x3A__crm_companies="https://biuro.biall-net.pl/wfs/default_db/table/crm_companies.xsd"
        xmlns:default_db__x3A__crm_transportstatuses="https://biuro.biall-net.pl/wfs/default_db/table/crm_transportstatuses.xsd"
        xmlns:default_db__x3A__crm_warddiseases="https://biuro.biall-net.pl/wfs/default_db/table/crm_warddiseases.xsd"
        xmlns:default_db__x3A__fin_invoices="https://biuro.biall-net.pl/wfs/default_db/table/fin_invoices.xsd"
        xmlns:default_db__x3A__crm_orderdayscalculationtypes="https://biuro.biall-net.pl/wfs/default_db/table/crm_orderdayscalculationtypes.xsd"
        xmlns:default_db__x3A__fin_paymenttypes="https://biuro.biall-net.pl/wfs/default_db/table/fin_paymenttypes.xsd"
        xmlns:default_db__x3A__imp_companies="https://biuro.biall-net.pl/wfs/default_db/table/imp_companies.xsd"
        xmlns:default_db__x3A__imp_users="https://biuro.biall-net.pl/wfs/default_db/table/imp_users.xsd"
        xmlns:default_db__x3A__sys_applications="https://biuro.biall-net.pl/wfs/default_db/table/sys_applications.xsd"
        xmlns:default_db__x3A__sys_accesses="https://biuro.biall-net.pl/wfs/default_db/table/sys_accesses.xsd"
        xmlns:default_db__x3A__sys_userstatuses="https://biuro.biall-net.pl/wfs/default_db/table/sys_userstatuses.xsd"
        xmlns:default_db__x3A__web_companies="https://biuro.biall-net.pl/wfs/default_db/table/web_companies.xsd"
        xmlns:default_db__x3A__web_users="https://biuro.biall-net.pl/wfs/default_db/table/web_users.xsd"
        xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
        xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types"
        targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/crm_companies.xsd"
        system_cache__appinfo:restriction_path_TODEL=""
        system_cache__appinfo:sort="0"
        system_cache__appinfo:root_element_in_schema="true"
        system_cache__appinfo:prefix="default_db"
        system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
        system_cache__appinfo:document-uri-orig="/bravecom/bravecom_ele.xsd">
   <import namespace="https://biuro.biall-net.pl/wfs/default_db/table/sys_users.xsd"
           schemaLocation="default_db__x3A__sys_users.xsd"/>
   <xs:complexType xmlns:xs="http://www.w3.org/2001/XMLSchema"
                   system_cache__appinfo:restriction_path_TODEL=""
                   name="crm_companies"
                   id="default_d___d5e4457-1_crm_compan"
                   system_cache__appinfo:sort="0"
                   system_cache__appinfo:root_element_in_schema="true"
                   system_cache__appinfo:prefix="default_db"
                   system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"><!--#139 to include  -->
      <xs:sequence system_cache__appinfo:restriction_path_TODEL=""
                   id="default_d___d5e4458-1"
                   system_cache__appinfo:sort="1"
                   system_cache__appinfo:root_element_in_schema="true"
                   system_cache__appinfo:prefix="default_db"
                   system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table">
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4459-1_Id"
                     name="Id"
                     minOccurs="0"
                     type="p5Type:integer"
                     system_cache__appinfo:xpath_local="p5Type:integer"
                     system_cache__appinfo:restriction_path=""/>
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4460-1_CreatedByU"
                     name="CreatedByUserId"
                     minOccurs="0"
                     type="p5Type:integer"
                     system_cache__appinfo:xpath_local="p5Type:integer"
                     system_cache__appinfo:restriction_path=""/>
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4461-1_CreatedDat"
                     name="CreatedDateTime"
                     minOccurs="0"
                     default="CURRENT_TIMESTAMP"
                     type="p5Type:dateTime"
                     system_cache__appinfo:xpath_local="p5Type:dateTime"
                     system_cache__appinfo:restriction_path=""/>
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4462-1_LastUpdate"
                     name="LastUpdateUserId"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="p5Type:integer"
                     system_cache__appinfo:xpath_local="p5Type:integer"
                     system_cache__appinfo:restriction_path=""/>
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4463-1_LastUpdate"
                     name="LastUpdateDateTime"
                     minOccurs="0"
                     default="CURRENT_TIMESTAMP"
                     type="p5Type:integer"
                     system_cache__appinfo:xpath_local="p5Type:integer"
                     system_cache__appinfo:restriction_path=""/>
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4464-1_IsDeleted"
                     name="IsDeleted"
                     minOccurs="0"
                     default="0"
                     type="p5Type:integer"
                     system_cache__appinfo:xpath_local="p5Type:integer"
                     system_cache__appinfo:restriction_path=""/>
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4465-1_CompanyNam"
                     name="CompanyName"
                     minOccurs="0"
                     type="p5Type:string"
                     system_cache__appinfo:xpath_local="p5Type:string"
                     system_cache__appinfo:restriction_path=""/>
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4466-1_NIP"
                     name="NIP"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="p5Type:string"
                     system_cache__appinfo:xpath_local="p5Type:string"
                     system_cache__appinfo:restriction_path=""/>
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4467-1_REGON"
                     name="REGON"
                     minOccurs="0"
                     type="p5Type:string"
                     system_cache__appinfo:xpath_local="p5Type:string"
                     system_cache__appinfo:restriction_path=""/>
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4468-1_Info"
                     name="Info"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="p5Type:text"
                     system_cache__appinfo:xpath_local="p5Type:text"
                     system_cache__appinfo:restriction_path=""/>
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4469-1_BankAccoun"
                     name="BankAccountPLN"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="p5Type:string"
                     system_cache__appinfo:xpath_local="p5Type:string"
                     system_cache__appinfo:restriction_path=""/>
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4471-1_BankAccoun"
                     name="BankAccountEUR"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="p5Type:string"
                     system_cache__appinfo:xpath_local="p5Type:string"
                     system_cache__appinfo:restriction_path=""/>
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4472-1_CompanyNam"
                     name="CompanyNameContract"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="p5Type:string"
                     system_cache__appinfo:xpath_local="p5Type:string"
                     system_cache__appinfo:restriction_path=""/>
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4473-1_CompanyNam"
                     name="CompanyNameContract2"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="p5Type:string"
                     system_cache__appinfo:xpath_local="p5Type:string"
                     system_cache__appinfo:restriction_path=""/>
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4474-1_Address1"
                     name="Address1"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="p5Type:string"
                     system_cache__appinfo:xpath_local="p5Type:string"
                     system_cache__appinfo:restriction_path=""/>
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4475-1_Address2"
                     name="Address2"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="p5Type:string"
                     system_cache__appinfo:xpath_local="p5Type:string"
                     system_cache__appinfo:restriction_path=""/>
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4476-1_Representa"
                     name="Representative"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="p5Type:string"
                     system_cache__appinfo:xpath_local="p5Type:string"
                     system_cache__appinfo:restriction_path=""/>
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4477-1_Representa"
                     name="RepresentativeContract"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="p5Type:string"
                     system_cache__appinfo:xpath_local="p5Type:string"
                     system_cache__appinfo:restriction_path=""/>
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4478-1_RegistryNu"
                     name="RegistryNumber"
                     minOccurs="0"
                     nillable="true"
                     default=""
                     type="p5Type:string"
                     system_cache__appinfo:xpath_local="p5Type:string"
                     system_cache__appinfo:restriction_path=""/>
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4479-1"
                     ref="default_db__x3A__sys_users:sys_users"
                     system_cache__appinfo:xpath_local="default_db:sys_users"
                     system_cache__appinfo:restriction_path=""><!--#139 to include -->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="CreatedByUserId"
                                                   system_cache__appinfo:xpath="default_db__x3A__crm_companies__x3A__sys_users:sys_users/UserId"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element system_cache__appinfo:sort="1"
                     system_cache__appinfo:prefix="default_db"
                     system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
                     id="default_d___d5e4483-1"
                     ref="default_db__x3A__sys_users:sys_users"
                     system_cache__appinfo:xpath_local="default_db:sys_users"
                     system_cache__appinfo:restriction_path=""><!--#139 to include -->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="LastUpdateUserId"
                                                   system_cache__appinfo:xpath="default_db__x3A__crm_companies__x3A__sys_users:sys_users/UserId"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
      </xs:sequence>
   </xs:complexType>
   <xs:element xmlns:xs="http://www.w3.org/2001/XMLSchema"
               name="crm_companies"
               type="default_db__x3A__crm_companies:crm_companies"
               id="default_d___d5e4487-1_crm_compan"
               system_cache__appinfo:root_element_in_schema="true"
               system_cache__appinfo:xpath_local=""
               system_cache__appinfo:sort="1"
               system_cache__appinfo:prefix="default_db"
               system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
               system_cache__appinfo:restriction_path=""><!--#139 to include  --></xs:element>
</schema>