| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822 |
- <?xml version="1.0" encoding="UTF-8"?>
- <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
- xmlns:default_db__x3A__BUILDINGS="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
- xmlns:gml="http://www.opengis.net/gml/3.2"
- xmlns:default_db__x3A__COMPANIES="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
- xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types"
- xmlns:default_db__x3A__TERYT_adresy="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_adresy.xsd"
- xmlns:fix_se_defaultdb_schema="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/fix_se_defaultdb_schema/fix_se_defaultdb_schema.xsd"
- xmlns:default_db__x3A__ADMIN_USERS="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
- xmlns:default_db__x3A__CRM_LISTA_ZASOBOW="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW.xsd"
- xmlns:default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
- xmlns:default_db__x3A__TERYT_ulice="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_ulice.xsd"
- xmlns:default_db__x3A__USERS2_MARKETING="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_MARKETING.xsd"
- xmlns:default_db__x3A__MK_Rewiry="https://biuro.biall-net.pl/wfs/default_db/table/MK_Rewiry.xsd"
- 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"
- xmlns:ant-object="http://biuro.biall-net.pl/xmlschema_procesy5/ant-object/ant-object.xsd"
- xmlns:p5ant-interface="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/ant_interface/ant_interface.xsd"
- elementFormDefault="qualified"
- targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
- vc:minVersion="1.1">
- <xs:import namespace="http://www.opengis.net/gml/3.2"
- schemaLocation="http://www.opengis.net/gml/3.2"/>
- <xs:import namespace="http://biuro.biall-net.pl/p5/schema/types"
- schemaLocation="../../../types.xsd"/>
- <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
- schemaLocation="../../default_db.COMPANIES/COMPANIES/COMPANIES.xsd"/>
- <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_adresy.xsd"
- schemaLocation="../../default_db.TERYT_adresy/TERYT_adresy/TERYT_adresy.xsd"/>
- <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
- schemaLocation="../../default_db.ADMIN_USERS/ADMIN_USERS/ADMIN_USERS.xsd"/>
- <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
- schemaLocation="../../default_db.IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI.xsd"/>
- <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW.xsd"
- schemaLocation="../../default_db.CRM_LISTA_ZASOBOW/CRM_LISTA_ZASOBOW/CRM_LISTA_ZASOBOW.xsd"/>
- <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_MARKETING.xsd"
- schemaLocation="../../default_db.USERS2_MARKETING/USERS2_MARKETING/USERS2_MARKETING.xsd"/>
- <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/MK_Rewiry.xsd"
- schemaLocation="../../default_db.MK_Rewiry/MK_Rewiry/MK_Rewiry.xsd"/>
- <xs:import schemaLocation="../../default_db.TERYT_ulice/TERYT_ulice/TERYT_ulice.xsd"
- namespace="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_ulice.xsd"/>
- <xs:complexType name="BUILDINGS" id="__BUILDINGS___d18e47658-1_BUILDINGS"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:heritage>
- <system_cache__appinfo:inherit system_cache__appinfo:inherit_ref="default_db:BUILDINGS"
- 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_ID"/>
- </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="__BUILDINGS___d18e47667-1">
- <xs:element name="ID" type="p5Type:integer" id="__BUILDINGS___d18e47668-1_ID"/>
- <xs:element name="geoportal_gml_punkty_adr_gml_id"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e47669-1_geoportal_"/>
- <xs:element name="TERYT_ulice"
- minOccurs="0"
- type="xs:int"
- id="__BUILDINGS___d18e47670-1_TERYT_ulic"/>
- <!--<xs:element minOccurs="0" ref="default_db__x3A__TERYT_SIMC:TERYT_SIMC">
- <xs:annotation>
- <xs:documentation>Opcjonalne dowiazanie sie do jakiegos adresu i zaciagniecie z niego danych lokalne</xs:documentation>
- </xs:annotation>
- </xs:element>-->
- <xs:element minOccurs="0"
- ref="default_db__x3A__TERYT_ulice:TERYT_ulice"
- id="__BUILDINGS___d18e47672-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="TERYT_ulice"
- system_cache__appinfo:xpath="default_db__x3A__TERYT_ulice:TERYT_ulice/SYM"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- <xs:documentation>Opcjonalne dowiazanie sie do jakiegos adresu i zaciagniecie z niego danych lokalne</xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:element name="A_RECORD_CREATE_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47679-1_A_RECORD_C"/>
- <xs:element name="A_RECORD_CREATE_AUTHOR"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47680-1_A_RECORD_C"/>
- <xs:element name="A_RECORD_UPDATE_DATE"
- minOccurs="0"
- type="p5Type:dateTime"
- id="__BUILDINGS___d18e47681-1_A_RECORD_U"/>
- <xs:element name="A_RECORD_UPDATE_AUTHOR"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47682-1_A_RECORD_U"/>
- <xs:element name="L_APPOITMENT_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47683-1_L_APPOITME"/>
- <xs:element name="L_APPOITMENT_USER"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47684-1_L_APPOITME"/>
- <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
- id="__BUILDINGS___d18e47686-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="L_APPOITMENT_USER"
- system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- </xs:annotation>
- </xs:element>
- <xs:element name="L_APPOITMENT_PERIOD"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47691-1_L_APPOITME"/>
- <xs:element name="L_APPOITMENT_INFO"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47692-1_L_APPOITME"/>
- <xs:element name="L_APPOITMENT_TYPE"
- minOccurs="0"
- nillable="true"
- default=""
- type="xs:string"
- id="__BUILDINGS___d18e47693-1_L_APPOITME"/>
- <xs:element name="A_PROBLEM"
- minOccurs="0"
- nillable="true"
- default=""
- type="xs:string"
- id="__BUILDINGS___d18e47694-1_A_PROBLEM"/>
- <xs:element name="A_PROBLEM_DESC"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47695-1_A_PROBLEM_"/>
- <xs:element name="A_PROBLEM_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47696-1_A_PROBLEM_"/>
- <xs:element name="A_STATUS"
- minOccurs="0"
- nillable="true"
- default="MONITOR"
- type="default_db__x3A__BUILDINGS:A_STATUS_Type"
- id="__BUILDINGS___d18e47697-1_A_STATUS"/>
- <xs:element name="A_STATUS_INFO"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47698-1_A_STATUS_I"/>
- <xs:element name="A_STATUS_LASTCHANGE_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47699-1_A_STATUS_L"/>
- <xs:element name="A_UPDATE_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47700-1_A_UPDATE_D"/>
- <xs:element name="A_ADM_COMPANY"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47702-1_A_ADM_COMP"/>
- <xs:element name="S_ADMIN_NAME"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47703-1_S_ADMIN_NA"/>
- <xs:element name="S_ADDRESS_CITY"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47704-1_S_ADDRESS_"/>
- <xs:element name="S_ADDRESS_POST_CODE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47705-1_S_ADDRESS_"/>
- <xs:element name="S_ADDRESS_POST_OFFICE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47706-1_S_ADDRESS_"/>
- <xs:element name="S_ADDRESS_STREET"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47707-1_S_ADDRESS_"/>
- <xs:element name="S_ADDRESS_STREET_FULL"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e47708-1_S_ADDRESS_"/>
- <xs:element name="S_ADDRESS_HOUSE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47709-1_S_ADDRESS_"/>
- <xs:element name="S_OTHER_INFO"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47710-1_S_OTHER_IN"/>
- <xs:element name="P_ADMIN_NAME"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47711-1_P_ADMIN_NA"/>
- <xs:element name="P_ADDRESS_CITY"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47712-1_P_ADDRESS_"/>
- <xs:element name="P_ADDRESS_POST_CODE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47714-1_P_ADDRESS_"/>
- <xs:element name="P_ADDRESS_POST_OFFICE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47715-1_P_ADDRESS_"/>
- <xs:element name="P_ADDRESS_STREET"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47716-1_P_ADDRESS_"/>
- <xs:element name="P_ADDRESS_HOUSE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47717-1_P_ADDRESS_"/>
- <xs:element name="P_OTHER_INFO"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47718-1_P_OTHER_IN"/>
- <xs:element name="P_DEAL_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47719-1_P_DEAL_DAT"/>
- <xs:element name="P_DEALNUMBER"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47720-1_P_DEALNUMB"/>
- <xs:element name="P_DEALEXPIRE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47721-1_P_DEALEXPI"/>
- <xs:element name="P_DEAL_DETAIL"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47722-1_P_DEAL_DET"/>
- <xs:element name="P_DEAL_LOCATION"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47723-1_P_DEAL_LOC"/>
- <xs:element name="T_NETWORK_SERVER"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47724-1_T_NETWORK_"/>
- <xs:element name="T_TOPOLOGY_PLACE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47726-1_T_TOPOLOGY"/>
- <xs:element name="T_BUILDING_TYPE"
- minOccurs="0"
- default="N/S;"
- type="default_db__x3A__BUILDINGS:T_BUILDING_TYPE_Type"
- id="__BUILDINGS___d18e47727-1_T_BUILDING"/>
- <xs:element name="T_BUILDING_SAVE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47728-1_T_BUILDING"/>
- <xs:element name="T_BUILDING_POWER"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47729-1_T_BUILDING"/>
- <xs:element name="T_INSTALACJA_W_CIAGU_DNI"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47730-1_T_INSTALAC"/>
- <xs:element name="T_WORKPOINTS"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e47731-1_T_WORKPOIN"/>
- <xs:element name="T_WORKPOINTS_VALUE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47732-1_T_WORKPOIN"/>
- <xs:element name="T_WORKPOINTS_TYPE"
- minOccurs="0"
- nillable="true"
- type="default_db__x3A__BUILDINGS:T_WORKPOINTS_TYPE_Type"
- id="__BUILDINGS___d18e47733-1_T_WORKPOIN"/>
- <xs:element name="T_WORKPOINTS_USER"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47734-1_T_WORKPOIN"/>
- <xs:element name="T_WORKPOINTS_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47735-1_T_WORKPOIN"/>
- <xs:element name="T_WHO_CONNECTED"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47736-1_T_WHO_CONN"/>
- <xs:element name="T_WHEN_CONNECTED"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47738-1_T_WHEN_CON"/>
- <xs:element name="T_TEL_KONKURENCJA_OPER"
- minOccurs="0"
- nillable="true"
- type="xs:string"
- id="__BUILDINGS___d18e47739-1_T_TEL_KONK"/>
- <xs:element name="T_TV_KONKURENCJA_OPER"
- minOccurs="0"
- nillable="true"
- type="xs:string"
- id="__BUILDINGS___d18e47740-1_T_TV_KONKU"/>
- <xs:element name="T_LAN_KONKURENCJA_OPER"
- minOccurs="0"
- nillable="true"
- type="default_db__x3A__BUILDINGS:T_LAN_KONKURENCJA_OPER_Type"
- id="__BUILDINGS___d18e47741-1_T_LAN_KONK"/>
- <xs:element name="B_INVENTORY_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47742-1_B_INVENTOR"/>
- <xs:element name="M_ZRYWKA_DATE"
- minOccurs="0"
- nillable="true"
- type="p5Type:date"
- id="__BUILDINGS___d18e47743-1_M_ZRYWKA_D"/>
- <xs:element name="M_ZRYWKA_NUMBER"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47744-1_M_ZRYWKA_N"/>
- <xs:element name="M_REWIR"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47745-1_M_REWIR"/>
- <xs:element ref="default_db__x3A__MK_Rewiry:MK_Rewiry"
- id="__BUILDINGS___d18e47746-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="M_REWIR"
- system_cache__appinfo:xpath="default_db__x3A__MK_Rewiry:MK_Rewiry/NAZWA_REWI"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- </xs:annotation>
- </xs:element>
- <xs:element name="M_PARAMETRY"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47751-1_M_PARAMETR"/>
- <xs:element name="M_DIST_OPTIONS"
- minOccurs="0"
- nillable="true"
- type="xs:string"
- id="__BUILDINGS___d18e47752-1_M_DIST_OPT"/>
- <xs:element name="M_DIRECT_MARKETING_DATE"
- minOccurs="0"
- nillable="true"
- type="p5Type:date"
- id="__BUILDINGS___d18e47754-1_M_DIRECT_M"/>
- <xs:element name="M_DATA_ZASIEDLENIA"
- minOccurs="0"
- nillable="true"
- type="p5Type:date"
- id="__BUILDINGS___d18e47755-1_M_DATA_ZAS"/>
- <xs:element name="ID_PROJECT"
- minOccurs="0"
- nillable="true"
- type="p5Type:integer"
- id="__BUILDINGS___d18e47756-1_ID_PROJECT"/>
- <xs:element ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT"
- id="__BUILDINGS___d18e47757-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="ID_PROJECT"
- system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT/ID"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- </xs:annotation>
- </xs:element>
- <xs:element name="path"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47762-1_path"/>
- <xs:element name="P_NR_DZIALKI"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47763-1_P_NR_DZIAL"/>
- <xs:element name="P_NR_KW"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47764-1_P_NR_KW"/>
- <xs:element name="P_OTHER_DOC"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47765-1_P_OTHER_DO"/>
- <xs:element name="P_PESEL"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47766-1_P_PESEL"/>
- <xs:element name="P_KRS"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47767-1_P_KRS"/>
- <xs:element name="P_ADDRESS"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47768-1_P_ADDRESS"/>
- <xs:element name="P_NAME"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47770-1_P_NAME"/>
- <xs:element name="P_ACCOUNT"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e47771-1_P_ACCOUNT"/>
- <xs:element name="P_OSIEDLE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47772-1_P_OSIEDLE"/>
- <xs:element name="T_BUILDING_PIETRA"
- minOccurs="0"
- type="p5Type:integer"
- id="__BUILDINGS___d18e47773-1_T_BUILDING"/>
- <xs:element name="T_BUILDING_PIWNICA"
- minOccurs="0"
- default="N/S;"
- type="xs:string"
- id="__BUILDINGS___d18e47774-1_T_BUILDING"/>
- <xs:element name="T_BUILDING_KLATKI"
- minOccurs="0"
- type="p5Type:integer"
- id="__BUILDINGS___d18e47775-1_T_BUILDING"/>
- <xs:element name="T_BUILDING_MIESZKANIA"
- minOccurs="0"
- type="p5Type:integer"
- id="__BUILDINGS___d18e47776-1_T_BUILDING"/>
- <xs:element name="A_CLASSIFIED"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e47777-1_A_CLASSIFI"/>
- <xs:element name="M_LAST_STICKER_DATE"
- minOccurs="0"
- nillable="true"
- type="p5Type:date"
- id="__BUILDINGS___d18e47778-1_M_LAST_STI"/>
- <xs:element name="the_geom"
- minOccurs="0"
- nillable="true"
- type="p5Type:polygon"
- id="__BUILDINGS___d18e47779-1_the_geom"/>
- <xs:element name="SYNC_SQIX_STATUS"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e47780-1_SYNC_SQIX_"/>
- <xs:element name="gid"
- minOccurs="0"
- nillable="true"
- type="p5Type:integer"
- id="__BUILDINGS___d18e47782-1_gid"/>
- <xs:element name="T_ADDRESS_CLASS"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47783-1_T_ADDRESS_"/>
- <xs:element name="B_LINK"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47784-1_B_LINK"/>
- <xs:element name="B_URL"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47785-1_B_URL"/>
- <xs:element name="B_XYZ"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47786-1_B_XYZ"/>
- <xs:element name="B_ASCII"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:text"
- id="__BUILDINGS___d18e47787-1_B_ASCII"/>
- <xs:element name="CRM_LISTA_ZASOBOW_ID"
- minOccurs="0"
- type="p5Type:integer"
- id="__BUILDINGS___d18e47788-1_CRM_LISTA_"/>
- <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID"
- id="__BUILDINGS___d18e47789-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="CRM_LISTA_ZASOBOW_ID"
- system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID/ID"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- </xs:annotation>
- </xs:element>
- <xs:element name="etykieta_x"
- minOccurs="0"
- nillable="true"
- type="p5Type:decimal"
- id="__BUILDINGS___d18e47794-1_etykieta_x"/>
- <xs:element name="etykieta_y"
- minOccurs="0"
- nillable="true"
- type="p5Type:decimal"
- id="__BUILDINGS___d18e47795-1_etykieta_y"/>
- <xs:element name="__Rozdzielcza_Kabel_Swiatlowodowy_wsg84"
- minOccurs="0"
- nillable="true"
- type="p5Type:integer"
- id="__BUILDINGS___d18e47796-1___Rozdziel"/>
- <xs:element name="__MK_Rewiry__STATUS"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e47798-1___MK_Rewir"/>
- <xs:element name="ID_BILLING_USERS"
- minOccurs="0"
- type="p5Type:integer"
- id="__BUILDINGS___d18e47799-1_ID_BILLING"/>
- <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS"
- minOccurs="0"
- id="__BUILDINGS___d18e47800-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="ID_BILLING_USERS"
- system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- </xs:annotation>
- </xs:element>
- <xs:element name="ID_BILLING_USERS_ADMIN"
- minOccurs="0"
- type="p5Type:integer"
- id="__BUILDINGS___d18e47805-1_ID_BILLING"/>
- <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS_ADMIN"
- minOccurs="0"
- id="__BUILDINGS___d18e47806-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="ID_BILLING_USERS_ADMIN"
- system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS_ADMIN/ID"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- </xs:annotation>
- </xs:element>
- <xs:element maxOccurs="unbounded"
- minOccurs="0"
- ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING"
- id="__BUILDINGS___d18e47811-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="S_ADDRESS_STREET"
- system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING/T_TELBOX_BUILDING_IN"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- <xs:documentation>Reff- backref jest od marketingu</xs:documentation>
- </xs:annotation>
- </xs:element>
- </xs:sequence>
- </xs:complexType>
- <xs:element name="BUILDINGS"
- type="default_db__x3A__BUILDINGS:BUILDINGS"
- id="__BUILDINGS___d18e47819-1_BUILDINGS"/>
- <xs:complexType name="Budynek_blok" id="__BUILDINGS___d18e47820-1_Budynek_bl">
- <xs:complexContent id="__BUILDINGS___d18e47821-1">
- <xs:restriction base="default_db__x3A__BUILDINGS:BUILDINGS">
- <xs:sequence id="__BUILDINGS___d18e47823-1">
- <xs:element name="ID" type="p5Type:integer" id="__BUILDINGS___d18e47824-1_ID"/>
- <xs:element name="geoportal_gml_punkty_adr_gml_id"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e47825-1_geoportal_"/>
- <xs:element name="TERYT_ulice"
- minOccurs="0"
- type="xs:int"
- id="__BUILDINGS___d18e47826-1_TERYT_ulic"/>
- <xs:element minOccurs="0"
- ref="default_db__x3A__TERYT_ulice:TERYT_ulice"
- id="__BUILDINGS___d18e47827-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="TERYT_ulice"
- system_cache__appinfo:xpath="default_db__x3A__TERYT_ulice:TERYT_ulice/SYM"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- <xs:documentation>Opcjonalne dowiazanie sie do jakiegos adresu i zaciagniecie z niego danych lokalne</xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:element name="A_RECORD_CREATE_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47834-1_A_RECORD_C"/>
- <xs:element name="A_RECORD_CREATE_AUTHOR"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47835-1_A_RECORD_C"/>
- <xs:element name="A_RECORD_UPDATE_DATE"
- minOccurs="0"
- type="p5Type:dateTime"
- id="__BUILDINGS___d18e47836-1_A_RECORD_U"/>
- <xs:element name="A_RECORD_UPDATE_AUTHOR"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47837-1_A_RECORD_U"/>
- <xs:element name="L_APPOITMENT_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47838-1_L_APPOITME"/>
- <xs:element name="L_APPOITMENT_USER"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47839-1_L_APPOITME"/>
- <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
- id="__BUILDINGS___d18e47840-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="L_APPOITMENT_USER"
- system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- </xs:annotation>
- </xs:element>
- <xs:element name="L_APPOITMENT_PERIOD"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47846-1_L_APPOITME"/>
- <xs:element name="L_APPOITMENT_INFO"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47847-1_L_APPOITME"/>
- <xs:element name="L_APPOITMENT_TYPE"
- minOccurs="0"
- nillable="true"
- default=""
- type="xs:string"
- id="__BUILDINGS___d18e47848-1_L_APPOITME"/>
- <xs:element name="A_PROBLEM"
- minOccurs="0"
- nillable="true"
- default=""
- type="xs:string"
- id="__BUILDINGS___d18e47849-1_A_PROBLEM"/>
- <xs:element name="A_PROBLEM_DESC"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47850-1_A_PROBLEM_"/>
- <xs:element name="A_PROBLEM_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47851-1_A_PROBLEM_"/>
- <xs:element name="A_STATUS"
- minOccurs="0"
- nillable="true"
- default="MONITOR"
- type="default_db__x3A__BUILDINGS:A_STATUS_Type"
- id="__BUILDINGS___d18e47852-1_A_STATUS"/>
- <xs:element name="A_STATUS_INFO"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47853-1_A_STATUS_I"/>
- <xs:element name="A_STATUS_LASTCHANGE_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47854-1_A_STATUS_L"/>
- <xs:element name="A_UPDATE_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47855-1_A_UPDATE_D"/>
- <xs:element name="A_ADM_COMPANY"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47856-1_A_ADM_COMP"/>
- <xs:element name="S_ADMIN_NAME"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47858-1_S_ADMIN_NA"/>
- <xs:element name="S_ADDRESS_CITY"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47859-1_S_ADDRESS_"/>
- <xs:element name="S_ADDRESS_POST_CODE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47860-1_S_ADDRESS_"/>
- <xs:element name="S_ADDRESS_POST_OFFICE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47861-1_S_ADDRESS_"/>
- <xs:element name="S_ADDRESS_STREET"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47862-1_S_ADDRESS_"/>
- <xs:element name="S_ADDRESS_STREET_FULL"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e47863-1_S_ADDRESS_"/>
- <xs:element name="S_ADDRESS_HOUSE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47864-1_S_ADDRESS_"/>
- <xs:element name="S_OTHER_INFO"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47865-1_S_OTHER_IN"/>
- <xs:element name="P_ADMIN_NAME"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47866-1_P_ADMIN_NA"/>
- <xs:element name="P_ADDRESS_CITY"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47867-1_P_ADDRESS_"/>
- <xs:element name="P_ADDRESS_POST_CODE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47868-1_P_ADDRESS_"/>
- <xs:element name="P_ADDRESS_POST_OFFICE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47870-1_P_ADDRESS_"/>
- <xs:element name="P_ADDRESS_STREET"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47871-1_P_ADDRESS_"/>
- <xs:element name="P_ADDRESS_HOUSE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47872-1_P_ADDRESS_"/>
- <xs:element name="P_OTHER_INFO"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47873-1_P_OTHER_IN"/>
- <xs:element name="P_DEAL_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47874-1_P_DEAL_DAT"/>
- <xs:element name="P_DEALNUMBER"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47875-1_P_DEALNUMB"/>
- <xs:element name="P_DEALEXPIRE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47876-1_P_DEALEXPI"/>
- <xs:element name="P_DEAL_DETAIL"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47877-1_P_DEAL_DET"/>
- <xs:element name="P_DEAL_LOCATION"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47878-1_P_DEAL_LOC"/>
- <xs:element name="T_NETWORK_SERVER"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47879-1_T_NETWORK_"/>
- <xs:element name="T_TOPOLOGY_PLACE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47880-1_T_TOPOLOGY"/>
- <xs:element name="T_BUILDING_SAVE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47882-1_T_BUILDING"/>
- <xs:element name="T_BUILDING_POWER"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47883-1_T_BUILDING"/>
- <xs:element name="T_INSTALACJA_W_CIAGU_DNI"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47884-1_T_INSTALAC"/>
- <xs:element name="T_WORKPOINTS"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e47885-1_T_WORKPOIN"/>
- <xs:element name="T_WORKPOINTS_VALUE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47886-1_T_WORKPOIN"/>
- <xs:element name="T_WORKPOINTS_USER"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47887-1_T_WORKPOIN"/>
- <xs:element name="T_WORKPOINTS_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47888-1_T_WORKPOIN"/>
- <xs:element name="T_WHO_CONNECTED"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47889-1_T_WHO_CONN"/>
- <xs:element name="T_WHEN_CONNECTED"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47890-1_T_WHEN_CON"/>
- <xs:element name="T_TEL_KONKURENCJA_OPER"
- minOccurs="0"
- nillable="true"
- type="xs:string"
- id="__BUILDINGS___d18e47891-1_T_TEL_KONK"/>
- <xs:element name="T_TV_KONKURENCJA_OPER"
- minOccurs="0"
- nillable="true"
- type="xs:string"
- id="__BUILDINGS___d18e47892-1_T_TV_KONKU"/>
- <xs:element name="T_LAN_KONKURENCJA_OPER"
- minOccurs="0"
- nillable="true"
- type="default_db__x3A__BUILDINGS:T_LAN_KONKURENCJA_OPER_Type"
- id="__BUILDINGS___d18e47894-1_T_LAN_KONK"/>
- <xs:element name="B_INVENTORY_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47895-1_B_INVENTOR"/>
- <xs:element name="M_ZRYWKA_DATE"
- minOccurs="0"
- nillable="true"
- type="p5Type:date"
- id="__BUILDINGS___d18e47896-1_M_ZRYWKA_D"/>
- <xs:element name="M_ZRYWKA_NUMBER"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47897-1_M_ZRYWKA_N"/>
- <xs:element name="M_REWIR"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47898-1_M_REWIR"/>
- <xs:element ref="default_db__x3A__MK_Rewiry:MK_Rewiry"
- id="__BUILDINGS___d18e47899-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="M_REWIR"
- system_cache__appinfo:xpath="default_db__x3A__MK_Rewiry:MK_Rewiry/NAZWA_REWI"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- <xs:documentation>
- TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #4122 !!!
- </xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:element name="M_PARAMETRY"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47906-1_M_PARAMETR"/>
- <xs:element name="M_DIST_OPTIONS"
- minOccurs="0"
- nillable="true"
- type="xs:string"
- id="__BUILDINGS___d18e47907-1_M_DIST_OPT"/>
- <xs:element name="M_DIRECT_MARKETING_DATE"
- minOccurs="0"
- nillable="true"
- type="p5Type:date"
- id="__BUILDINGS___d18e47908-1_M_DIRECT_M"/>
- <xs:element name="M_DATA_ZASIEDLENIA"
- minOccurs="0"
- nillable="true"
- type="p5Type:date"
- id="__BUILDINGS___d18e47909-1_M_DATA_ZAS"/>
- <xs:element name="ID_PROJECT"
- minOccurs="0"
- nillable="true"
- type="p5Type:integer"
- id="__BUILDINGS___d18e47910-1_ID_PROJECT"/>
- <xs:element ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT"
- id="__BUILDINGS___d18e47912-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="ID_PROJECT"
- system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT/ID"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- </xs:annotation>
- </xs:element>
- <xs:element name="path"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47917-1_path"/>
- <xs:element name="P_NR_DZIALKI"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47918-1_P_NR_DZIAL"/>
- <xs:element name="P_NR_KW"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47919-1_P_NR_KW"/>
- <xs:element name="P_OTHER_DOC"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47920-1_P_OTHER_DO"/>
- <xs:element name="P_PESEL"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47921-1_P_PESEL"/>
- <xs:element name="P_KRS"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47922-1_P_KRS"/>
- <xs:element name="P_ADDRESS"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47923-1_P_ADDRESS"/>
- <xs:element name="P_NAME"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47924-1_P_NAME"/>
- <xs:element name="P_ACCOUNT"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e47925-1_P_ACCOUNT"/>
- <xs:element name="P_OSIEDLE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47926-1_P_OSIEDLE"/>
- <xs:element name="T_BUILDING_PIETRA"
- minOccurs="0"
- type="p5Type:integer"
- id="__BUILDINGS___d18e47928-1_T_BUILDING"/>
- <xs:element name="T_BUILDING_PIWNICA"
- minOccurs="0"
- default="N/S;"
- type="xs:string"
- id="__BUILDINGS___d18e47929-1_T_BUILDING"/>
- <xs:element name="T_BUILDING_KLATKI"
- minOccurs="0"
- type="p5Type:integer"
- id="__BUILDINGS___d18e47930-1_T_BUILDING"/>
- <xs:element name="T_BUILDING_MIESZKANIA"
- minOccurs="0"
- type="p5Type:integer"
- id="__BUILDINGS___d18e47931-1_T_BUILDING"/>
- <xs:element name="A_CLASSIFIED"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e47932-1_A_CLASSIFI"/>
- <xs:element name="M_LAST_STICKER_DATE"
- minOccurs="0"
- nillable="true"
- type="p5Type:date"
- id="__BUILDINGS___d18e47933-1_M_LAST_STI"/>
- <xs:element name="the_geom"
- minOccurs="0"
- nillable="true"
- type="p5Type:polygon"
- id="__BUILDINGS___d18e47934-1_the_geom"/>
- <xs:element name="SYNC_SQIX_STATUS"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e47935-1_SYNC_SQIX_"/>
- <xs:element name="gid"
- minOccurs="0"
- nillable="true"
- type="p5Type:integer"
- id="__BUILDINGS___d18e47936-1_gid"/>
- <xs:element name="T_ADDRESS_CLASS"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47937-1_T_ADDRESS_"/>
- <xs:element name="B_LINK"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47938-1_B_LINK"/>
- <xs:element name="B_URL"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47940-1_B_URL"/>
- <xs:element name="B_XYZ"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47941-1_B_XYZ"/>
- <xs:element name="B_ASCII"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:text"
- id="__BUILDINGS___d18e47942-1_B_ASCII"/>
- <xs:element name="CRM_LISTA_ZASOBOW_ID"
- minOccurs="0"
- type="p5Type:integer"
- id="__BUILDINGS___d18e47943-1_CRM_LISTA_"/>
- <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID"
- id="__BUILDINGS___d18e47944-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="CRM_LISTA_ZASOBOW_ID"
- system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID/ID"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- </xs:annotation>
- </xs:element>
- <xs:element name="etykieta_x"
- minOccurs="0"
- nillable="true"
- type="p5Type:decimal"
- id="__BUILDINGS___d18e47949-1_etykieta_x"/>
- <xs:element name="etykieta_y"
- minOccurs="0"
- nillable="true"
- type="p5Type:decimal"
- id="__BUILDINGS___d18e47950-1_etykieta_y"/>
- <xs:element name="__Rozdzielcza_Kabel_Swiatlowodowy_wsg84"
- minOccurs="0"
- nillable="true"
- type="p5Type:integer"
- id="__BUILDINGS___d18e47951-1___Rozdziel"/>
- <xs:element name="__MK_Rewiry__STATUS"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e47952-1___MK_Rewir"/>
- <xs:element name="ID_BILLING_USERS"
- minOccurs="0"
- type="p5Type:integer"
- id="__BUILDINGS___d18e47953-1_ID_BILLING"/>
- <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS"
- minOccurs="0"
- id="__BUILDINGS___d18e47954-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="ID_BILLING_USERS"
- system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- </xs:annotation>
- </xs:element>
- <xs:element name="ID_BILLING_USERS_ADMIN"
- minOccurs="0"
- type="p5Type:integer"
- id="__BUILDINGS___d18e47960-1_ID_BILLING"/>
- <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS_ADMIN"
- minOccurs="0"
- id="__BUILDINGS___d18e47961-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="ID_BILLING_USERS_ADMIN"
- system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS_ADMIN/ID"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- </xs:annotation>
- </xs:element>
- <xs:element maxOccurs="unbounded"
- minOccurs="0"
- ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING"
- id="__BUILDINGS___d18e47966-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="S_ADDRESS_STREET"
- system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING/T_TELBOX_BUILDING_IN"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- <xs:documentation>Reff- backref jest od marketingu</xs:documentation>
- </xs:annotation>
- </xs:element>
- </xs:sequence>
- </xs:restriction>
- </xs:complexContent>
- </xs:complexType>
- <xs:element name="Budynek_blok"
- type="default_db__x3A__BUILDINGS:Budynek_blok"
- id="__BUILDINGS___d18e47973-1_Budynek_bl"/>
- <xs:complexType name="Dom_jednorodz" id="__BUILDINGS___d18e47974-1_Dom_jednor">
- <xs:complexContent id="__BUILDINGS___d18e47975-1">
- <xs:restriction base="default_db__x3A__BUILDINGS:BUILDINGS">
- <xs:sequence id="__BUILDINGS___d18e47977-1">
- <xs:element name="ID" type="p5Type:integer" id="__BUILDINGS___d18e47978-1_ID"/>
- <xs:element name="geoportal_gml_punkty_adr_gml_id"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e47979-1_geoportal_"/>
- <xs:element name="TERYT_ulice"
- minOccurs="0"
- type="xs:int"
- id="__BUILDINGS___d18e47980-1_TERYT_ulic"/>
- <xs:element minOccurs="0"
- ref="default_db__x3A__TERYT_ulice:TERYT_ulice"
- id="__BUILDINGS___d18e47981-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="TERYT_ulice"
- system_cache__appinfo:xpath="default_db__x3A__TERYT_ulice:TERYT_ulice/SYM"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- <xs:documentation>Opcjonalne dowiazanie sie do jakiegos adresu i zaciagniecie z niego danych lokalne</xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:element name="A_RECORD_CREATE_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47988-1_A_RECORD_C"/>
- <xs:element name="A_RECORD_CREATE_AUTHOR"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47989-1_A_RECORD_C"/>
- <xs:element name="A_RECORD_UPDATE_DATE"
- minOccurs="0"
- type="p5Type:dateTime"
- id="__BUILDINGS___d18e47990-1_A_RECORD_U"/>
- <xs:element name="A_RECORD_UPDATE_AUTHOR"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47991-1_A_RECORD_U"/>
- <xs:element name="L_APPOITMENT_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47992-1_L_APPOITME"/>
- <xs:element name="L_APPOITMENT_USER"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e47993-1_L_APPOITME"/>
- <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
- id="__BUILDINGS___d18e47994-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="L_APPOITMENT_USER"
- system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- </xs:annotation>
- </xs:element>
- <xs:element name="L_APPOITMENT_PERIOD"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48000-1_L_APPOITME"/>
- <xs:element name="L_APPOITMENT_INFO"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48001-1_L_APPOITME"/>
- <xs:element name="A_PROBLEM_DESC"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48002-1_A_PROBLEM_"/>
- <xs:element name="A_PROBLEM_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48003-1_A_PROBLEM_"/>
- <xs:element name="A_STATUS"
- minOccurs="0"
- nillable="true"
- default="MONITOR"
- type="default_db__x3A__BUILDINGS:A_STATUS_Type"
- id="__BUILDINGS___d18e48004-1_A_STATUS"/>
- <xs:element name="A_STATUS_INFO"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48005-1_A_STATUS_I"/>
- <xs:element name="A_STATUS_LASTCHANGE_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48006-1_A_STATUS_L"/>
- <xs:element name="A_UPDATE_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48007-1_A_UPDATE_D"/>
- <xs:element name="A_ADM_COMPANY"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48008-1_A_ADM_COMP"/>
- <xs:element name="S_ADMIN_NAME"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48009-1_S_ADMIN_NA"/>
- <xs:element name="S_ADDRESS_CITY"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48010-1_S_ADDRESS_"/>
- <xs:element name="S_ADDRESS_POST_CODE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48012-1_S_ADDRESS_"/>
- <xs:element name="S_ADDRESS_POST_OFFICE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48013-1_S_ADDRESS_"/>
- <xs:element name="S_ADDRESS_STREET"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48014-1_S_ADDRESS_"/>
- <xs:element name="S_ADDRESS_STREET_FULL"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e48015-1_S_ADDRESS_"/>
- <xs:element name="S_ADDRESS_HOUSE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48016-1_S_ADDRESS_"/>
- <xs:element name="S_OTHER_INFO"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48017-1_S_OTHER_IN"/>
- <xs:element name="P_ADMIN_NAME"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48018-1_P_ADMIN_NA"/>
- <xs:element name="P_ADDRESS_CITY"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48019-1_P_ADDRESS_"/>
- <xs:element name="P_ADDRESS_POST_CODE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48020-1_P_ADDRESS_"/>
- <xs:element name="P_ADDRESS_POST_OFFICE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48021-1_P_ADDRESS_"/>
- <xs:element name="P_ADDRESS_STREET"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48022-1_P_ADDRESS_"/>
- <xs:element name="P_ADDRESS_HOUSE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48024-1_P_ADDRESS_"/>
- <xs:element name="P_OTHER_INFO"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48025-1_P_OTHER_IN"/>
- <xs:element name="P_DEAL_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48026-1_P_DEAL_DAT"/>
- <xs:element name="P_DEALNUMBER"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48027-1_P_DEALNUMB"/>
- <xs:element name="P_DEALEXPIRE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48028-1_P_DEALEXPI"/>
- <xs:element name="P_DEAL_DETAIL"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48029-1_P_DEAL_DET"/>
- <xs:element name="P_DEAL_LOCATION"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48030-1_P_DEAL_LOC"/>
- <xs:element name="T_NETWORK_SERVER"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48031-1_T_NETWORK_"/>
- <xs:element name="T_TOPOLOGY_PLACE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48032-1_T_TOPOLOGY"/>
- <xs:element name="T_BUILDING_SAVE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48033-1_T_BUILDING"/>
- <xs:element name="T_BUILDING_POWER"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48034-1_T_BUILDING"/>
- <xs:element name="T_INSTALACJA_W_CIAGU_DNI"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48036-1_T_INSTALAC"/>
- <xs:element name="T_WORKPOINTS"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e48037-1_T_WORKPOIN"/>
- <xs:element name="T_WORKPOINTS_VALUE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48038-1_T_WORKPOIN"/>
- <xs:element name="T_WORKPOINTS_USER"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48039-1_T_WORKPOIN"/>
- <xs:element name="T_WORKPOINTS_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48040-1_T_WORKPOIN"/>
- <xs:element name="T_WHO_CONNECTED"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48041-1_T_WHO_CONN"/>
- <xs:element name="T_WHEN_CONNECTED"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48042-1_T_WHEN_CON"/>
- <xs:element name="T_LAN_KONKURENCJA_OPER"
- minOccurs="0"
- nillable="true"
- type="default_db__x3A__BUILDINGS:T_LAN_KONKURENCJA_OPER_Type"
- id="__BUILDINGS___d18e48043-1_T_LAN_KONK"/>
- <xs:element name="B_INVENTORY_DATE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48044-1_B_INVENTOR"/>
- <xs:element name="M_ZRYWKA_DATE"
- minOccurs="0"
- nillable="true"
- type="p5Type:date"
- id="__BUILDINGS___d18e48045-1_M_ZRYWKA_D"/>
- <xs:element name="M_ZRYWKA_NUMBER"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48046-1_M_ZRYWKA_N"/>
- <xs:element name="M_REWIR"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48048-1_M_REWIR"/>
- <xs:element ref="default_db__x3A__MK_Rewiry:MK_Rewiry"
- id="__BUILDINGS___d18e48049-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="M_REWIR"
- system_cache__appinfo:xpath="default_db__x3A__MK_Rewiry:MK_Rewiry/NAZWA_REWI"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- <xs:documentation>
- TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #4122 !!!
- </xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:element name="M_PARAMETRY"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48056-1_M_PARAMETR"/>
- <xs:element name="M_DIRECT_MARKETING_DATE"
- minOccurs="0"
- nillable="true"
- type="p5Type:date"
- id="__BUILDINGS___d18e48057-1_M_DIRECT_M"/>
- <xs:element name="M_DATA_ZASIEDLENIA"
- minOccurs="0"
- nillable="true"
- type="p5Type:date"
- id="__BUILDINGS___d18e48058-1_M_DATA_ZAS"/>
- <xs:element name="ID_PROJECT"
- minOccurs="0"
- nillable="true"
- type="p5Type:integer"
- id="__BUILDINGS___d18e48059-1_ID_PROJECT"/>
- <xs:element ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT"
- id="__BUILDINGS___d18e48060-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="ID_PROJECT"
- system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT/ID"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- </xs:annotation>
- </xs:element>
- <xs:element name="path"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48065-1_path"/>
- <xs:element name="P_NR_DZIALKI"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48066-1_P_NR_DZIAL"/>
- <xs:element name="P_NR_KW"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48067-1_P_NR_KW"/>
- <xs:element name="P_OTHER_DOC"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48068-1_P_OTHER_DO"/>
- <xs:element name="P_PESEL"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48070-1_P_PESEL"/>
- <xs:element name="P_KRS"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48071-1_P_KRS"/>
- <xs:element name="P_ADDRESS"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48072-1_P_ADDRESS"/>
- <xs:element name="P_NAME"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48073-1_P_NAME"/>
- <xs:element name="P_ACCOUNT"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e48074-1_P_ACCOUNT"/>
- <xs:element name="P_OSIEDLE"
- minOccurs="0"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48075-1_P_OSIEDLE"/>
- <xs:element name="T_BUILDING_PIETRA"
- minOccurs="0"
- type="p5Type:integer"
- id="__BUILDINGS___d18e48076-1_T_BUILDING"/>
- <xs:element name="T_BUILDING_KLATKI"
- minOccurs="0"
- type="p5Type:integer"
- id="__BUILDINGS___d18e48077-1_T_BUILDING"/>
- <xs:element name="T_BUILDING_MIESZKANIA"
- minOccurs="0"
- type="p5Type:integer"
- id="__BUILDINGS___d18e48078-1_T_BUILDING"/>
- <xs:element name="A_CLASSIFIED"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e48079-1_A_CLASSIFI"/>
- <xs:element name="M_LAST_STICKER_DATE"
- minOccurs="0"
- nillable="true"
- type="p5Type:date"
- id="__BUILDINGS___d18e48080-1_M_LAST_STI"/>
- <xs:element name="the_geom"
- minOccurs="0"
- nillable="true"
- type="p5Type:polygon"
- id="__BUILDINGS___d18e48082-1_the_geom"/>
- <xs:element name="SYNC_SQIX_STATUS"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e48083-1_SYNC_SQIX_"/>
- <xs:element name="gid"
- minOccurs="0"
- nillable="true"
- type="p5Type:integer"
- id="__BUILDINGS___d18e48084-1_gid"/>
- <xs:element name="T_ADDRESS_CLASS"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48085-1_T_ADDRESS_"/>
- <xs:element name="B_LINK"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48086-1_B_LINK"/>
- <xs:element name="B_URL"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48087-1_B_URL"/>
- <xs:element name="B_XYZ"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:string"
- id="__BUILDINGS___d18e48088-1_B_XYZ"/>
- <xs:element name="B_ASCII"
- minOccurs="0"
- nillable="true"
- default=""
- type="p5Type:text"
- id="__BUILDINGS___d18e48089-1_B_ASCII"/>
- <xs:element name="CRM_LISTA_ZASOBOW_ID"
- minOccurs="0"
- type="p5Type:integer"
- id="__BUILDINGS___d18e48090-1_CRM_LISTA_"/>
- <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID"
- id="__BUILDINGS___d18e48091-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="CRM_LISTA_ZASOBOW_ID"
- system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID/ID"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- </xs:annotation>
- </xs:element>
- <xs:element name="etykieta_x"
- minOccurs="0"
- nillable="true"
- type="p5Type:decimal"
- id="__BUILDINGS___d18e48096-1_etykieta_x"/>
- <xs:element name="etykieta_y"
- minOccurs="0"
- nillable="true"
- type="p5Type:decimal"
- id="__BUILDINGS___d18e48098-1_etykieta_y"/>
- <xs:element name="__Rozdzielcza_Kabel_Swiatlowodowy_wsg84"
- minOccurs="0"
- nillable="true"
- type="p5Type:integer"
- id="__BUILDINGS___d18e48099-1___Rozdziel"/>
- <xs:element name="__MK_Rewiry__STATUS"
- minOccurs="0"
- type="p5Type:string"
- id="__BUILDINGS___d18e48100-1___MK_Rewir"/>
- <xs:element name="ID_BILLING_USERS"
- minOccurs="0"
- type="p5Type:integer"
- id="__BUILDINGS___d18e48101-1_ID_BILLING"/>
- <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS"
- minOccurs="0"
- id="__BUILDINGS___d18e48102-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="ID_BILLING_USERS"
- system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- </xs:annotation>
- </xs:element>
- <xs:element name="ID_BILLING_USERS_ADMIN"
- minOccurs="0"
- type="p5Type:integer"
- id="__BUILDINGS___d18e48107-1_ID_BILLING"/>
- <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS_ADMIN"
- minOccurs="0"
- id="__BUILDINGS___d18e48108-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="ID_BILLING_USERS_ADMIN"
- system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS_ADMIN/ID"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- </xs:annotation>
- </xs:element>
- <xs:element maxOccurs="unbounded"
- minOccurs="0"
- ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING"
- id="__BUILDINGS___d18e48113-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache>
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
- system_cache__appinfo:name="S_ADDRESS_STREET"
- system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING/T_TELBOX_BUILDING_IN"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- <xs:documentation>Reff- backref jest od marketingu</xs:documentation>
- </xs:annotation>
- </xs:element>
- </xs:sequence>
- </xs:restriction>
- </xs:complexContent>
- </xs:complexType>
- <xs:simpleType name="T_WORKPOINTS_TYPE_Type" id="__BUILDINGS___d18e48120-1_T_WORKPOIN">
- <xs:restriction base="p5Type:string"><!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value="OTHER"/>
- <xs:enumeration value="GUARANTY_SERVICE"/>
- <xs:enumeration value="ADMIN_AT_WORK"/>
- <xs:enumeration value="TECH_AT_DUTY"/>
- <xs:enumeration value="TECH_AT_CONTRACT"/>
- </xs:restriction>
- </xs:simpleType>
- <xs:simpleType name="T_BUILDING_TYPE_Type" id="__BUILDINGS___d18e48128-1_T_BUILDING">
- <xs:restriction base="p5Type:string"><!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value="N/S;"/>
- <xs:enumeration value="Domek_Jednorodzin."/>
- <xs:enumeration value="Domek_Wielorodz."/>
- <xs:enumeration value="Blok_Wielorodz"/>
- <xs:enumeration value="Obiekt_jedna_firma"/>
- <xs:enumeration value="Obiekt_wiele_firm"/>
- </xs:restriction>
- </xs:simpleType>
- <xs:simpleType name="T_LAN_KONKURENCJA_OPER_Type"
- id="__BUILDINGS___d18e48137-1_T_LAN_KONK">
- <xs:restriction base="p5Type:string"><!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value="NIEWIADOMO"/>
- <xs:enumeration value="BRAK"/>
- <xs:enumeration value="JEST"/>
- <xs:enumeration value="MA BYC"/>
- </xs:restriction>
- </xs:simpleType>
- <xs:simpleType name="A_STATUS_Type" id="__BUILDINGS___d18e48144-1_A_STATUS_T">
- <xs:restriction base="p5Type:string">
- <xs:enumeration value="WAITING"/>
- <xs:enumeration value="NORMAL"/>
- <xs:enumeration value="MONITOR"/>
- <xs:enumeration value="WARNING"/>
- <xs:enumeration value="OFF"/>
- <xs:enumeration value="TO_OFF"/>
- <xs:enumeration value="DELETED"/>
- <xs:enumeration value="OFF_SOFT"/>
- <xs:enumeration value="OFF_HARD"/>
- </xs:restriction>
- </xs:simpleType>
- <xs:element name="Dom_jednorodz"
- type="default_db__x3A__BUILDINGS:Dom_jednorodz"
- id="__BUILDINGS___d18e48155-1_Dom_jednor"/>
- <xs:element name="T_TELBOX_BUILDING_IN"
- type="default_db__x3A__BUILDINGS:BUILDINGS"
- id="__BUILDINGS___d18e48156-1_T_TELBOX_B"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:documentation>W telboxes uzywany do budowania struktury</xs:documentation>
- </xs:annotation>
- </xs:element>
- </xs:schema>
|