If your table is named Articles, do you name your column article_number or simply number? A question that I ask myself quite often is: If my table is named articles, should I name my column article_number or simply number?

Is there a best practice? Is there a difference if you create tables and columns in a database, or work in an abstract layer like an ORM, where the query would perhaps be

a = Article.get(1);
my_num = a.number;
// or 
my_num2 = a.article_number
I would do article_id. It is tempting to just make it "id" but when it starts becoming a FK in other tables, it is nice to have the column have the same name on both sides.