Columna XML ProductModel.Instructions
La columna Instructions de la tabla ProductModel almacena instrucciones de fabricación como documentos XML. Estos documentos se crearon con Microsoft Word .NET.
Cada documento XML contiene las instrucciones completas para fabricar un modelo de producto específico. Sin embargo, cada modelo de producto puede contener varios productos. Por ejemplo, Road 450 es un modelo de producto de bicicletas. Hay varias bicicletas en este modelo de producto, como Road 450 Red 25 y Road 450 Green 48. La principal diferencia entre las bicicletas de un modelo de producto es su color y tamaño.
Por ejemplo, HH Mountain Frame, LL Mountain Frame y ML Mountain Frame son productos específicos con identificadores únicos, pero todos son tipos de cuadros del modelo de producto de cuadros de bicicletas de montaña.
La columna ProductID de la tabla Product identifica cada producto. La columna ProductModelID de Product identifica el modelo de producto al que pertenece el producto.
En el proceso de fabricación un producto se lleva de un centro de trabajo a otro, y el documento XML describe los pasos de fabricación en cada uno de ellos. Para describir los pasos de fabricación, las herramientas, los materiales, los planos y los diagramas, todos se incluyen dentro de etiquetas XML. Por tanto, se pueden consultar las etiquetas. Por ejemplo, se puede utilizar XQuery para buscar todas las herramientas utilizadas para fabricar una bicicleta de montaña.
Esta es una columna xml con tipo. Los esquemas que se usan para esta columna pueden verse en este sitio web de Microsoft. Esta columna utiliza el esquema XML ProductModelManuInstructions de AdventureWorks2008R2.
Instancia XML de ejemplo
Ésta es una instancia XML de ejemplo que se almacena en la columna ProductModel.Instructions:
<root xmlns="https://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions">
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring FrameSummaryThis document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
<Location LaborHours="2.5" LotSize="100" MachineHours="3"
SetupHours="0.5" LocationID="10">
Work Center - 10 Frame FormingThe following instructions pertain to Work Center 10. (Setup hours = .5, Labor Hours = 2.5, Machine Hours = 3, Lot Sizing = 100)
<step>Insert <material>aluminum sheet MS-2341</material> into the
<tool>T-85A framing tool</tool>.</step>
<step>Attach <tool>Trim Jig TJ-26</tool> to the upper and lower right corners of the aluminum sheet. </step>
<step>Using a <tool>router with a carbide tip 15</tool>
, route the aluminum sheet following the jig carefully. </step>
<step>Insert the frame into <tool>Forming Tool FT-15</tool> and press Start. </step>
<step> When finished, inspect the forms for defects per Inspection Specification <specs>INFS-111</specs>.</step>
<step>Remove the frames from the tool and place them in the Completed or Rejected bin as appropriate.</step>
</Location>
<Location LaborHours="1.75" LotSize="1" MachineHours="2" SetupHours="0.15" LocationID="20">
Work Center 20 - Frame WeldingThe following instructions pertain to Work Center 20. (Setup hours = .15, Labor Hours = 1.75, Machine Hours = 2, Lot Sizing = 1)
<step>Assemble all frame components following blueprint
<blueprint>1299</blueprint> . </step>
<step>Weld all frame components together as shown in illustration
<diag>3</diag> </step>
<step>Inspect all weld joints per Adventure Works Cycles Inspection Specification <specs>INFS-208</specs> . </step>
</Location>
<Location LaborHours="1" LotSize="1" LocationID="30">
Work Center 30 - Debur and PolishThe following instructions pertain to Work Center 30. (Setup hours = 0, Labor Hours = 1, Machine Hours = 0, Lot Sizing = 1)
<step>Using the <tool>standard debur tool</tool> , remove all excess material from weld areas. </step>
<step>Using <material>Acme Polish Cream</material> , polish all weld areas. </step>
</Location>
<Location LaborHours="0.5" LotSize="20" MachineHours="0.65" LocationID="45">
Work Center 45 - Specialized PaintThe following instructions pertain to Work Center 45. (Setup hours = 0, Labor Hours = .5, Machine Hours = .65, Lot Sizing = 20)
<step>Attach <material>a maximum of 20 frames</material>
to <tool>paint harness</tool> ensuring frames are not touching.
</step>
<step>Mix <material>primer PA-529S</material>. Test spray pattern on sample area and correct flow and pattern as required per engineering spec
<specs>AWC-501</specs>. </step>
<step>Apply thin coat of primer to all surfaces.</step>
<step>After 30 minutes, touch test for dryness. If dry to touch, lightly sand all surfaces. Remove all surface debris with compressed air.</step>
<step>Mix <material>paint</material> per manufacturer instructions. </step>
<step>Test spray pattern on sample area and correct flow and pattern as required per engineering spec <specs>AWC-509</specs>.</step>
<step>Apply thin coat of paint to all surfaces.</step>
<step>After 60 minutes, touch test for dryness. If dry to touch, reapply second coat.</step>
<step> Allow paint to cure for 24 hours and inspect per <specs>AWC-5015</specs> . </step>
</Location>
<Location LaborHours="3" LotSize="1" SetupHours="0.25" LocationID="50">
Work Center 50 - SubAssembly The following instructions pertain to Work Center 50. (Setup hours = .25, Labor Hours = 3, Machine Hours = 0, Lot Sizing = 1)
<step>Add Seat Assembly.</step>
<step>Add Brake assembly.</step>
<step>Add Wheel Assembly.</step>
<step>Inspect Front Derailleur.</step>
<step>Inspect Rear Derailleur.</step>
</Location>
<Location LaborHours="4" LotSize="1" LocationID="60">
Work Center 60 - Final Assembly The following instructions pertain to Work Center 60. (Setup hours = 0, Labor Hours = 4, Machine Hours = 0, Lot Sizing = 1)
<step>Perform final inspection per engineering specification
<specs>AWC-915</specs>. </step>
<step>Complete all required certification forms.</step>
<step>Move to shipping.</step>
</Location>
</root>
Ejecute la consulta siguiente para encontrar más instancias XML:
USE AdventureWorks2008R2;
GO
SELECT Instructions
FROM Production.ProductModel
WHERE Instructions IS NOT NULL;