table , table [transaction]
or
table tuser, table ttransaction
the t prefix helps when it comes to some common reserved words.
I don't mind using t and v as prefixes on tables and views, when it comes to partitioned views the t prefix can be used,
since logically the partitioned view has the physical role of a table.
I also find it good to be able to easily distinguish between the 2 different objects (t+v) in code.
2 cents on why I like t + v prefixes on t+v database objects.
rockmoose
You must unlearn what You have learnt