Skip to content

Instantly share code, notes, and snippets.

View Roenbaeck's full-sized avatar
🇸🇪
Thinking about information modeling

Lars Rönnbäck Roenbaeck

🇸🇪
Thinking about information modeling
22 followers · 6 following
View GitHub Profile
@Roenbaeck
Roenbaeck / iceberg.xml
Created August 11, 2022 23:13
Iceberg Exercise
<schema format="0.99" date="2016-05-27" time="15:31:03">
<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="crt"/>
<knot mnemonic="SOM" descriptor="SplitOrMerge"
@Roenbaeck
Roenbaeck / report_server.xml
Created August 11, 2022 23:09
ReportServer Reverse Engineered
<schema format="0.99" date="2016-11-17" time="13:23:50">
<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="tinyint" reliabilitySuffix="Reliability" deleteReliability="0" assertionSuffix="Assertion" partitioning="false" entityIntegrity="true" restatability="true" idempotency="false" assertiveness="false" naming="original" positSuffix="Posit" annexSuffix="Annex" chronon="datetime2(7)" now="sysdatetime()" dummySuffix="Dummy" versionSuffix="Version" statementTypeSuffix="StatementType" checksumSuffix="Checksum" businessViews="false" decisiveness="false" equivalence="false" equivalentSuffix="EQ" equivalentRange="tinyint" databaseTarget="SQLServer" temporalization="uni"/>
<knot mnemonic="VAL" descriptor="Validity" identit
@Roenbaeck
Roenbaeck / restaurant.xml
Created August 11, 2022 23:05
Restaurant Model
<schema><metadata format="0.94" temporalization="mono"/><knot mnemonic="TYP" descriptor="Type" identity="tinyint" dataRange="varchar(42)"><metadata capsule="dbo" generator="false"/><layout x="720.82" y="-19.71" fixed="false"/></knot><knot mnemonic="CUI" descriptor="Cuisine" identity="tinyint" dataRange="varchar(42)"><metadata capsule="dbo" generator="false"/><layout x="821.83" y="330.00" fixed="false"/></knot><knot mnemonic="EXP" descriptor="Expired" identity="bit" dataRange="char(1)"><metadata capsule="dbo" generator="false"/><layout x="547.68" y="235.11" fixed="false"/></knot><anchor mnemonic="CO" descriptor="Consumption" identity="int"><metadata capsule="dbo" generator="true"/><attribute mnemonic="DAT" descriptor="Date" dataRange="date"><metadata capsule="dbo"/><layout x="892.31" y="186.07" fixed="false"/></attribute><attribute mnemonic="AMT" descriptor="Amount" dataRange="int"><metadata capsule="dbo"/><layout x="796.13" y="76.62" fixed="false"/></attribute><layout x="830.46" y="140.58" fixed="false"/></an
@Roenbaeck
Roenbaeck / northwind.xml
Created August 11, 2022 23:03
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.2
@Roenbaeck
Roenbaeck / retail.xml
Created August 11, 2022 12:54
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
@Roenbaeck
Roenbaeck / example.xml
Created August 11, 2022 10:03
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" deletable
@Roenbaeck
Roenbaeck / gist:454d6c3e76be23628c0e4dab0a90969f
Last active October 30, 2021 22:55
Server selections

Midgard Companies in New World

This list was intended to keep track of companies on Midgard that formed pre-launch. Once we hit launch it will be difficult to keep track of all the companies that are created in-game. I may update this to some extent still, but I will also be focusing on playing the game now. My character is named Bareclad and is since November on the Grus server.

Note that there are long queues (https://newworldstatus.com/?sort=queue) and right now the server cap is at 2000 concurrent players. Prepare to have some fun content for everyone in your discords while people wait in line.

It looks like character migrations will be free in the next couple of weeks, but I am now sure how complicated it will be or when they can be done at the earliest (https://forums.newworld.com/t/launch-day-update/256595).

_Players should be aware that you need to select a faction in-game before you can join a company, and that you can only pick a company of the faction you selected. Follow the main qu