Schema - Do you create a consistent primary key column on your tables?
Rules To Better SQL Databases - Developers|4e2c5421-72b9-46c2-b5c7-311882ec35fd
v1.0
Posted at
7/11/2019 5:24 AM by
Tiago Araujo
Rule Intro
Make sure you created a consistent primary key column named [TableName]+"ID" on your tables.
Page Content
Employee.EmployeeID
Figure: Good example
Employee.ID, Employee.Employee_Code, Employee.Employee
Figure: Bad example
{9DC11961-9EDE-4E90-8C37-44B9A5BA9BBC}
Do you feel this rule needs an update?