Naming convention of Table and Fields name.

Personally, I don't prefix anything to differentiat between master and client. I put tbl to all tables.

 

Try not to put underscores. Instead just use camel case as in tblClient.

 

If you do decide to prefix do not use mas, to be honest I have NEVER seen anyone using it. Use mst instead for master. And may be trn for transactions.

 

Again, never seen anyone differentiating as Enums. It is just programming construct support by language. Enums are in strictly technical sense, masters, so please treat them as such. In fact, when you put them in table, they don't remain enums they become master only.

 

For column names, do no unnecessaryly make names short, for example, fn_name, first_nm, etc. Have proper names, like first_name, etc. There were times when we were restricted to have column name in max 8 chars, not any more, so use it.

 

You can also choose to have camel case for column names such as FirstName. Whatever method you choose, please be consistent.