Skip to content

Instantly share code, notes, and snippets.

@Roenbaeck
Created August 11, 2022 12:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Roenbaeck/edecc0602bd784132cbb6b05a995c8b9 to your computer and use it in GitHub Desktop.
Save Roenbaeck/edecc0602bd784132cbb6b05a995c8b9 to your computer and use it in GitHub Desktop.
Retail Seed Model
<schema format="0.99" date="2016-04-27" time="20:40:46">
<metadata changingRange="datetime" encapsulation="dbo" identity="int" metadataPrefix="Metadata" metadataType="int" metadataUsage="false" changingSuffix="ChangedAt" identitySuffix="ID" positIdentity="int" positGenerator="true" positingRange="datetime" positingSuffix="PositedAt" positorRange="tinyint" positorSuffix="Positor" reliabilityRange="decimal(5,2)" reliabilitySuffix="Reliability" deleteReliability="0" assertionSuffix="Assertion" partitioning="true" entityIntegrity="true" restatability="false" idempotency="true" assertiveness="false" naming="improved" positSuffix="Posit" annexSuffix="Annex" chronon="datetime2(7)" now="sysdatetime()" dummySuffix="Dummy" versionSuffix="Version" statementTypeSuffix="StatementType" checksumSuffix="Checksum" businessViews="true" decisiveness="true" equivalence="false" equivalentSuffix="EQ" equivalentRange="tinyint" databaseTarget="SQLServer" temporalization="uni"/>
<knot mnemonic="HOW" descriptor="HouseholdOwner" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="724.56" y="-4.61" fixed="false"/>
</knot>
<knot mnemonic="ICO" descriptor="ItemColor" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="8.07" y="1286.12" fixed="false"/>
</knot>
<knot mnemonic="CGP" descriptor="ControlGroup" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="997.05" y="380.05" fixed="false"/>
</knot>
<knot mnemonic="VFQ" descriptor="VisitationFrequency" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="821.41" y="283.89" fixed="false"/>
</knot>
<knot mnemonic="IGL" descriptor="ItemGroupLevel" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="329.27" y="1405.54" fixed="false"/>
</knot>
<knot mnemonic="SCL" descriptor="StoreClassification" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="-2.23" y="449.64" fixed="false"/>
</knot>
<knot mnemonic="IMT" descriptor="IdentificationMethod" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="849.47" y="654.33" fixed="false"/>
</knot>
<knot mnemonic="CMA" descriptor="CatchmentArea" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="242.60" y="334.63" fixed="false"/>
</knot>
<knot mnemonic="HTP" descriptor="HouseholdType" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="813.80" y="-362.17" fixed="false"/>
</knot>
<knot mnemonic="QTP" descriptor="QuantificationType" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="1119.86" y="1281.94" fixed="false"/>
</knot>
<knot mnemonic="GEN" descriptor="Gender" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="831.15" y="155.26" fixed="false"/>
</knot>
<knot mnemonic="ROT" descriptor="Root" identity="bit" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="447.68" y="470.01" fixed="false"/>
</knot>
<knot mnemonic="EXP" descriptor="Expiration" identity="bit" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="-16.54" y="743.24" fixed="false"/>
</knot>
<knot mnemonic="ISZ" descriptor="ItemSize" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="-58.42" y="1167.57" fixed="false"/>
</knot>
<knot mnemonic="OTP" descriptor="OfferType" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="1601.14" y="331.97" fixed="false"/>
</knot>
<knot mnemonic="IBL" descriptor="Identifiable" identity="bit" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="1096.86" y="1019.97" fixed="false"/>
</knot>
<knot mnemonic="AEL" descriptor="AreaLevel" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="-75.03" y="99.45" fixed="false"/>
</knot>
<knot mnemonic="PLT" descriptor="PriceListType" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="-439.95" y="742.65" fixed="false"/>
</knot>
<knot mnemonic="SGL" descriptor="StoreGroupLevel" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="-483.88" y="392.69" fixed="false"/>
</knot>
<knot mnemonic="CCL" descriptor="CustomerClassification" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="563.83" y="510.09" fixed="false"/>
</knot>
<knot mnemonic="TGP" descriptor="TargetGroup" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="1563.15" y="218.84" fixed="false"/>
</knot>
<knot mnemonic="CTP" descriptor="CardType" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="1160.28" y="449.78" fixed="false"/>
</knot>
<knot mnemonic="RTP" descriptor="RegisterType" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="444.42" y="833.11" fixed="false"/>
</knot>
<knot mnemonic="ACL" descriptor="AreaClassification" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="-180.12" y="183.66" fixed="false"/>
</knot>
<knot mnemonic="PME" descriptor="PaymentMethod" identity="tinyint" dataRange="varchar(255)">
<metadata capsule="dbo" generator="false"/>
<layout x="1217.79" y="829.57" fixed="false"/>
</knot>
<anchor mnemonic="RG" descriptor="Register" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="NUM" descriptor="Number" dataRange="int">
<metadata capsule="dbo"/>
<layout x="493.86" y="811.91" fixed="false"/>
</attribute>
<attribute mnemonic="MAC" descriptor="MAC" dataRange="varchar(255)">
<metadata capsule="dbo"/>
<layout x="483.44" y="855.44" fixed="false"/>
</attribute>
<attribute mnemonic="RTP" descriptor="Type" knotRange="RTP">
<metadata capsule="dbo"/>
<layout x="475.57" y="902.74" fixed="false"/>
</attribute>
<layout x="531.61" y="826.05" fixed="false"/>
</anchor>
<anchor mnemonic="PL" descriptor="PriceList" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="NAM" descriptor="Name" dataRange="varchar(255)">
<metadata capsule="dbo"/>
<layout x="-228.65" y="736.62" fixed="false"/>
</attribute>
<attribute mnemonic="PLT" descriptor="Type" knotRange="PLT">
<metadata capsule="dbo"/>
<layout x="-335.34" y="727.88" fixed="false"/>
</attribute>
<layout x="-154.10" y="704.05" fixed="false"/>
</anchor>
<anchor mnemonic="IG" descriptor="ItemGroup" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="NAM" descriptor="Name" timeRange="datetime" dataRange="varchar(255)">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="259.89" y="1263.95" fixed="false"/>
</attribute>
<layout x="290.27" y="1168.71" fixed="true"/>
</anchor>
<anchor mnemonic="AE" descriptor="Area" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="NAM" descriptor="Name" dataRange="varchar(255)">
<metadata capsule="dbo"/>
<layout x="-12.54" y="222.27" fixed="false"/>
</attribute>
<attribute mnemonic="COD" descriptor="Code" dataRange="varchar(255)">
<metadata capsule="dbo"/>
<layout x="-0.22" y="329.93" fixed="false"/>
</attribute>
<attribute mnemonic="POP" descriptor="Population" dataRange="int">
<metadata capsule="dbo"/>
<layout x="-1.88" y="294.84" fixed="false"/>
</attribute>
<attribute mnemonic="SIZ" descriptor="Size" dataRange="int">
<metadata capsule="dbo"/>
<layout x="2.87" y="203.01" fixed="false"/>
</attribute>
<attribute mnemonic="DEN" descriptor="Density" dataRange="decimal(18,6)">
<metadata capsule="dbo"/>
<layout x="-0.89" y="279.01" fixed="false"/>
</attribute>
<attribute mnemonic="ACL" descriptor="Classification" timeRange="datetime" knotRange="ACL">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="-82.63" y="225.11" fixed="false"/>
</attribute>
<layout x="88.58" y="279.39" fixed="true"/>
</anchor>
<anchor mnemonic="PU" descriptor="Purchase" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="AMT" descriptor="Amount" dataRange="money">
<metadata capsule="dbo"/>
<layout x="809.60" y="1093.64" fixed="false"/>
</attribute>
<attribute mnemonic="REB" descriptor="Rebate" dataRange="money">
<metadata capsule="dbo"/>
<layout x="809.09" y="1119.25" fixed="false"/>
</attribute>
<attribute mnemonic="DAT" descriptor="Date" dataRange="date">
<metadata capsule="dbo"/>
<layout x="833.04" y="1125.92" fixed="false"/>
</attribute>
<attribute mnemonic="TIM" descriptor="Time" dataRange="time(0)">
<metadata capsule="dbo"/>
<layout x="785.98" y="1061.83" fixed="false"/>
</attribute>
<attribute mnemonic="NUM" descriptor="Number" dataRange="int">
<metadata capsule="dbo"/>
<layout x="814.01" y="911.54" fixed="false"/>
</attribute>
<attribute mnemonic="NOI" descriptor="NumberOfItems" dataRange="int">
<metadata capsule="dbo"/>
<layout x="760.41" y="1015.43" fixed="false"/>
</attribute>
<attribute mnemonic="NDI" descriptor="NumberOfDistinctItems" dataRange="int">
<metadata capsule="dbo"/>
<layout x="905.53" y="985.12" fixed="false"/>
</attribute>
<attribute mnemonic="IBL" descriptor="Identifiable" knotRange="IBL">
<metadata capsule="dbo"/>
<layout x="994.43" y="997.99" fixed="false"/>
</attribute>
<layout x="825.15" y="990.56" fixed="false"/>
</anchor>
<anchor mnemonic="CU" descriptor="Customer" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="NUM" descriptor="Number" dataRange="bigint">
<metadata capsule="dbo"/>
<layout x="672.99" y="292.10" fixed="true"/>
</attribute>
<attribute mnemonic="NAM" descriptor="Name" timeRange="datetime" dataRange="varchar(255)">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="730.86" y="399.04" fixed="false"/>
</attribute>
<attribute mnemonic="DOB" descriptor="DateOfBirth" timeRange="datetime" dataRange="date">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="576.23" y="389.38" fixed="false"/>
</attribute>
<attribute mnemonic="FKP" descriptor="FirstKnownPurchase" timeRange="datetime" dataRange="datetime">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="589.79" y="422.29" fixed="false"/>
</attribute>
<attribute mnemonic="IDN" descriptor="Identification" timeRange="datetime" dataRange="varchar(255)">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="574.04" y="315.42" fixed="false"/>
</attribute>
<attribute mnemonic="APV" descriptor="AmountPerVisit" timeRange="datetime" dataRange="money">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="552.21" y="340.66" fixed="false"/>
</attribute>
<attribute mnemonic="CCL" descriptor="Classification" timeRange="datetime" knotRange="CCL">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="603.96" y="471.99" fixed="false"/>
</attribute>
<attribute mnemonic="GEN" descriptor="Gender" timeRange="datetime" knotRange="GEN">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="767.42" y="232.50" fixed="false"/>
</attribute>
<attribute mnemonic="VFQ" descriptor="VisitationFrequency" timeRange="datetime" knotRange="VFQ">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="739.69" y="330.21" fixed="true"/>
</attribute>
<layout x="650.76" y="366.73" fixed="true"/>
</anchor>
<anchor mnemonic="CH" descriptor="Channel" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="NAM" descriptor="Name" dataRange="varchar(255)">
<metadata capsule="dbo"/>
<layout x="1157.18" y="166.14" fixed="false"/>
</attribute>
<layout x="1101.95" y="246.78" fixed="false"/>
</anchor>
<anchor mnemonic="MP" descriptor="MarketPlan" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="PFR" descriptor="PeriodFrom" dataRange="datetime">
<metadata capsule="dbo"/>
<layout x="1749.04" y="445.01" fixed="false"/>
</attribute>
<attribute mnemonic="PTO" descriptor="PeriodTo" dataRange="datetime">
<metadata capsule="dbo"/>
<layout x="1707.86" y="486.53" fixed="false"/>
</attribute>
<layout x="1646.95" y="445.92" fixed="false"/>
</anchor>
<anchor mnemonic="ID" descriptor="Identification" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="IMT" descriptor="Method" knotRange="IMT">
<metadata capsule="dbo"/>
<layout x="849.59" y="584.91" fixed="false"/>
</attribute>
<layout x="751.39" y="593.76" fixed="true"/>
</anchor>
<anchor mnemonic="HH" descriptor="Household" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="NUM" descriptor="Number" dataRange="bigint">
<metadata capsule="dbo"/>
<layout x="718.00" y="-220.65" fixed="false"/>
</attribute>
<attribute mnemonic="HTP" descriptor="Type" timeRange="datetime" knotRange="HTP">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="785.21" y="-276.67" fixed="false"/>
</attribute>
<layout x="736.64" y="-127.99" fixed="false"/>
</anchor>
<anchor mnemonic="SG" descriptor="StoreGroup" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="NAM" descriptor="Name" timeRange="datetime" dataRange="varchar(255)">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="-340.70" y="461.22" fixed="false"/>
</attribute>
<layout x="-258.08" y="431.11" fixed="false"/>
</anchor>
<anchor mnemonic="OF" descriptor="Offer" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="NUM" descriptor="Number" dataRange="int">
<metadata capsule="dbo"/>
<layout x="1349.96" y="243.71" fixed="false"/>
</attribute>
<attribute mnemonic="VFR" descriptor="ValidFrom" dataRange="datetime">
<metadata capsule="dbo"/>
<layout x="1356.89" y="401.52" fixed="false"/>
</attribute>
<attribute mnemonic="VTO" descriptor="ValidTo" dataRange="datetime">
<metadata capsule="dbo"/>
<layout x="1270.83" y="425.47" fixed="true"/>
</attribute>
<attribute mnemonic="CON" descriptor="Condition" dataRange="varchar(255)">
<metadata capsule="dbo"/>
<layout x="1378.55" y="324.86" fixed="false"/>
</attribute>
<attribute mnemonic="EXP" descriptor="Explanation" dataRange="varchar(255)">
<metadata capsule="dbo"/>
<layout x="1360.15" y="275.82" fixed="false"/>
</attribute>
<attribute mnemonic="OTP" descriptor="Type" knotRange="OTP">
<metadata capsule="dbo"/>
<layout x="1488.21" y="345.12" fixed="false"/>
</attribute>
<attribute mnemonic="TGP" descriptor="TargetGroup" knotRange="TGP">
<metadata capsule="dbo"/>
<layout x="1476.27" y="265.93" fixed="false"/>
</attribute>
<layout x="1297.10" y="339.74" fixed="true"/>
</anchor>
<anchor mnemonic="PD" descriptor="PurchaseDetail" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="AMT" descriptor="Amount" dataRange="money">
<metadata capsule="dbo"/>
<layout x="1027.67" y="1129.39" fixed="false"/>
</attribute>
<attribute mnemonic="REB" descriptor="Rebate" dataRange="money">
<metadata capsule="dbo"/>
<layout x="986.40" y="1178.23" fixed="false"/>
</attribute>
<attribute mnemonic="QUA" descriptor="Quantity" dataRange="decimal(9,3)">
<metadata capsule="dbo"/>
<layout x="916.44" y="1203.83" fixed="false"/>
</attribute>
<attribute mnemonic="ORD" descriptor="Ordinal" dataRange="int">
<metadata capsule="dbo"/>
<layout x="959.96" y="1213.65" fixed="false"/>
</attribute>
<attribute mnemonic="QTP" descriptor="QuantificationType" knotRange="QTP">
<metadata capsule="dbo"/>
<layout x="1058.20" y="1211.27" fixed="false"/>
</attribute>
<layout x="931.85" y="1087.72" fixed="true"/>
</anchor>
<anchor mnemonic="IT" descriptor="Item" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="NUM" descriptor="Number" dataRange="int">
<metadata capsule="dbo"/>
<layout x="88.88" y="1095.82" fixed="false"/>
</attribute>
<attribute mnemonic="NAM" descriptor="Name" timeRange="datetime" dataRange="varchar(255)">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="53.35" y="980.27" fixed="false"/>
</attribute>
<attribute mnemonic="EAN" descriptor="EAN" timeRange="datetime" dataRange="varchar(255)">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="104.86" y="1071.19" fixed="false"/>
</attribute>
<attribute mnemonic="LCO" descriptor="LogisticsCost" timeRange="datetime" dataRange="money">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="23.97" y="1034.35" fixed="false"/>
</attribute>
<attribute mnemonic="PCO" descriptor="PurchaseCost" timeRange="datetime" dataRange="money">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="224.04" y="1024.90" fixed="false"/>
</attribute>
<attribute mnemonic="SIZ" descriptor="Size" timeRange="datetime" knotRange="ISZ">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="0.13" y="1109.22" fixed="false"/>
</attribute>
<attribute mnemonic="COL" descriptor="Color" timeRange="datetime" knotRange="ICO">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="59.88" y="1199.42" fixed="false"/>
</attribute>
<layout x="142.58" y="1008.31" fixed="true"/>
</anchor>
<anchor mnemonic="ST" descriptor="Store" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="NUM" descriptor="Number" dataRange="int">
<metadata capsule="dbo"/>
<layout x="343.93" y="494.27" fixed="false"/>
</attribute>
<attribute mnemonic="NAM" descriptor="Name" timeRange="datetime" dataRange="varchar(255)">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="187.75" y="494.43" fixed="false"/>
</attribute>
<attribute mnemonic="REV" descriptor="Revenue" timeRange="datetime" dataRange="money">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="301.27" y="567.49" fixed="false"/>
</attribute>
<attribute mnemonic="ODT" descriptor="OpeningDate" dataRange="datetime">
<metadata capsule="dbo"/>
<layout x="309.91" y="441.24" fixed="false"/>
</attribute>
<attribute mnemonic="SCL" descriptor="Classification" timeRange="datetime" knotRange="SCL">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="95.18" y="459.77" fixed="false"/>
</attribute>
<layout x="263.92" y="492.81" fixed="true"/>
</anchor>
<anchor mnemonic="IP" descriptor="ItemPrice" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="PRC" descriptor="Price" timeRange="datetime" dataRange="money">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="-275.67" y="1023.84" fixed="false"/>
</attribute>
<layout x="-190.71" y="980.93" fixed="false"/>
</anchor>
<anchor mnemonic="PA" descriptor="Payment" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="AMT" descriptor="Amount" dataRange="money">
<metadata capsule="dbo"/>
<layout x="1055.27" y="731.85" fixed="false"/>
</attribute>
<attribute mnemonic="DAT" descriptor="Date" dataRange="date">
<metadata capsule="dbo"/>
<layout x="988.55" y="809.08" fixed="false"/>
</attribute>
<attribute mnemonic="TIM" descriptor="Time" dataRange="time">
<metadata capsule="dbo"/>
<layout x="1012.92" y="783.12" fixed="false"/>
</attribute>
<attribute mnemonic="PME" descriptor="Method" knotRange="PME">
<metadata capsule="dbo"/>
<layout x="1124.07" y="794.70" fixed="false"/>
</attribute>
<layout x="953.19" y="728.30" fixed="true"/>
</anchor>
<anchor mnemonic="LO" descriptor="Location" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="LAT" descriptor="Latitude" dataRange="varchar(255)">
<metadata capsule="dbo"/>
<layout x="156.10" y="7.09" fixed="false"/>
</attribute>
<attribute mnemonic="LON" descriptor="Longitude" dataRange="varchar(255)">
<metadata capsule="dbo"/>
<layout x="189.06" y="4.42" fixed="false"/>
</attribute>
<layout x="214.97" y="115.99" fixed="true"/>
</anchor>
<anchor mnemonic="IN" descriptor="Inventory" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="QUA" descriptor="Quantity" dataRange="int">
<metadata capsule="dbo"/>
<layout x="100.03" y="829.54" fixed="false"/>
</attribute>
<attribute mnemonic="STI" descriptor="SnapshotTime" dataRange="datetime">
<metadata capsule="dbo"/>
<layout x="-7.02" y="843.69" fixed="false"/>
</attribute>
<layout x="65.08" y="799.53" fixed="false"/>
</anchor>
<anchor mnemonic="CA" descriptor="Card" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="NUM" descriptor="Number" dataRange="varchar(255)">
<metadata capsule="dbo"/>
<layout x="1054.07" y="499.04" fixed="false"/>
</attribute>
<attribute mnemonic="ISD" descriptor="IssueDate" timeRange="datetime" dataRange="datetime">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="1052.73" y="533.76" fixed="false"/>
</attribute>
<attribute mnemonic="VTH" descriptor="ValidThru" timeRange="datetime" dataRange="datetime">
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="1007.84" y="587.47" fixed="false"/>
</attribute>
<attribute mnemonic="CTP" descriptor="Type" knotRange="CTP">
<metadata capsule="dbo"/>
<layout x="1058.59" y="459.25" fixed="false"/>
</attribute>
<layout x="946.29" y="535.12" fixed="true"/>
</anchor>
<anchor mnemonic="AD" descriptor="Address" identity="int">
<metadata capsule="dbo" generator="false"/>
<attribute mnemonic="STR" descriptor="Street" dataRange="varchar(255)">
<metadata capsule="dbo"/>
<layout x="465.02" y="-21.43" fixed="false"/>
</attribute>
<attribute mnemonic="POC" descriptor="PostalCode" dataRange="varchar(255)">
<metadata capsule="dbo"/>
<layout x="430.92" y="-17.47" fixed="false"/>
</attribute>
<attribute mnemonic="CIT" descriptor="City" dataRange="varchar(255)">
<metadata capsule="dbo"/>
<layout x="433.24" y="-45.60" fixed="false"/>
</attribute>
<attribute mnemonic="CNT" descriptor="Country" dataRange="varchar(255)">
<metadata capsule="dbo"/>
<layout x="405.17" y="-0.64" fixed="false"/>
</attribute>
<layout x="433.19" y="71.35" fixed="true"/>
</anchor>
<tie>
<anchorRole role="is" type="PD" identifier="true"/>
<anchorRole role="partOfBasket" type="PU" identifier="false"/>
<metadata capsule="dbo"/>
<layout x="900.02" y="1070.45" fixed="false"/>
</tie>
<tie>
<anchorRole role="was" type="OF" identifier="true"/>
<anchorRole role="distributed" type="CH" identifier="true"/>
<metadata capsule="dbo"/>
<layout x="1231.57" y="246.11" fixed="false"/>
</tie>
<tie>
<anchorRole role="is" type="AD" identifier="true"/>
<anchorRole role="containedIn" type="AE" identifier="false"/>
<metadata capsule="dbo"/>
<layout x="301.38" y="217.46" fixed="true"/>
</tie>
<tie>
<anchorRole role="parent" type="AE" identifier="true"/>
<anchorRole role="child" type="AE" identifier="true"/>
<knotRole role="level" type="AEL" identifier="true"/>
<metadata capsule="dbo"/>
<layout x="-6.73" y="170.59" fixed="false"/>
</tie>
<tie>
<anchorRole role="parent" type="SG" identifier="true"/>
<anchorRole role="child" type="SG" identifier="true"/>
<knotRole role="level" type="SGL" identifier="true"/>
<metadata capsule="dbo"/>
<layout x="-392.65" y="403.05" fixed="false"/>
</tie>
<tie>
<anchorRole role="the" type="CU" identifier="true"/>
<anchorRole role="uses" type="ID" identifier="true"/>
<metadata capsule="dbo"/>
<layout x="731.83" y="474.02" fixed="false"/>
</tie>
<tie>
<anchorRole role="the" type="RG" identifier="true"/>
<anchorRole role="placedIn" type="ST" identifier="false"/>
<metadata capsule="dbo"/>
<layout x="401.28" y="665.56" fixed="false"/>
</tie>
<tie timeRange="datetime">
<anchorRole role="in" type="PL" identifier="false"/>
<anchorRole role="isContained" type="IP" identifier="true"/>
<knotRole role="status" type="EXP" identifier="false"/>
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="-143.47" y="840.86" fixed="false"/>
</tie>
<tie>
<anchorRole role="wasRealized" type="PU" identifier="true"/>
<anchorRole role="at" type="RG" identifier="false"/>
<metadata capsule="dbo"/>
<layout x="667.74" y="921.76" fixed="false"/>
</tie>
<tie timeRange="datetime">
<anchorRole role="made" type="CU" identifier="true"/>
<anchorRole role="purchaseIn" type="ST" identifier="true"/>
<knotRole role="is" type="ROT" identifier="false"/>
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="466.54" y="436.61" fixed="true"/>
</tie>
<tie>
<anchorRole role="has" type="IT" identifier="true"/>
<anchorRole role="an" type="IP" identifier="true"/>
<metadata capsule="dbo"/>
<layout x="-44.97" y="1011.44" fixed="false"/>
</tie>
<tie timeRange="datetime">
<anchorRole role="at" type="ST" identifier="true"/>
<anchorRole role="isUsed" type="PL" identifier="true"/>
<knotRole role="status" type="EXP" identifier="false"/>
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="61.49" y="629.69" fixed="false"/>
</tie>
<tie>
<anchorRole role="the" type="ST" identifier="true"/>
<anchorRole role="groups" type="SG" identifier="true"/>
<metadata capsule="dbo"/>
<layout x="-0.25" y="471.39" fixed="false"/>
</tie>
<tie timeRange="datetime">
<anchorRole role="is" type="CU" identifier="true"/>
<anchorRole role="includedIn" type="HH" identifier="true"/>
<knotRole role="owner" type="HOW" identifier="false"/>
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="693.68" y="87.45" fixed="false"/>
</tie>
<tie timeRange="datetime">
<anchorRole role="lives" type="CU" identifier="true"/>
<anchorRole role="at" type="AD" identifier="false"/>
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="536.04" y="189.51" fixed="false"/>
</tie>
<tie>
<anchorRole role="to" type="CU" identifier="true"/>
<anchorRole role="wasGiven" type="OF" identifier="true"/>
<anchorRole role="over" type="CH" identifier="true"/>
<knotRole role="belongingTo" type="CGP" identifier="false"/>
<metadata capsule="dbo"/>
<layout x="984.19" y="321.97" fixed="false"/>
</tie>
<tie>
<anchorRole role="paidWith" type="PA" identifier="true"/>
<anchorRole role="was" type="PU" identifier="false"/>
<metadata capsule="dbo"/>
<layout x="911.93" y="860.10" fixed="false"/>
</tie>
<tie>
<anchorRole role="parent" type="IG" identifier="true"/>
<anchorRole role="child" type="IG" identifier="true"/>
<knotRole role="level" type="IGL" identifier="true"/>
<metadata capsule="dbo"/>
<layout x="320.96" y="1304.69" fixed="false"/>
</tie>
<tie>
<anchorRole role="the" type="IT" identifier="true"/>
<anchorRole role="groups" type="IG" identifier="true"/>
<metadata capsule="dbo"/>
<layout x="216.65" y="1113.14" fixed="false"/>
</tie>
<tie>
<anchorRole role="bought" type="PD" identifier="true"/>
<anchorRole role="item" type="IT" identifier="false"/>
<metadata capsule="dbo"/>
<layout x="522.13" y="1005.14" fixed="true"/>
</tie>
<tie>
<anchorRole role="located" type="AD" identifier="true"/>
<anchorRole role="at" type="LO" identifier="true"/>
<metadata capsule="dbo"/>
<layout x="312.72" y="18.09" fixed="false"/>
</tie>
<tie>
<anchorRole role="is" type="CA" identifier="true"/>
<anchorRole role="an" type="ID" identifier="false"/>
<metadata capsule="dbo"/>
<layout x="847.18" y="520.53" fixed="false"/>
</tie>
<tie>
<anchorRole role="at" type="PU" identifier="true"/>
<anchorRole role="used" type="ID" identifier="true"/>
<metadata capsule="dbo"/>
<layout x="795.35" y="803.52" fixed="false"/>
</tie>
<tie>
<anchorRole role="has" type="ST" identifier="false"/>
<anchorRole role="an" type="IN" identifier="true"/>
<metadata capsule="dbo"/>
<layout x="172.80" y="660.82" fixed="false"/>
</tie>
<tie>
<anchorRole role="to" type="CU" identifier="true"/>
<anchorRole role="wasSent" type="OF" identifier="true"/>
<anchorRole role="to" type="AD" identifier="true"/>
<metadata capsule="dbo"/>
<layout x="952.49" y="-0.11" fixed="true"/>
</tie>
<tie timeRange="datetime">
<anchorRole role="for" type="ST" identifier="true"/>
<anchorRole role="isCaptured" type="AE" identifier="true"/>
<knotRole role="with" type="CMA" identifier="false"/>
<metadata capsule="dbo" restatable="false" idempotent="true"/>
<layout x="195.60" y="368.34" fixed="false"/>
</tie>
<tie>
<anchorRole role="located" type="AE" identifier="true"/>
<anchorRole role="at" type="LO" identifier="true"/>
<metadata capsule="dbo"/>
<layout x="68.28" y="97.73" fixed="false"/>
</tie>
<tie>
<anchorRole role="is" type="OF" identifier="true"/>
<anchorRole role="containedIn" type="MP" identifier="true"/>
<metadata capsule="dbo"/>
<layout x="1482.83" y="412.66" fixed="false"/>
</tie>
<tie>
<anchorRole role="in" type="IN" identifier="false"/>
<anchorRole role="inStock" type="IT" identifier="true"/>
<metadata capsule="dbo"/>
<layout x="78.23" y="921.47" fixed="false"/>
</tie>
<tie>
<anchorRole role="the" type="CA" identifier="true"/>
<anchorRole role="owns" type="CU" identifier="false"/>
<metadata capsule="dbo"/>
<layout x="825.79" y="446.92" fixed="false"/>
</tie>
<tie>
<anchorRole role="resides" type="ST" identifier="true"/>
<anchorRole role="at" type="AD" identifier="false"/>
<metadata capsule="dbo"/>
<layout x="352.54" y="279.54" fixed="false"/>
</tie>
<tie>
<anchorRole role="rebate" type="PD" identifier="true"/>
<anchorRole role="cause" type="OF" identifier="false"/>
<metadata capsule="dbo"/>
<layout x="1320.34" y="690.70" fixed="true"/>
</tie>
</schema>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment