Skip to content

Instantly share code, notes, and snippets.

@Roenbaeck
Created August 11, 2022 10:03
Show Gist options
  • Save Roenbaeck/08d5639538736921225b6cb39d0e375e to your computer and use it in GitHub Desktop.
Save Roenbaeck/08d5639538736921225b6cb39d0e375e to your computer and use it in GitHub Desktop.
Example Anchor Model
<schema format="0.99.9.9" date="2022-08-11" time="12:01:14">
<metadata changingRange="datetime" encapsulation="dbo" identity="int" metadataPrefix="Metadata" metadataType="int" metadataUsage="true" changingSuffix="ChangedAt" identitySuffix="ID" positIdentity="int" positGenerator="true" positingRange="datetime" positingSuffix="PositedAt" positorRange="tinyint" positorSuffix="Positor" reliabilityRange="decimal(5,2)" reliabilitySuffix="Reliability" defaultReliability="1" deleteReliability="0" assertionSuffix="Assertion" partitioning="false" entityIntegrity="true" restatability="true" idempotency="false" assertiveness="true" naming="improved" positSuffix="Posit" annexSuffix="Annex" chronon="datetime2(7)" now="sysdatetime()" dummySuffix="Dummy" versionSuffix="Version" statementTypeSuffix="StatementType" checksumSuffix="Checksum" businessViews="false" decisiveness="true" equivalence="false" equivalentSuffix="EQ" equivalentRange="tinyint" databaseTarget="SQLServer" temporalization="uni" deletability="false" deletablePrefix="Deletable" deletionSuffix="Deleted" privacy="Ignore" checksum="false" triggers="true" knotAliases="false"/>
<knot mnemonic="PAT" descriptor="ParentalType" identity="tinyint" dataRange="varchar(42)">
<metadata capsule="dbo" generator="false"/>
<layout x="835.96" y="384.13" fixed="false"/>
</knot>
<knot mnemonic="GEN" descriptor="Gender" identity="bit" dataRange="varchar(42)">
<metadata capsule="dbo" generator="false"/>
<layout x="668.15" y="282.46" fixed="false"/>
</knot>
<knot mnemonic="PLV" descriptor="ProfessionalLevel" identity="tinyint" dataRange="varchar(max)">
<metadata capsule="dbo" generator="false" checksum="true"/>
<layout x="540.25" y="377.60" fixed="false"/>
</knot>
<knot mnemonic="UTL" descriptor="Utilization" identity="tinyint" dataRange="tinyint">
<metadata capsule="dbo" generator="false"/>
<layout x="188.21" y="991.67" fixed="false"/>
</knot>
<knot mnemonic="ONG" descriptor="Ongoing" identity="tinyint" dataRange="varchar(3)">
<metadata capsule="dbo" generator="false"/>
<layout x="890.08" y="471.43" fixed="false"/>
</knot>
<knot mnemonic="RAT" descriptor="Rating" identity="tinyint" dataRange="varchar(42)">
<metadata capsule="dbo" generator="false"/>
<layout x="499.63" y="552.58" fixed="false"/>
</knot>
<anchor mnemonic="PE" descriptor="Performance" identity="int">
<metadata capsule="dbo" generator="true"/>
<attribute mnemonic="DAT" descriptor="Date" dataRange="datetime">
<metadata privacy="Ignore" capsule="dbo" idempotent="false" deletable="false"/>
<key stop="1" route="1st" of="PE" branch="1"/>
<layout x="718.62" y="991.91" fixed="false"/>
</attribute>
<attribute mnemonic="AUD" descriptor="Audience" dataRange="int">
<metadata privacy="Ignore" capsule="dbo" idempotent="false" deletable="false"/>
<layout x="676.06" y="983.25" fixed="false"/>
</attribute>
<attribute mnemonic="REV" descriptor="Revenue" dataRange="money">
<metadata privacy="Ignore" capsule="dbo" idempotent="false" deletable="false"/>
<layout x="792.10" y="899.37" fixed="false"/>
</attribute>
<layout x="687.73" y="893.93" fixed="false"/>
</anchor>
<anchor mnemonic="EV" descriptor="Event" identity="int">
<metadata capsule="dbo" generator="true"/>
<layout x="881.02" y="976.23" fixed="false"/>
</anchor>
<anchor mnemonic="ST" descriptor="Stage" identity="int">
<metadata capsule="dbo" generator="true"/>
<attribute mnemonic="NAM" descriptor="Name" timeRange="datetime" dataRange="varchar(42)">
<metadata privacy="Ignore" capsule="dbo" restatable="true" idempotent="false" deletable="false"/>
<layout x="405.47" y="1021.03" fixed="false"/>
</attribute>
<attribute mnemonic="LOC" descriptor="Location" dataRange="geography">
<metadata privacy="Ignore" capsule="dbo" checksum="true" idempotent="false" deletable="false"/>
<key stop="1" route="1st" of="ST" branch="1"/>
<key stop="4" route="1st" of="PE" branch="2"/>
<layout x="373.67" y="899.58" fixed="false"/>
</attribute>
<attribute mnemonic="AVG" descriptor="Average" timeRange="datetime" knotRange="UTL">
<metadata privacy="Ignore" capsule="dbo" restatable="true" idempotent="false" deletable="false"/>
<layout x="291.49" y="991.97" fixed="false"/>
</attribute>
<attribute mnemonic="MIN" descriptor="Minimum" knotRange="UTL">
<metadata privacy="Ignore" capsule="dbo" idempotent="false" deletable="false"/>
<layout x="262.56" y="950.93" fixed="false"/>
</attribute>
<layout x="405.11" y="939.14" fixed="false"/>
</anchor>
<anchor mnemonic="AC" descriptor="Actor" identity="int">
<metadata capsule="dbo" generator="true"/>
<attribute mnemonic="NAM" descriptor="Name" timeRange="datetime" dataRange="varchar(42)">
<metadata privacy="Ignore" capsule="dbo" restatable="true" idempotent="false" deletable="false"/>
<key stop="1" route="1st" of="AC" branch="1"/>
<layout x="718.59" y="436.85" fixed="false"/>
</attribute>
<attribute mnemonic="GEN" descriptor="Gender" knotRange="GEN">
<metadata privacy="Ignore" capsule="dbo" idempotent="false" deletable="false"/>
<layout x="669.99" y="382.61" fixed="false"/>
</attribute>
<attribute mnemonic="PLV" descriptor="ProfessionalLevel" timeRange="datetime" knotRange="PLV">
<metadata privacy="Ignore" capsule="dbo" restatable="true" idempotent="false" deletable="false"/>
<layout x="591.77" y="432.01" fixed="false"/>
</attribute>
<layout x="687.76" y="506.95" fixed="false"/>
</anchor>
<anchor mnemonic="PR" descriptor="Program" identity="int">
<metadata capsule="dbo" generator="true"/>
<attribute mnemonic="NAM" descriptor="Name" dataRange="varchar(42)">
<metadata privacy="Ignore" capsule="dbo" idempotent="false" deletable="false"/>
<key stop="1" route="1st" of="PR" branch="1"/>
<key stop="7" route="1st" of="PE" branch="3"/>
<layout x="457.40" y="705.22" fixed="false"/>
</attribute>
<layout x="497.75" y="753.52" fixed="false"/>
</anchor>
<tie timeRange="datetime">
<anchorRole role="exclusive" type="AC" identifier="false"/>
<anchorRole role="with" type="AC" identifier="false"/>
<knotRole role="currently" type="ONG" identifier="false"/>
<metadata capsule="dbo" restatable="true" deletable="false" idempotent="false"/>
<layout x="807.73" y="494.71" fixed="false"/>
</tie>
<tie>
<anchorRole role="wasHeld" type="PE" identifier="true">
<key stop="2" route="1st" of="PE" branch="2"/>
</anchorRole>
<anchorRole role="at" type="ST" identifier="false">
<key stop="3" route="1st" of="PE" branch="2"/>
</anchorRole>
<metadata capsule="dbo" deletable="false" idempotent="false"/>
<layout x="548.62" y="954.67" fixed="false"/>
</tie>
<tie>
<anchorRole role="subset" type="PE" identifier="false"/>
<anchorRole role="of" type="EV" identifier="false"/>
<metadata capsule="dbo" deletable="false" idempotent="false"/>
<layout x="810.74" y="938.94" fixed="false"/>
</tie>
<tie>
<anchorRole role="at" type="PE" identifier="true">
<key stop="5" route="1st" of="PE" branch="3"/>
</anchorRole>
<anchorRole role="wasPlayed" type="PR" identifier="false">
<key stop="6" route="1st" of="PE" branch="3"/>
</anchorRole>
<metadata capsule="dbo" deletable="false" idempotent="false"/>
<layout x="605.72" y="812.41" fixed="false"/>
</tie>
<tie>
<anchorRole role="in" type="PE" identifier="true"/>
<anchorRole role="wasCast" type="AC" identifier="true"/>
<metadata capsule="dbo" deletable="false" idempotent="false"/>
<layout x="709.54" y="705.20" fixed="false"/>
</tie>
<tie timeRange="datetime">
<anchorRole role="part" type="AC" identifier="true"/>
<anchorRole role="in" type="PR" identifier="true"/>
<knotRole role="got" type="RAT" identifier="false"/>
<metadata capsule="dbo" restatable="true" deletable="false" idempotent="false"/>
<layout x="553.89" y="605.39" fixed="false"/>
</tie>
<tie timeRange="datetime">
<anchorRole role="at" type="ST" identifier="true"/>
<anchorRole role="isPlaying" type="PR" identifier="true"/>
<metadata capsule="dbo" restatable="true" deletable="false" idempotent="false"/>
<layout x="407.84" y="794.49" fixed="false"/>
</tie>
<tie>
<anchorRole role="parent" type="AC" identifier="true"/>
<anchorRole role="child" type="AC" identifier="true"/>
<knotRole role="having" type="PAT" identifier="true"/>
<metadata capsule="dbo" deletable="false" idempotent="false"/>
<layout x="781.12" y="432.62" fixed="false"/>
</tie>
<tie>
<anchorRole role="content" type="PR" identifier="false"/>
<anchorRole role="location" type="ST" identifier="false"/>
<anchorRole role="of" type="PE" identifier="true"/>
<metadata capsule="dbo" deletable="false" idempotent="false"/>
<layout x="525.52" y="879.18" fixed="false"/>
</tie>
</schema>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment