首页 新闻 会员 周边 捐助

xsd文件怎样生成数据库啊

0
悬赏园豆:30 [已解决问题] 解决于 2014-12-05 16:01

<?xml version="1.0" encoding="UTF-8"?>
<!-- 编辑使用 XMLSpy v2005 发行版 3 U (http://www.altova.com) 由 any (any) -->
<!-- 编辑使用 XMLSpy v2005 发行版 3 U (http://www.altova.com) 由 any (any) -->
<!-- 编辑使用 XMLSpy v2005 发行版 3 U (http://www.altova.com) 由 any (any) -->
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified">
<xs:include schemaLocation="Enums.xsd"/>
<xs:attributeGroup name="Test_BasicInfo">
<xs:annotation>
<xs:documentation>试验基本信息</xs:documentation>
</xs:annotation>
<xs:attribute name="TestID" type="xs:string" use="required"/>
<xs:attribute name="AcquisitionTime" type="xs:dateTime" use="required"/>
<xs:attribute name="Temperature" type="xs:float"/>
<xs:attribute name="Humidity" type="xs:float"/>
<xs:attribute name="OilTemperature" type="xs:float"/>
<xs:attribute name="TestProperty" type="TestPropertiesEnum"/>
<xs:attribute name="Remark" type="xs:int" use="required"/>
</xs:attributeGroup>
<xs:complexType name="Transformer_PhysicalAttrType">
<xs:annotation>
<xs:documentation>变压器台账类型</xs:documentation>
</xs:annotation>
<xs:sequence>
<xs:element name="DeviceCode" nillable="true">
<xs:annotation>
<xs:documentation>设备ID</xs:documentation>
</xs:annotation>
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="17"/>
<xs:minLength value="0"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="VoltageLevel" type="VoltageLevelEnum" nillable="true">
<xs:annotation>
<xs:documentation>电压等级</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="Phase" type="PhaseEnum" nillable="true">
<xs:annotation>
<xs:documentation>相别</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="Sbxh" type="xs:string" minOccurs="0">
<xs:annotation>
<xs:documentation>设备型号</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="Zzcj" type="xs:string" minOccurs="0">
<xs:annotation>
<xs:documentation>制造厂家</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="Ccbh" type="xs:string" minOccurs="0">
<xs:annotation>
<xs:documentation>出厂编号</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="Cpdh" type="xs:string" minOccurs="0">
<xs:annotation>
<xs:documentation>产品代号</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="Zzgj" type="xs:string" minOccurs="0">
<xs:annotation>
<xs:documentation>制造国家</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="Ccrq" type="xs:dateTime" minOccurs="0">
<xs:annotation>
<xs:documentation>出厂日期</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="TYRQ1" type="xs:dateTime" minOccurs="0">
<xs:annotation>
<xs:documentation>投运日期</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="Syhj" type="xs:string" minOccurs="0">
<xs:annotation>
<xs:documentation>使用环境</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="Jysp" type="InsulationLevelEnum" minOccurs="0">
<xs:annotation>
<xs:documentation>绝缘水平</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="YT" type="Transformer_TransPurposeEnum" minOccurs="0">
<xs:annotation>
<xs:documentation>用途</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="XS" type="xs:int" minOccurs="0">
<xs:annotation>
<xs:documentation>相数</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="Jyjz" type="InsulationMediumEnum" minOccurs="0">
<xs:annotation>
<xs:documentation>绝缘介质</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="Rzxs" type="WindingFeatureEnum" minOccurs="0">
<xs:annotation>
<xs:documentation>绕组型式</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="Jgxs" type="StructureFeatureEnum" minOccurs="0">
<xs:annotation>
<xs:documentation>结构型式</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="Lqfs" type="CoolingMethodEnum" minOccurs="0">
<xs:annotation>
<xs:documentation>冷却方式</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="Tyfs" type="VoltageRegulatingModeEnum" minOccurs="0">
<xs:annotation>
<xs:documentation>调压方式</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="Yxfjwz" type="xs:string" minOccurs="0">
<xs:annotation>
<xs:documentation>运行分接位置</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="Zxfjwz" type="xs:string" minOccurs="0">
<xs:annotation>
<xs:documentation>最小分接位置</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="Zdfjwz" type="xs:string" minOccurs="0">
<xs:annotation>
<xs:documentation>最大分接位置</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="Eddy" minOccurs="0">
<xs:annotation>
<xs:documentation>额定电压</xs:documentation>
</xs:annotation>
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="DataUnit" type="DataUnitEnum" default="kV"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="Edrl" minOccurs="0">
<xs:annotation>
<xs:documentation>额定容量</xs:documentation>
</xs:annotation>
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="DataUnit" type="DataUnitEnum" default="kVA"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="Zlqrl" type="xs:string" minOccurs="0">
<xs:annotation>
<xs:documentation>自冷却容量</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="Dyb" type="xs:string" minOccurs="0">
<xs:annotation>
<xs:documentation>电压比</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="Edpl" default="50" minOccurs="0">
<xs:annotation>
<xs:documentation>额定频率,单位为Hz</xs:documentation>
</xs:annotation>
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:short">
<xs:attribute name="DataUnit" type="DataUnitEnum" default="Hz"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="Ljzbh" type="xs:string" minOccurs="0">
<xs:annotation>
<xs:documentation>联结组标号</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="YZ" minOccurs="0">
<xs:annotation>
<xs:documentation>油重</xs:documentation>
</xs:annotation>
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:float">
<xs:attribute name="DataUnit" type="DataUnitEnum" default="T"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="Ymws" minOccurs="0">
<xs:annotation>
<xs:documentation>油面温升</xs:documentation>
</xs:annotation>
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="DataUnit" type="DataUnitEnum" default="K"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
<xs:complexType name="Transformer_BelongsAttrType">
<xs:annotation>
<xs:documentation>变压器隶属信息数据类型</xs:documentation>
</xs:annotation>
<xs:sequence>
<xs:element name="BelongsCompany" type="xs:string" minOccurs="0">
<xs:annotation>
<xs:documentation>所属省公司</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="BelongsMunicipalCorp" type="xs:string" minOccurs="0">
<xs:annotation>
<xs:documentation>所属市公司</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="BelongsSubstation" minOccurs="0">
<xs:annotation>
<xs:documentation>所属变电站</xs:documentation>
</xs:annotation>
<xs:complexType>
<xs:sequence>
<xs:element name="Sub_ID" type="xs:string"/>
<xs:element name="Sub_Name" type="xs:string" minOccurs="0"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AccestClass" type="Transformer_AssetClassEnum" minOccurs="0">
<xs:annotation>
<xs:documentation>资产所属级别</xs:documentation>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:schema>

 

 

 

菜鸟起飞啊的主页 菜鸟起飞啊 | 初学一级 | 园豆:15
提问于:2014-12-05 11:20
< >
分享
最佳答案
0
收获园豆:30
Yu | 专家六级 |园豆:12990 | 2014-12-05 14:01
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册