BulkLoad in multiple tables - How to write the annotations?

My Problem: I have to import XML-Files into a complex SQlServer-DB (20
Tables,m2n-relations) via XML Bulkload.
The annotations in the Mapping-Scheme looks like:
--
<sql:relationship name="RLS_LUN" parent="RLS" parent-key="RLS_ID"
child="LUN" child-key="RLS_ID"/>
--
The elements (tablenames) are annotated with:
<xs:element name="LUN" sql:relation="LUN" sql:relationship="RLS_LUN">
--
At executing the Script for Bulkload the following error message appears:
--
Schema: the parent/child table of the relationship on 'DPI' does not match.
--
Some facts:
The tablefields are attributes.
The tables have IDs as identity-columns (must add them as attribute?)
What and where is the problem?
It would be very nice, if someone could help me, it′s important for me,
thank you in advanceThe error you received indicates that the parent and child relations in
your sql:relationship are inconsistent with the relations defined on the
parent and child sides of the relationship.
In addition, the error specifies a relationship not included in your
orginal post (DPI). Posting the entire mapping schema would probably help.
Andrew Conrad
Microsoft Corp|||Now my updated schema (still not working, but why?!?!?):
<?xml version="1.0" encoding="UTF-8"?>
<!-- edited with XMLSpy v2005 sp1 U (http://www.xmlspy.com) by Schlagl
Susanne (-) -->
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema"
xmlns:dt="urn:schemas-microsoft-com:datatypes" elementFormDefault="qualified
"
attributeFormDefault="unqualified">
<xs:annotation>
<xs:appinfo>
<sql:relationship name="IPI_ISR" parent="IPI" parent-key="IPI_ID"
child="ISR" child-key="IPI_ID"/>
<sql:relationship name="Node_PPI" parent="Node" parent-key="Node_ID"
child="PPI" child-key="Node_ID"/>
<sql:relationship name="PPI_PTT" parent="PPI" parent-key="PPI_ID"
child="PTT" child-key="PPI_ID"/>
<sql:relationship name="PPI_DPT" parent="PPI" parent-key="PPI_ID"
child="DPT" child-key="PPI_ID"/>
<sql:relationship name="Node_ZPI" parent="Node" parent-key="Node_ID"
child="ZPI" child-key="Node_ID"/>
<sql:relationship name="ZPI_DOT" parent="ZPI" parent-key="ZPI_ID"
child="DOT" child-key="ZPI_ID"/>
<sql:relationship name="Node_ORS" parent="Node" parent-key="Node_ID"
child="ORS" child-key="Node_ID"/>
<sql:relationship name="Node_IDS" parent="Node" parent-key="Node_ID"
child="IDS" child-key="Node_ID"/>
<sql:relationship name="IDS_IBS" parent="IDS" parent-key="IDS_ID"
child="IBS" child-key="IDS_ID"/>
<sql:relationship name="Node_RLS" parent="Node" parent-key="Node_ID"
child="RLS" child-key="Node_ID"/>
<sql:relationship name="RLS_LUN" parent="RLS" parent-key="RLS_ID"
child="LUN" child-key="RLS_ID"/>
<sql:relationship name="Node_ORH" parent="Node" parent-key="Node_ID"
child="ORH" child-key="Node_ID"/>
<sql:relationship name="ORH_RHC" parent="ORH" parent-key="ORH_ID"
child="RHC" child-key="ORH_ID"/>
<sql:relationship name="Node_SDS" parent="Node" parent-key="Node_ID"
child="SDS" child-key="Node_ID"/>
<sql:relationship name="Node_ORB" parent="Node" parent-key="Node_ID"
child="ORB" child-key="Node_ID"/>
<sql:relationship name="ORB_RBL" parent="ORB" parent-key="ORB_ID"
child="RBL" child-key="ORB_ID"/>
<sql:relationship name="Node_SST" parent="Node" parent-key="Node_ID"
child="SST" child-key="Node_ID"/>
<sql:relationship name="Node_PSI" parent="Node" parent-key="Node_ID"
child="PSI" child-key="Node_ID"/>
<sql:relationship name="PSI_PRS" parent="PSI" parent-key="PSI_ID"
child="PRS" child-key="PSI_ID"/>
<sql:relationship name="Node_OPS" parent="Node" parent-key="Node_ID"
child="OPS" child-key="Node_ID"/>
<sql:relationship name="OPS_PSR" parent="OPS" parent-key="OPS_ID"
child="PSR" child-key="OPS_ID"/>
<sql:relationship name="Node_LFS" parent="Node" parent-key="Node_ID"
child="LFS" child-key="Node_ID"/>
<sql:relationship name="LFS_ILF" parent="LFS" parent-key="LFS_ID"
child="ILF" child-key="LFS_ID"/>
<sql:relationship name="ILF_LFA" parent="ILF" parent-key="ILF_ID"
child="LFA" child-key="ILF_ID"/>
</xs:appinfo>
</xs:annotation>
<xs:element name="SPR" sql:is-constant="1">
<xs:complexType>
<xs:sequence>
<xs:element name="NODE" sql:relation="NODE">
<xs:complexType>
<xs:sequence>
<xs:element name="DPI" sql:relation="DPI">
<xs:annotation>
<xs:appinfo>
<sql:relationship parent="Node" parent-key="Node_ID" child="DPI"
child-key="Node_ID"/>
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:sequence>
<xs:element name="AQS" sql:relation="AQS">
<xs:annotation>
<xs:appinfo>
<sql:relationship parent="DPI" parent-key="DPI_ID" child="AQS"
child-key="DPI_ID"/>
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:attribute name="rqt" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="rtc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="rqs" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="AQS_ID" type="xs:integer" use="optional"/>
<xs:attribute name="DPI_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="OPI" sql:relation="OPI">
<xs:annotation>
<xs:appinfo>
<sql:relationship parent="DPI" parent-key="DPI_ID" child="OPI"
child-key="DPI_ID"/>
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:attribute name="did" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="odc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="OPI_ID" type="xs:integer" use="optional"/>
<xs:attribute name="DPI_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="OVE" sql:relation="OVE">
<xs:annotation>
<xs:appinfo>
<sql:relationship parent="DPI" parent-key="DPI_ID" child="OVE"
child-key="DPI_ID"/>
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:attribute name="vid" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="vck" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="arn" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="vst" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="srq" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="dck" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="OVE_ID" type="xs:integer" use="optional"/>
<xs:attribute name="DPI_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="TSQ" sql:relation="TSQ">
<xs:annotation>
<xs:appinfo>
<sql:relationship parent="DPI" parent-key="DPI_ID" child="TSQ"
child-key="DPI_ID"/>
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:attribute name="xsc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="xst" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="dsk" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="dsi" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="TSQ_ID" type="xs:integer" use="optional"/>
<xs:attribute name="DPI_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="CPQ" sql:relation="CPQ">
<xs:annotation>
<xs:appinfo>
<sql:relationship parent="DPI" parent-key="DPI_ID" child="CPQ"
child-key="DPI_ID"/>
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:attribute name="fci" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="fsc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="fps" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="CPQ_ID" type="xs:integer" use="optional"/>
<xs:attribute name="DPI_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="WLQ" sql:relation="WLQ">
<xs:annotation>
<xs:appinfo>
<sql:relationship parent="DPI" parent-key="DPI_ID" child="WLQ"
child-key="DPI_ID"/>
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:attribute name="wrc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="wrt" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="wrs" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="WLQ_ID" type="xs:integer" use="optional"/>
<xs:attribute name="DPI_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="BLQ" sql:relation="BLQ">
<xs:annotation>
<xs:appinfo>
<sql:relationship parent="DPI" parent-key="DPI_ID" child="BLQ"
child-key="DPI_ID"/>
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:attribute name="ect" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="bec" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="cid" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="BLQ_ID" type="xs:integer" use="optional"/>
<xs:attribute name="DPI_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="EXL" sql:relation="EXL">
<xs:annotation>
<xs:appinfo>
<sql:relationship parent="DPI" parent-key="DPI_ID" child="EXL"
child-key="DPI_ID"/>
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:attribute name="nxl" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="EXL_ID" type="xs:integer" use="optional"/>
<xs:attribute name="DPI_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="DPI_ID" type="xs:integer" use="optional"/>
<xs:attribute name="Node_ID" type="xs:integer" use="optional"/>
<xs:attribute name="tsqc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="ovec" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="blqc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="opic" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="dpt" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="wlqc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="exlc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="cpqc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="aqsc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
</xs:complexType>
</xs:element>
<xs:element name="IPI" sql:relation="IPI">
<xs:annotation>
<xs:appinfo>
<sql:relationship parent="Node" parent-key="Node_ID" child="IPI"
child-key="Node_ID"/>
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:sequence>
<xs:element name="ISR" sql:relation="ISR"
sql:relationship="IPI_ISR">
<xs:complexType>
<xs:attribute name="iss" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="itt" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="ihp" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="ipu" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="iku" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="itn" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="ISR_ID" type="xs:integer" use="optional"/>
<xs:attribute name="IPI_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="iht" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="IPI_ID" type="xs:integer" use="optional"/>
<xs:attribute name="Node_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="PPI" sql:relation="PPI" sql:relationship="Node_PPI">
<xs:complexType>
<xs:sequence>
<xs:element name="DPT" sql:relation="DPT"
sql:relationship="PPI_DPT">
<xs:complexType>
<xs:attribute name="lst" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="pnm" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="tts" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="lsp" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="pok" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="DPT_ID" type="xs:integer" use="optional"/>
<xs:attribute name="PPI_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="PTT" sql:relation="PTT"
sql:relationship="PPI_PTT">
<xs:complexType>
<xs:attribute name="PTT_ID" type="xs:string" use="optional"/>
<xs:attribute name="PPI_ID" type="xs:string" use="optional"/>
<xs:attribute name="xus" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="xnm" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="xok" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="sts" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="xnt" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="dkt" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="PPI_ID" type="xs:integer" use="optional"/>
<xs:attribute name="Node_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="ZPI" sql:relation="ZPI" sql:relationship="Node_ZPI">
<xs:complexType>
<xs:sequence>
<xs:element name="DOT" sql:relation="DOT"
sql:relationship="ZPI_DOT">
<xs:complexType>
<xs:attribute name="ook" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="ons" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="osp" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="onm" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="sts" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="ost" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="DOT_ID" type="xs:integer" use="optional"/>
<xs:attribute name="ZPI_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="okt" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="ZPI_ID" type="xs:integer" use="optional"/>
<xs:attribute name="Node_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="ORS" sql:relation="ORS" sql:relationship="Node_ORS">
<xs:complexType>
<xs:sequence>
<xs:element name="ARD" sql:relation="ARD">
<xs:annotation>
<xs:appinfo>
<sql:relationship parent="ORS" parent-key="ORS_ID" child="ARD"
child-key="ORS_ID"/>
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:attribute name="sid" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="lns" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="mid" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="lds" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="ARD_ID" type="xs:integer" use="optional"/>
<xs:attribute name="ORS_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="rsc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="ORS_ID" type="xs:integer" use="optional"/>
<xs:attribute name="Node_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="IDS" sql:relation="IDS" sql:relationship="Node_IDS">
<xs:complexType>
<xs:sequence>
<xs:element name="IBS" sql:relation="IBS"
sql:relationship="IDS_IBS">
<xs:complexType>
<xs:attribute name="bus" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="bkw" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="IDS_ID" type="xs:integer" use="optional"/>
<xs:attribute name="IBS_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="IDS_ID" type="xs:integer" use="optional"/>
<xs:attribute name="IBS_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="RLS" sql:relation="RLS" sql:relationship="Node_RLS">
<xs:complexType>
<xs:sequence>
<xs:element name="LUN" sql:relation="LUN"
sql:relationship="RLS_LUN">
<xs:complexType>
<xs:attribute name="lkw" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="lnm" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="LUN_ID" type="xs:integer" use="optional"/>
<xs:attribute name="RLS_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="RLS_ID" type="xs:integer" use="optional"/>
<xs:attribute name="Node_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="ORH" sql:relation="ORH" sql:relationship="Node_ORH">
<xs:complexType>
<xs:sequence>
<xs:element name="RHC" sql:relation="RHC"
sql:relationship="ORH_RHC">
<xs:complexType>
<xs:attribute name="shn" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="rsc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="rst" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="RHC_ID" type="xs:integer" use="optional"/>
<xs:attribute name="ORH_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="ORH_ID" type="xs:integer" use="optional"/>
<xs:attribute name="Node_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="SDS" sql:relation="SDS" sql:relationship="Node_SDS">
<xs:complexType>
<xs:attribute name="ddt" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="sdc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="dsc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="sds" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="SDS_ID" type="xs:integer" use="optional"/>
<xs:attribute name="Node_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="ORB" sql:relation="ORB" sql:relationship="Node_ORB">
<xs:complexType>
<xs:sequence>
<xs:element name="RBL" sql:relation="RBL"
sql:relationship="ORB_RBL">
<xs:complexType>
<xs:attribute name="rxd" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="rmd" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="rdc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="blc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="RBL_ID" type="xs:integer" use="optional"/>
<xs:attribute name="ORB_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="rbc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="ORB_ID" type="xs:integer" use="optional"/>
<xs:attribute name="Node_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="SST" sql:relation="SST" sql:relationship="Node_SST">
<xs:complexType>
<xs:attribute name="ssc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="SST_ID" type="xs:integer" use="optional"/>
<xs:attribute name="Node_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="PSI" sql:relation="PSI" sql:relationship="Node_PSI">
<xs:complexType>
<xs:sequence>
<xs:element name="PRS" sql:relation="PRS"
sql:relationship="PSI_PRS">
<xs:complexType>
<xs:attribute name="apb" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="mtp" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="pfs" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="cap" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="tps" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="upb" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="prc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="PRS_ID" type="xs:integer" use="optional"/>
<xs:attribute name="PSI_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="psc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="PSI_ID" type="xs:integer" use="optional"/>
<xs:attribute name="Node_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="OPS" sql:relation="OPS" sql:relationship="Node_OPS">
<xs:complexType>
<xs:sequence>
<xs:element name="PSR" sql:relation="PSR"
sql:relationship="OPS_PSR">
<xs:complexType>
<xs:attribute name="PSR_ID" type="xs:integer" use="optional"/>
<xs:attribute name="OPS_ID" type="xs:integer" use="optional"/>
<xs:attribute name="psc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="psrc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="pnm" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="pkw" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="psc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="OPS_ID" type="xs:integer" use="optional"/>
<xs:attribute name="Node_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="LFS" sql:relation="LFS" sql:relationship="Node_LFS">
<xs:complexType>
<xs:sequence>
<xs:element name="ILF" sql:relation="ILF"
sql:relationship="LFS_ILF">
<xs:complexType>
<xs:sequence>
<xs:element name="LFA" sql:relation="LFA"
sql:relationship="ILF_LFA">
<xs:complexType>
<xs:attribute name="aec" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="txt" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="LFA_ID" type="xs:integer" use="optional"/>
<xs:attribute name="ILF_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="lfp" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="lfn" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="lkw" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="ilc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="ILF_ID" type="xs:integer" use="optional"/>
<xs:attribute name="LFS_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="lsc" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="LFS_ID" type="xs:integer" use="optional"/>
<xs:attribute name="Node_ID" type="xs:integer" use="optional"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="nty" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="rdt" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="sid" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="snm" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="lrd" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="rtm" type="xs:string" use="required"
sql:datatype="nvarchar(255)"/>
<xs:attribute name="Node_ID" type="xs:string" use="optional"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>