ProductModel.Instructions xml 열 정보
ProductModel 테이블의 Instructions 열은 XML 문서로 제조 명령을 저장합니다. 이러한 문서는 Microsoft Word .NET을 사용하여 생성된 것입니다.
각 XML 문서에는 특정 제품 모델을 제조하기 위한 완전한 명령이 포함됩니다. 하지만 각 제품 모델에는 몇 가지 제품이 포함될 수 있습니다. 예를 들어 Road 450은 자전거 제품 모델입니다. 이 제품 모델에는 Road 450 Red 25 및 Road 450 Green 48과 같은 여러 자전거가 포함됩니다. 제품 모델에서 자전거 간의 주요한 차이점은 색과 크기입니다.
예를 들어 HH Mountain Frame, LL Mountain Frame 및 ML Mountain Frame은 고유 제품 ID가 있는 특정 제품들이지만 모두 산악용 자전거 프레임의 제품 모델에 포함되는 프레임 유형입니다.
Product 테이블의 ProductID 열은 각 제품을 식별합니다. Product의 ProductModelID 열은 제품이 속하는 제품 모델을 식별합니다.
제조 프로세스에서는 각 작업 센터별로 제품을 가져오고 XML 문서에는 각 작업 센터의 제조 단계가 기술되어 있습니다. 제조 단계에 대한 설명에서 도구, 자재, 설계 및 다이어그램은 모두 XML 태그로 래핑되어 있습니다. 따라서 태그를 쿼리할 수 있습니다. 예를 들어 XQuery를 사용하여 산악용 자전거를 생산하는 데 사용되는 모든 도구를 찾을 수 있습니다.
이것은 형식화된 xml 열입니다. 이 열에 사용된 스키마는 이 Microsoft 웹 사이트에서 볼 수 있습니다. 이 열에서는 AdventureWorks2008R2 ProductModelManuInstructions XML 스키마를 사용합니다.
예제 XML 인스턴스
이 예제 XML 인스턴스는 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>
더 많은 XML 인스턴스를 찾으려면 다음 쿼리를 실행합니다.
USE AdventureWorks2008R2;
GO
SELECT Instructions
FROM Production.ProductModel
WHERE Instructions IS NOT NULL;