title: Naming a FK for a Post Author
body: <p>I have the following tables</p>
  
  <pre><code>create table dbo.Users (
    UserId int identity not null,
    Name nvarchar (400) not null
  )
  
  create table dbo.Posts (
    PostId int identity not null,
    UserId int not null,
    Title nvarchar (400) not null,
    Content nvarchar (max) not null,
  )
  </code></pre>
  
  <p>On table Posts UserId is the author of the post and it is a FK to Users.UserId PK. </p>
  
  <p>In this situations should I name the column UserId which is clear what the relation is or AuthorId describing of it is withing the post?</p>
  
  <p>What is the most common approach for this naming?</p>