xml schema转换成数据库

[大石头1987]

有如下所示的复杂xml scheme

<?xml version="1.0" encoding="gb2312"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:element name="SFIS-ISN">
    <xs:complexType>
      <xs:sequence>
        <xs:element name="MSGTYPE" type="xs:string" />
        <xs:element name="MSGDATE" type="xs:unsignedLong" />
        <xs:element name="MSGID" type="xs:unsignedLong" />
        <xs:element name="SENDID" type="xs:string" />
        <xs:element name="RECEID" type="xs:string" />
        <xs:element maxOccurs="unbounded" name="MASTER">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DOCID" type="xs:unsignedLong" />
              <xs:element name="DOCDATETIME" type="xs:unsignedLong" />
              <xs:element name="VENDOR_TYPE" type="xs:string" />
              <xs:element name="VENDOR_ID" type="xs:string" />
              <xs:element name="BU" type="xs:string" />
              <xs:element name="ISN" type="xs:string" />
              <xs:element name="ORI_ISN" type="xs:string" />
              <xs:element name="SSN" type="xs:string" />
              <xs:element name="ASUS_PN" type="xs:string" />
              <xs:element name="PO_NO" type="xs:string" />
              <xs:element name="PO_LINE" type="xs:unsignedByte" />
              <xs:element name="ORDER_QTY" type="xs:unsignedByte" />
              <xs:element name="SHIP_QTY" type="xs:unsignedByte" />
              <xs:element name="SHIP_DATE" type="xs:unsignedInt" />
              <xs:element name="PALLET_ID" type="xs:string" />
              <xs:element name="PALLET_NO" type="xs:unsignedByte" />
              <xs:element name="PALLET_NW" type="xs:decimal" />
              <xs:element name="PALLET_GW" type="xs:decimal" />
              <xs:element name="CARTON_ID" type="xs:unsignedByte" />
              <xs:element name="CARTON_NW" type="xs:decimal" />
              <xs:element name="CARTON_GW" type="xs:decimal" />
              <xs:element name="BOX_QTY" type="xs:unsignedByte" />
              <xs:element name="DOA" type="xs:string" />
              <xs:element maxOccurs="unbounded" name="ISN_DETAIL">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element maxOccurs="unbounded" name="KPSN_DETAIL">
                      <xs:complexType>
                        <xs:attribute name="TYPE" type="xs:string" use="required" />
                        <xs:attribute name="SEQ" type="xs:unsignedByte" use="required" />
                        <xs:attribute name="VALUE" type="xs:string" use="required" />
                        <xs:attribute name="PROPERTY" type="xs:string" use="required" />
                        <xs:attribute name="DATE" type="xs:string" use="required" />
                      </xs:complexType>
                    </xs:element>
                  </xs:sequence>
                  <xs:attribute name="TYPE" type="xs:string" use="required" />
                  <xs:attribute name="SEQ" type="xs:unsignedByte" use="required" />
                  <xs:attribute name="VALUE" type="xs:string" use="required" />
                  <xs:attribute name="PROPERTY" type="xs:string" use="required" />
                  <xs:attribute name="DATE" type="xs:string" use="required" />
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
</xs:schema>

如何才能设计数据库，将xml中每个元素都设为表的字段？
我现在是建四个表，SFIS-ISN、MASTER、ISN_DETAIL和KPSN_DETAIL，但是怎么才能建立表之间的联系？