Eric M Russell (1/27/2015)
Regardless of datatype, I don't want to see a column names having no contextual prefix, meaning just "ID" by itself, on any table, and much less on every table.
I worked with a third party product like this:
create table Stuff (id int, something varchar(), ...)
create table Schedule (id int, StuffID int, TimeID int, something varchar(), ...)
create table Time (id int, BuildingID int, something varchar(), ...)
create table Building (id int, StuffID int, something varchar(), ...)