Skip to content

Instantly share code, notes, and snippets.

@Roenbaeck
Created August 11, 2022 23:03
Show Gist options
  • Select an option

  • Save Roenbaeck/cd870d3f77ed167bbc5a473bb4146fe8 to your computer and use it in GitHub Desktop.

Select an option

Save Roenbaeck/cd870d3f77ed167bbc5a473bb4146fe8 to your computer and use it in GitHub Desktop.
Northwind Database
<schema><metadata format="0.94" temporalization="mono"/><anchor mnemonic="CA" descriptor="Category" identity="int"><metadata capsule="dbo" generator="true"/><attribute mnemonic="CAT" descriptor="Categoryname" dataRange="12"><metadata capsule="dbo"/><layout x="-214.11" y="236.86" fixed="false"/></attribute><attribute mnemonic="DES" descriptor="Description" dataRange="2005"><metadata capsule="dbo"/><layout x="-153.94" y="201.91" fixed="false"/></attribute><attribute mnemonic="PIC" descriptor="Picture" dataRange="2004"><metadata capsule="dbo"/><layout x="-242.47" y="300.65" fixed="false"/></attribute><layout x="-161.70" y="280.73" fixed="false"/></anchor><anchor mnemonic="OD" descriptor="Orderdetails" identity="int"><metadata capsule="dbo" generator="true"/><attribute mnemonic="UNI" descriptor="Unitprice" dataRange="3"><metadata capsule="dbo"/><layout x="164.42" y="271.18" fixed="false"/></attribute><attribute mnemonic="QUA" descriptor="Quantity" dataRange="5"><metadata capsule="dbo"/><layout x="195.64" y="237.22" fixed="false"/></attribute><attribute mnemonic="DIS" descriptor="Discount" dataRange="7"><metadata capsule="dbo"/><layout x="187.27" y="174.95" fixed="false"/></attribute><layout x="127.91" y="179.84" fixed="false"/></anchor><anchor mnemonic="EP" descriptor="Employee" identity="int"><metadata capsule="dbo" generator="true"/><attribute mnemonic="FIR" descriptor="Firstname" dataRange="12"><metadata capsule="dbo"/><layout x="369.97" y="-128.97" fixed="false"/></attribute><attribute mnemonic="TIT" descriptor="Title" dataRange="12"><metadata capsule="dbo"/><layout x="294.04" y="-35.51" fixed="false"/></attribute><attribute mnemonic="TIC" descriptor="Titleofcourtesy" dataRange="12"><metadata capsule="dbo"/><layout x="406.56" y="-107.98" fixed="false"/></attribute><attribute mnemonic="BIR" descriptor="Birthdate" dataRange="93"><metadata capsule="dbo"/><layout x="268.01" y="-8.13" fixed="false"/></attribute><attribute mnemonic="HIR" descriptor="Hiredate" dataRange="93"><metadata capsule="dbo"/><layout x="476.62" y="19.99" fixed="false"/></attribute><attribute mnemonic="ADD" descriptor="Address" dataRange="12"><metadata capsule="dbo"/><layout x="459.68" y="-52.58" fixed="false"/></attribute><attribute mnemonic="CIT" descriptor="City" dataRange="12"><metadata capsule="dbo"/><layout x="299.93" y="54.36" fixed="false"/></attribute><attribute mnemonic="REG" descriptor="Region" dataRange="12"><metadata capsule="dbo"/><layout x="323.13" y="-86.73" fixed="false"/></attribute><attribute mnemonic="POS" descriptor="Postalcode" dataRange="12"><metadata capsule="dbo"/><layout x="395.31" y="97.45" fixed="false"/></attribute><attribute mnemonic="COU" descriptor="Country" dataRange="12"><metadata capsule="dbo"/><layout x="363.62" y="-99.20" fixed="false"/></attribute><attribute mnemonic="HOM" descriptor="Homephone" dataRange="12"><metadata capsule="dbo"/><layout x="435.62" y="-103.25" fixed="false"/></attribute><attribute mnemonic="EXT" descriptor="Extension" dataRange="12"><metadata capsule="dbo"/><layout x="272.05" y="38.67" fixed="false"/></attribute><attribute mnemonic="PHO" descriptor="Photo" dataRange="2004"><metadata capsule="dbo"/><layout x="487.84" y="47.52" fixed="false"/></attribute><attribute mnemonic="NOT" descriptor="Notes" dataRange="2005"><metadata capsule="dbo"/><layout x="428.33" y="106.18" fixed="false"/></attribute><attribute mnemonic="LAS" descriptor="Lastname" dataRange="12"><metadata capsule="dbo"/><layout x="452.89" y="66.05" fixed="false"/></attribute><attribute mnemonic="PAT" descriptor="Photopath" dataRange="12"><metadata capsule="dbo"/><layout x="367.15" y="120.01" fixed="false"/></attribute><attribute mnemonic="TER" descriptor="Territoryid" dataRange="12"><metadata capsule="dbo"/><layout x="487.99" y="-12.48" fixed="false"/></attribute><layout x="370.87" y="-2.48" fixed="false"/></anchor><anchor mnemonic="TE" descriptor="Territory" identity="int"><metadata capsule="dbo" generator="true"/><attribute mnemonic="TER" descriptor="Territorydescription" dataRange="1"><metadata capsule="dbo"/><layout x="603.34" y="-284.95" fixed="false"/></attribute><layout x="615.97" y="-212.17" fixed="false"/></anchor><anchor mnemonic="RE" descriptor="Region" identity="int"><metadata capsule="dbo" generator="true"/><attribute mnemonic="REG" descriptor="Regiondescription" dataRange="1"><metadata capsule="dbo"/><layout x="807.79" y="-167.09" fixed="false"/></attribute><layout x="774.89" y="-220.69" fixed="false"/></anchor><anchor mnemonic="CU" descriptor="Customerdemographics" identity="int"><metadata capsule="dbo" generator="true"/><attribute mnemonic="CUS" descriptor="Customerdesc" dataRange="12"><metadata capsule="dbo"/><layout x="-228.98" y="-150.48" fixed="false"/></attribute><layout x="-158.71" y="-144.21" fixed="false"/></anchor><anchor mnemonic="CT" descriptor="Customercustomerdemo" identity="int"><metadata capsule="dbo" generator="true"/><layout x="-144.57" y="-36.76" fixed="false"/></anchor><anchor mnemonic="EM" descriptor="Employeeterritories" identity="int"><metadata capsule="dbo" generator="true"/><layout x="594.68" y="-78.77" fixed="false"/></anchor><anchor mnemonic="PR" descriptor="Product" identity="int"><metadata capsule="dbo" generator="true"/><attribute mnemonic="PRO" descriptor="Productname" dataRange="12"><metadata capsule="dbo"/><layout x="-20.55" y="308.26" fixed="false"/></attribute><attribute mnemonic="QUA" descriptor="Quantityperunit" dataRange="12"><metadata capsule="dbo"/><layout x="33.18" y="294.60" fixed="false"/></attribute><attribute mnemonic="UNP" descriptor="Unitprice" dataRange="3"><metadata capsule="dbo"/><layout x="-47.40" y="382.60" fixed="false"/></attribute><attribute mnemonic="UNI" descriptor="Unitsinstock" dataRange="5"><metadata capsule="dbo"/><layout x="125.40" y="367.11" fixed="false"/></attribute><attribute mnemonic="UNO" descriptor="Unitsonorder" dataRange="5"><metadata capsule="dbo"/><layout x="14.21" y="478.56" fixed="false"/></attribute><attribute mnemonic="REO" descriptor="Reorderlevel" dataRange="5"><metadata capsule="dbo"/><layout x="68.05" y="449.31" fixed="false"/></attribute><attribute mnemonic="DIS" descriptor="Discontinued" dataRange="-7"><metadata capsule="dbo"/><layout x="109.61" y="417.03" fixed="false"/></attribute><layout x="24.83" y="381.19" fixed="false"/></anchor><anchor mnemonic="SU" descriptor="Supplier" identity="int"><metadata capsule="dbo" generator="true"/><attribute mnemonic="COM" descriptor="Companyname" dataRange="12"><metadata capsule="dbo"/><layout x="-263.71" y="427.74" fixed="false"/></attribute><attribute mnemonic="CON" descriptor="Contactname" dataRange="12"><metadata capsule="dbo"/><layout x="-221.02" y="408.81" fixed="false"/></attribute><attribute mnemonic="CTI" descriptor="Contacttitle" dataRange="12"><metadata capsule="dbo"/><layout x="-285.67" y="469.55" fixed="false"/></attribute><attribute mnemonic="ADD" descriptor="Address" dataRange="12"><metadata capsule="dbo"/><layout x="-170.32" y="395.76" fixed="false"/></attribute><attribute mnemonic="CIT" descriptor="City" dataRange="12"><metadata capsule="dbo"/><layout x="-283.39" y="531.03" fixed="false"/></attribute><attribute mnemonic="REG" descriptor="Region" dataRange="12"><metadata capsule="dbo"/><layout x="-143.76" y="420.61" fixed="false"/></attribute><attribute mnemonic="POS" descriptor="Postalcode" dataRange="12"><metadata capsule="dbo"/><layout x="-101.97" y="511.77" fixed="false"/></attribute><attribute mnemonic="COU" descriptor="Country" dataRange="12"><metadata capsule="dbo"/><layout x="-147.66" y="580.20" fixed="false"/></attribute><attribute mnemonic="PHO" descriptor="Phone" dataRange="12"><metadata capsule="dbo"/><layout x="-204.45" y="584.64" fixed="false"/></attribute><attribute mnemonic="FAX" descriptor="Fax" dataRange="12"><metadata capsule="dbo"/><layout x="-253.19" y="561.81" fixed="false"/></attribute><attribute mnemonic="HOM" descriptor="Homepage" dataRange="2005"><metadata capsule="dbo"/><layout x="-122.54" y="552.08" fixed="false"/></attribute><layout x="-189.06" y="490.29" fixed="false"/></anchor><anchor mnemonic="SH" descriptor="Shipper" identity="int"><metadata capsule="dbo" generator="true"/><attribute mnemonic="COM" descriptor="Companyname" dataRange="12"><metadata capsule="dbo"/><layout x="267.22" y="136.48" fixed="false"/></attribute><attribute mnemonic="PHO" descriptor="Phone" dataRange="12"><metadata capsule="dbo"/><layout x="242.49" y="159.22" fixed="false"/></attribute><layout x="213.26" y="96.07" fixed="false"/></anchor><anchor mnemonic="OR" descriptor="Order" identity="int"><metadata capsule="dbo" generator="true"/><attribute mnemonic="REQ" descriptor="Requireddate" dataRange="93"><metadata capsule="dbo"/><layout x="133.43" y="-230.76" fixed="false"/></attribute><attribute mnemonic="SHD" descriptor="Shippeddate" dataRange="93"><metadata capsule="dbo"/><layout x="97.15" y="-207.14" fixed="false"/></attribute><attribute mnemonic="ORD" descriptor="Orderdate" dataRange="93"><metadata capsule="dbo"/><layout x="189.59" y="-245.27" fixed="false"/></attribute><attribute mnemonic="FRE" descriptor="Freight" dataRange="3"><metadata capsule="dbo"/><layout x="79.35" y="-168.55" fixed="false"/></attribute><attribute mnemonic="SHN" descriptor="Shipname" dataRange="12"><metadata capsule="dbo"/><layout x="204.54" y="-90.43" fixed="false"/></attribute><attribute mnemonic="SHA" descriptor="Shipaddress" dataRange="12"><metadata capsule="dbo"/><layout x="80.52" y="-117.68" fixed="false"/></attribute><attribute mnemonic="SHC" descriptor="Shipcity" dataRange="12"><metadata capsule="dbo"/><layout x="236.17" y="-225.51" fixed="false"/></attribute><attribute mnemonic="SHI" descriptor="Shipregion" dataRange="12"><metadata capsule="dbo"/><layout x="258.37" y="-194.69" fixed="false"/></attribute><attribute mnemonic="SHP" descriptor="Shippostalcode" dataRange="12"><metadata capsule="dbo"/><layout x="146.52" y="-71.31" fixed="false"/></attribute><attribute mnemonic="SHS" descriptor="Shipcountry" dataRange="12"><metadata capsule="dbo"/><layout x="238.87" y="-102.29" fixed="false"/></attribute><layout x="180.09" y="-141.02" fixed="false"/></anchor><anchor mnemonic="CS" descriptor="Customer" identity="int"><metadata capsule="dbo" generator="true"/><attribute mnemonic="COM" descriptor="Companyname" dataRange="12"><metadata capsule="dbo"/><layout x="-52.79" y="-5.61" fixed="false"/></attribute><attribute mnemonic="CON" descriptor="Contactname" dataRange="12"><metadata capsule="dbo"/><layout x="53.54" y="14.69" fixed="false"/></attribute><attribute mnemonic="CTI" descriptor="Contacttitle" dataRange="12"><metadata capsule="dbo"/><layout x="-92.97" y="87.88" fixed="false"/></attribute><attribute mnemonic="ADD" descriptor="Address" dataRange="12"><metadata capsule="dbo"/><layout x="-13.01" y="-31.78" fixed="false"/></attribute><attribute mnemonic="CIT" descriptor="City" dataRange="12"><metadata capsule="dbo"/><layout x="-73.15" y="130.02" fixed="false"/></attribute><attribute mnemonic="REG" descriptor="Region" dataRange="12"><metadata capsule="dbo"/><layout x="-19.93" y="178.57" fixed="false"/></attribute><attribute mnemonic="POS" descriptor="Postalcode" dataRange="12"><metadata capsule="dbo"/><layout x="96.10" y="55.26" fixed="false"/></attribute><attribute mnemonic="COU" descriptor="Country" dataRange="12"><metadata capsule="dbo"/><layout x="52.21" y="138.34" fixed="false"/></attribute><attribute mnemonic="PHO" descriptor="Phone" dataRange="12"><metadata capsule="dbo"/><layout x="3.31" y="156.07" fixed="false"/></attribute><attribute mnemonic="FAX" descriptor="Fax" dataRange="12"><metadata capsule="dbo"/><layout x="78.80" y="107.97" fixed="false"/></attribute><layout x="-6.71" y="64.21" fixed="false"/></anchor><tie><anchorRole role="parent" type="RE" identifier="true"/><anchorRole role="child" type="TE" identifier="true"/><metadata capsule="dbo"/><layout x="701.07" y="-206.12" fixed="false"/></tie><tie><anchorRole role="parent" type="SH" identifier="true"/><anchorRole role="child" type="OR" identifier="true"/><metadata capsule="dbo"/><layout x="197.23" y="2.43" fixed="false"/></tie><tie><anchorRole role="parent" type="EP" identifier="true"/><anchorRole role="child" type="EP" identifier="true"/><metadata capsule="dbo"/><layout x="332.13" y="89.18" fixed="false"/></tie><tie><anchorRole role="parent" type="SU" identifier="true"/><anchorRole role="child" type="PR" identifier="true"/><metadata capsule="dbo"/><layout x="-68.18" y="453.17" fixed="false"/></tie><tie><anchorRole role="parent" type="CS" identifier="true"/><anchorRole role="child" type="CT" identifier="true"/><metadata capsule="dbo"/><layout x="-127.00" y="37.08" fixed="false"/></tie><tie><anchorRole role="parent" type="CS" identifier="true"/><anchorRole role="child" type="OR" identifier="true"/><metadata capsule="dbo"/><layout x="73.52" y="-49.00" fixed="false"/></tie><tie><anchorRole role="parent" type="TE" identifier="true"/><anchorRole role="child" type="EM" identifier="true"/><metadata capsule="dbo"/><layout x="567.90" y="-153.33" fixed="false"/></tie><tie><anchorRole role="parent" type="EP" identifier="true"/><anchorRole role="child" type="OR" identifier="true"/><metadata capsule="dbo"/><layout x="286.63" y="-105.04" fixed="false"/></tie><tie><anchorRole role="parent" type="CU" identifier="true"/><anchorRole role="child" type="CT" identifier="true"/><metadata capsule="dbo"/><layout x="-109.56" y="-106.25" fixed="false"/></tie><tie><anchorRole role="parent" type="PR" identifier="true"/><anchorRole role="child" type="OD" identifier="true"/><metadata capsule="dbo"/><layout x="93.76" y="281.56" fixed="false"/></tie><tie><anchorRole role="parent" type="CA" identifier="true"/><anchorRole role="child" type="PR" identifier="true"/><metadata capsule="dbo"/><layout x="-82.39" y="318.73" fixed="false"/></tie><tie><anchorRole role="parent" type="EP" identifier="true"/><anchorRole role="child" type="EM" identifier="true"/><metadata capsule="dbo"/><layout x="497.58" y="-71.75" fixed="false"/></tie><tie><anchorRole role="parent" type="OR" identifier="true"/><anchorRole role="child" type="OD" identifier="true"/><metadata capsule="dbo"/><layout x="164.60" y="30.58" fixed="false"/></tie></schema>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment