123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360 |
- <?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:default_db__x3A__crm_a1s="https://biuro.biall-net.pl/wfs/default_db/table/crm_a1s.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_a1s.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_a1s"
- id="default_d___d5e4141-1_crm_a1s"
- 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___d5e4142-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___d5e4143-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___d5e4144-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___d5e4145-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___d5e4146-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___d5e4147-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___d5e4148-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___d5e4149-1_CarrerId"
- name="CarrerId"
- 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___d5e4150-1_DateStart"
- name="DateStart"
- minOccurs="0"
- type="p5Type:date"
- system_cache__appinfo:xpath_local="p5Type:date"
- 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___d5e4151-1_DateEnd"
- name="DateEnd"
- minOccurs="0"
- type="p5Type:date"
- system_cache__appinfo:xpath_local="p5Type:date"
- 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___d5e4152-1_Number"
- name="Number"
- 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___d5e4153-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___d5e4155-1_StatusId"
- name="StatusId"
- minOccurs="0"
- nillable="true"
- default="1"
- 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___d5e4156-1_SentToAcco"
- name="SentToAccountants"
- 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___d5e4157-1_SentToAccD"
- name="SentToAccDate"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:date"
- system_cache__appinfo:xpath_local="p5Type:date"
- 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___d5e4158-1_SentToAccU"
- name="SentToAccUser"
- 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___d5e4159-1_ReciveFrom"
- name="ReciveFromAcc"
- 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___d5e4160-1_ReciveFrom"
- name="ReciveFromAccDate"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:date"
- system_cache__appinfo:xpath_local="p5Type:date"
- 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___d5e4161-1_ReciveFrom"
- name="ReciveFromAccUser"
- 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___d5e4162-1_SentToZUS"
- name="SentToZUS"
- 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___d5e4163-1_SentToZUSD"
- name="SentToZUSDate"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:date"
- system_cache__appinfo:xpath_local="p5Type:date"
- 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___d5e4164-1_SentToZUSU"
- name="SentToZUSUser"
- 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___d5e4165-1_ReciveFrom"
- name="ReciveFromZUS"
- 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___d5e4167-1_ReciveFrom"
- name="ReciveFromZUSDate"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:date"
- system_cache__appinfo:xpath_local="p5Type:date"
- 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___d5e4168-1_ReciveFrom"
- name="ReciveFromZUSUser"
- 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___d5e4169-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_a1s__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___d5e4173-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_a1s__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_a1s"
- type="default_db__x3A__crm_a1s:crm_a1s"
- id="default_d___d5e4177-1_crm_a1s"
- 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>
|