Advice on sql naming conventions -

i'm looking advice on sql naming conventions. know topic has been discussed before question little more specific , cannot find answer elsewhere.

i have integer variables - have name 'timeout'. there adopted standard prefixing/suffixing value know contains when come in 6 months time?

for instance 'timeoutmilliseconds'.

i'm not talking labelling every variable way, generic values.

lookup iso-11179 international database naming standard. can grab online free download (though sorry forget where). there lot in it, here some basic summary form it:

take field description, remove joining words , write backwards.

always end class name. there standard abbreviations id identifier , such.

eg: date of entry:

 entry_date 

seconds_for_delivery:

 delivery_seconds 

name of widget:

 widget_name 

location of widget:

 widget_location 

size of widget:

 widget_size 

also field should have same name if primary key or referenced foreign key. pay off in readability people come after you, , db tools assume matching keys save time in using reporting tools , (less manual stuffing around putting links in hand).

in above examples, class names date, seconds, name, location, size. surprises me iso not more known.