The use case is simple. There's a category table with two unique keys one UUID possibly a nvarchar(32) while other IDENTITY column. For this case, assuming the UUID column as primary key while ID is unique. There's another ITEM child table which references the category table based on the unique ID column. The example project is already attached.