Sql naming best practice -

i'm not entirely sure if there's standard in industry or otherwise, i'm asking here.

i'm naming users table, , i'm not entirely sure how name members.

user_id obvious one, wonder if should prefix other fields "user_" or not.

user_name user_age

or name , age, etc...

prefixes pointless, unless have little more arbitrary; 2 addresses. might use address_1, address_2, address_home, etc

same phone numbers.

but static age, gender, username, etc; leave them that.

just show if prefix of fields, queries might this

select users.user_id users users.user_name = "jim" 

when be

select id users username = "jim"