A convention I have recently used was:

tbl_ for main data tables

tbl_Stage for staging tables

vew_ for views

prc_NNN for procedures relating to reports where NNN was also used as part of the...