title: Unique (but mutable) identity column
body: <p>My system consist of React client app + ASP.NET Core API + SQL Server database. I have a db table called 'Titles':</p>
  
  <p><code>Id (Primary Key, nvarchar, not null)
  Name (nvarchar, not null)</code></p>
  
  <p>When I create a new title entity, I use a random Guid as Id. However, I want the client user to be able to use a unique (but mutable), friendly name to reach the page, something like:
  <a href="http://www.mywebsite.com/titles/friendly-title-name" rel="nofollow noreferrer">http://www.mywebsite.com/titles/friendly-title-name</a>
  instead of
  <a href="http://www.mywebsite.com/titles/31b18dba-4070-4b13-bab5-2fc57de9e3a9" rel="nofollow noreferrer">http://www.mywebsite.com/titles/31b18dba-4070-4b13-bab5-2fc57de9e3a9</a></p>
  
  <p>Is it a good practice to use the 'name' column for this purpose? So, apart from the unique, immutable, primary key 'Id', I would have unique, mutable column 'name' to identify an entity.</p>