Home
Schema - Do you create a consistent primary key column on your tables?
  v1.0 Posted at 7/11/2019 5:24 AM by Tiago Araujo

Make sure you created a consistent primary key column named [TableName]+"ID" on your tables.​​

​ Employee.EmployeeID

Figure: Good example

Employee.ID, Employee.Employee_Code, Employee.Employee​

Figure: Bad example​​

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address:

    Comments: