📄 northwinddataschema.xsd
字号:
<?xml version="1.0" standalone="yes"?>
<NorthwindDataSchema>
<xs:schema id="NorthwindDataSchema" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="NorthwindDataSchema" msdata:IsDataSet="true">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element name="ProductsTable">
<xs:complexType>
<xs:sequence>
<xs:element name="ProductID" type="xs:int" />
<xs:element name="ProductName" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="OrdersTable">
<xs:complexType>
<xs:sequence>
<xs:element name="OrderID" type="xs:int" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="OrderDetailsTable">
<xs:complexType>
<xs:sequence>
<xs:element name="ProductID" type="xs:int" />
<xs:element name="OrderID" type="xs:int" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//ProductsTable" />
<xs:field xpath="ProductID" />
</xs:unique>
<xs:unique name="OrdersTable_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//OrdersTable" />
<xs:field xpath="OrderID" />
</xs:unique>
<xs:unique name="OrderDetailsTable_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//OrderDetailsTable" />
<xs:field xpath="ProductID" />
<xs:field xpath="OrderID" />
</xs:unique>
</xs:element>
</xs:schema>
<ProductsTable>
<ProductID>17</ProductID>
<ProductName>Alice Mutton</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>3</ProductID>
<ProductName>Aniseed Syrup</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>40</ProductID>
<ProductName>Boston Crab Meat</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>60</ProductID>
<ProductName>Camembert Pierrot</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>18</ProductID>
<ProductName>Carnarvon Tigers</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>1</ProductID>
<ProductName>Chai</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>2</ProductID>
<ProductName>Chang</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>39</ProductID>
<ProductName>Chartreuse verte</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>4</ProductID>
<ProductName>Chef Anton's Cajun Seasoning</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>5</ProductID>
<ProductName>Chef Anton's Gumbo Mix</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>48</ProductID>
<ProductName>Chocolade</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>38</ProductID>
<ProductName>C么te de Blaye</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>58</ProductID>
<ProductName>Escargots de Bourgogne</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>52</ProductID>
<ProductName>Filo Mix</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>71</ProductID>
<ProductName>Flotemysost</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>33</ProductID>
<ProductName>Geitost</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>15</ProductID>
<ProductName>Genen Shouyu</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>56</ProductID>
<ProductName>Gnocchi di nonna Alice</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>31</ProductID>
<ProductName>Gorgonzola Telino</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>6</ProductID>
<ProductName>Grandma's Boysenberry Spread</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>37</ProductID>
<ProductName>Gravad lax</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>24</ProductID>
<ProductName>Guaran谩 Fant谩stica</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>69</ProductID>
<ProductName>Gudbrandsdalsost</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>44</ProductID>
<ProductName>Gula Malacca</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>26</ProductID>
<ProductName>Gumb盲r Gummib盲rchen</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>22</ProductID>
<ProductName>Gustaf's Kn盲ckebr枚d</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>10</ProductID>
<ProductName>Ikura</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>36</ProductID>
<ProductName>Inlagd Sill</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>43</ProductID>
<ProductName>Ipoh Coffee</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>41</ProductID>
<ProductName>Jack's New England Clam Chowder</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>13</ProductID>
<ProductName>Konbu</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>76</ProductID>
<ProductName>Lakkalik枚枚ri</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>67</ProductID>
<ProductName>Laughing Lumberjack Lager</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>74</ProductID>
<ProductName>Longlife Tofu</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>65</ProductID>
<ProductName>Louisiana Fiery Hot Pepper Sauce</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>66</ProductID>
<ProductName>Louisiana Hot Spiced Okra</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>51</ProductID>
<ProductName>Manjimup Dried Apples</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>32</ProductID>
<ProductName>Mascarpone Fabioli</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>49</ProductID>
<ProductName>Maxilaku</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>9</ProductID>
<ProductName>Mishi Kobe Niku</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>72</ProductID>
<ProductName>Mozzarella di Giovanni</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>30</ProductID>
<ProductName>Nord-Ost Matjeshering</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>8</ProductID>
<ProductName>Northwoods Cranberry Sauce</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>25</ProductID>
<ProductName>NuNuCa Nu脽-Nougat-Creme</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>77</ProductID>
<ProductName>Original Frankfurter gr眉ne So脽e</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>70</ProductID>
<ProductName>Outback Lager</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>55</ProductID>
<ProductName>P芒t茅 chinois</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>16</ProductID>
<ProductName>Pavlova</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>53</ProductID>
<ProductName>Perth Pasties</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>11</ProductID>
<ProductName>Queso Cabrales</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>12</ProductID>
<ProductName>Queso Manchego La Pastora</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>59</ProductID>
<ProductName>Raclette Courdavault</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>57</ProductID>
<ProductName>Ravioli Angelo</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>75</ProductID>
<ProductName>Rh枚nbr盲u Klosterbier</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>73</ProductID>
<ProductName>R枚d Kaviar</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>45</ProductID>
<ProductName>Rogede sild</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>28</ProductID>
<ProductName>R枚ssle Sauerkraut</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>34</ProductID>
<ProductName>Sasquatch Ale</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>27</ProductID>
<ProductName>Schoggi Schokolade</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>68</ProductID>
<ProductName>Scottish Longbreads</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>42</ProductID>
<ProductName>Singaporean Hokkien Fried Mee</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>20</ProductID>
<ProductName>Sir Rodney's Marmalade</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>21</ProductID>
<ProductName>Sir Rodney's Scones</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>61</ProductID>
<ProductName>Sirop d'茅rable</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>46</ProductID>
<ProductName>Spegesild</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>35</ProductID>
<ProductName>Steeleye Stout</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>62</ProductID>
<ProductName>Tarte au sucre</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>19</ProductID>
<ProductName>Teatime Chocolate Biscuits</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>29</ProductID>
<ProductName>Th眉ringer Rostbratwurst</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>14</ProductID>
<ProductName>Tofu</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>54</ProductID>
<ProductName>Tourti猫re</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>23</ProductID>
<ProductName>Tunnbr枚d</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>7</ProductID>
<ProductName>Uncle Bob's Organic Dried Pears</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>50</ProductID>
<ProductName>Valkoinen suklaa</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>63</ProductID>
<ProductName>Vegie-spread</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>64</ProductID>
<ProductName>Wimmers gute Semmelkn枚del</ProductName>
</ProductsTable>
<ProductsTable>
<ProductID>47</ProductID>
<ProductName>Zaanse koeken</ProductName>
</ProductsTable>
<OrdersTable>
<OrderID>10249</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10251</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10258</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10260</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10265</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10267</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10269</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10270</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10274</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10275</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10280</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10281</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10282</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10284</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10288</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10290</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10296</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10309</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10317</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10323</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10324</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10327</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10330</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10331</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10343</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10349</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10351</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10355</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10358</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10362</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10364</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10371</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10379</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10382</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10388</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10390</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10395</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10397</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10401</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10404</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10405</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10406</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10408</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10409</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10415</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10418</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10420</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10421</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10422</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10426</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10428</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10430</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10437</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10443</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10445</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10446</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10452</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10457</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10460</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10462</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10466</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10469</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10472</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10475</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10492</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10497</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10500</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10502</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10507</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10509</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10513</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10515</OrderID>
</OrdersTable>
<OrdersTable>
<OrderID>10520</OrderID>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -