Schema - Do you create a consistent primary key column on your tables?
Rules To Better SQL Databases - Developers|4e2c5421-72b9-46c2-b5c7-311882ec35fd
v6.0
Posted at
29/01/2020 4:13 PM by
Christian Morford-Waite
Rule Intro
Make sure you created a consistent primary key column named Id on your tables.
Page Content
Employee.ID, Employee.EmployeeId, Employee.EmployeeID, Employee.Employee_Code, Employee.Employee
Figure: Bad Example
Employee.Id
Figure: Good Example
Why?
- We shouldn’t capitalise ID (identifier) as it is an abbreviation not an acronym.
- Using the approach [TableName]Id, e.g. EmployeeId, is redundant as we already know the context of the Id.
{9DC11961-9EDE-4E90-8C37-44B9A5BA9BBC}
Do you feel this rule needs an update?
