Naming convention of Table and Fields name.

Question

Hello All,

 

I need to create the database of my application, so I am a bit confused about naming convention for database tables name and field names.

 

Requirments:

Need to create three types of tables in the database.

1. Master tables.

2. Transaction tables.

3. Enum/lookup tables.

 

now, what naming convention, I need to apply here to differentiate b/w all of them.  

 

Like (M or M_ or Mas represent the master)

MClient or M_Client or MasClient.

and same way for Lookup/Enum tables

 

LAddressType or EnAddressType.

 

please share some suggestions over it.

 

Thanks.