Latest revision |
Your text |
Line 1: |
Line 1: |
| == wikibot == | | == wikibot == |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- valign="top"
| |
− | | '''XML Schema Collection
| |
− | | Production.ManuInstructionsSchemaCollection
| |
− | |- valign="top"
| |
− | | '''Description
| |
− | | Collection of XML schemas for the Instructions column in the Production.ProductModel table.
| |
− | |}
| |
− |
| |
− | === Source ===
| |
− | <pre>
| |
− | <?xml version="1.0" encoding="utf-8"?>
| |
− | <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:t="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions" targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions" elementFormDefault="qualified">
| |
− | <xsd:element name="root">
| |
− | <xsd:complexType mixed="true">
| |
− | <xsd:complexContent mixed="true">
| |
− | <xsd:restriction base="xsd:anyType">
| |
− | <xsd:sequence>
| |
− | <xsd:element name="Location" maxOccurs="unbounded">
| |
− | <xsd:complexType mixed="true">
| |
− | <xsd:complexContent mixed="true">
| |
− | <xsd:restriction base="xsd:anyType">
| |
− | <xsd:sequence>
| |
− | <xsd:element name="step" type="t:StepType" maxOccurs="unbounded" />
| |
− | </xsd:sequence>
| |
− | <xsd:attribute name="LocationID" type="xsd:integer" use="required" />
| |
− | <xsd:attribute name="SetupHours" type="xsd:decimal" />
| |
− | <xsd:attribute name="MachineHours" type="xsd:decimal" />
| |
− | <xsd:attribute name="LaborHours" type="xsd:decimal" />
| |
− | <xsd:attribute name="LotSize" type="xsd:decimal" />
| |
− | </xsd:restriction>
| |
− | </xsd:complexContent>
| |
− | </xsd:complexType>
| |
− | </xsd:element>
| |
− | </xsd:sequence>
| |
− | </xsd:restriction>
| |
− | </xsd:complexContent>
| |
− | </xsd:complexType>
| |
− | </xsd:element>
| |
− | <xsd:complexType name="StepType" mixed="true">
| |
− | <xsd:complexContent mixed="true">
| |
− | <xsd:restriction base="xsd:anyType">
| |
− | <xsd:choice minOccurs="0" maxOccurs="unbounded">
| |
− | <xsd:element name="tool" type="xsd:string" />
| |
− | <xsd:element name="material" type="xsd:string" />
| |
− | <xsd:element name="blueprint" type="xsd:string" />
| |
− | <xsd:element name="specs" type="xsd:string" />
| |
− | <xsd:element name="diag" type="xsd:string" />
| |
− | </xsd:choice>
| |
− | </xsd:restriction>
| |
− | </xsd:complexContent>
| |
− | </xsd:complexType>
| |
− | </xsd:schema>
| |
− | </pre>
| |
− |
| |
− | === References ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Dependency Type
| |
− | | '''Object Type
| |
− | | '''Referenced Object
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Schema
| |
− | | [[Production_(schema)|Production]]
| |
− |
| |
− | |}
| |
− |
| |
− | === Dependencies ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Reference Type
| |
− | | '''Object Type
| |
− | | '''Referencing Object
| |
− |
| |
− | |- valign="top"
| |
− | | Data Type
| |
− | | Table
| |
− | | [[Production.ProductModel_(table)|Production.ProductModel]]
| |
− |
| |
− | |}
| |
− |
| |
− |
| |
− | == automatically generated ==
| |
| | | |
| {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
Line 91: |
Line 5: |
| | '''xmlschemacollection | | | '''xmlschemacollection |
| | Production.ManuInstructionsSchemaCollection | | | Production.ManuInstructionsSchemaCollection |
− | |- valign="top"
| |
− | | '''Description
| |
− | | Collection of XML schemas for the Instructions column in the Production.ProductModel table.
| |
| |- | | |- |
| |} | | |} |
| | | |
| <pre> | | <pre> |
− | <?xml version="1.0" encoding="UTF-8"?> | + | <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:t="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions" targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions" elementFormDefault="qualified"><xsd:element name="root"><xsd:complexType mixed="true"><xsd:complexContent mixed="true"><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="Location" maxOccurs="unbounded"><xsd:complexType mixed="true"><xsd:complexContent mixed="true"><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="step" type="t:StepType" maxOccurs="unbounded" /></xsd:sequence><xsd:attribute name="LocationID" type="xsd:integer" use="required" /><xsd:attribute name="SetupHours" type="xsd:decimal" /><xsd:attribute name="MachineHours" type="xsd:decimal" /><xsd:attribute name="LaborHours" type="xsd:decimal" /><xsd:attribute name="LotSize" type="xsd:decimal" /></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element><xsd:complexType name="StepType" mixed="true"><xsd:complexContent mixed="true"><xsd:restriction base="xsd:anyType"><xsd:choice minOccurs="0" maxOccurs="unbounded"><xsd:element name="tool" type="xsd:string" /><xsd:element name="material" type="xsd:string" /><xsd:element name="blueprint" type="xsd:string" /><xsd:element name="specs" type="xsd:string" /><xsd:element name="diag" type="xsd:string" /></xsd:choice></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:schema> |
− | <xsd:schema targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions" elementFormDefault="qualified" attributeFormDefault="unqualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
| |
− | <xsd:annotation>
| |
− | <xsd:documentation>
| |
− | SetupHour is the time it takes to set up the machine.
| |
− | MachineHour is the time the machine is busy manufcturing
| |
− | LaborHour is the labor hours in the manu process
| |
− | LotSize is the minimum quanity manufactured. For example,
| |
− | no. of frames cut from the sheet metal
| |
− | </xsd:documentation>
| |
− | </xsd:annotation>
| |
− | <xsd:complexType name="StepType" mixed="true">
| |
− | <xsd:choice minOccurs="0" maxOccurs="unbounded">
| |
− | <xsd:element name="tool" type="xsd:string" />
| |
− | <xsd:element name="material" type="xsd:string" />
| |
− | <xsd:element name="blueprint" type="xsd:string" />
| |
− | <xsd:element name="specs" type="xsd:string" />
| |
− | <xsd:element name="diag" type="xsd:string" />
| |
− | </xsd:choice>
| |
− | </xsd:complexType>
| |
− | <xsd:element name="root">
| |
− | <xsd:complexType mixed="true">
| |
− | <xsd:sequence>
| |
− | <xsd:element name="Location" minOccurs="1" maxOccurs="unbounded">
| |
− | <xsd:complexType mixed="true">
| |
− | <xsd:sequence>
| |
− | <xsd:element name="step" type="StepType" minOccurs="1" maxOccurs="unbounded" />
| |
− | </xsd:sequence>
| |
− | <xsd:attribute name="LocationID" type="xsd:integer" use="required" />
| |
− | <xsd:attribute name="SetupHours" type="xsd:decimal" use="optional" />
| |
− | <xsd:attribute name="MachineHours" type="xsd:decimal" use="optional" />
| |
− | <xsd:attribute name="LaborHours" type="xsd:decimal" use="optional" />
| |
− | <xsd:attribute name="LotSize" type="xsd:decimal" use="optional" />
| |
− | </xsd:complexType>
| |
− | </xsd:element>
| |
− | </xsd:sequence>
| |
− | </xsd:complexType>
| |
− | </xsd:element>
| |
− | </xsd:schema> | |
| </pre> | | </pre> |
− |
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Dependency Type
| |
− | | '''Object Type
| |
− | | '''Referenced Object
| |
− |
| |
− | |-
| |
− | | Schema
| |
− | | Schema
| |
− | | [[Production_(schema)|Production]]
| |
− |
| |
− | |}
| |
− |
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Reference Type
| |
− | | '''Object Type
| |
− | | '''Referencing Object
| |
− |
| |
− | |-
| |
− | | Data Type
| |
− | | Table
| |
− | | [[Production.ProductModel_(table)|Production.ProductModel]]
| |
− |
| |
− | |}
| |