I have had very good success adding these columns to all my tables (all with simple indexes)

cUserIns Char(24)

tDtIns DateTime

cUserUpd Char(24)

tDtUps DateTime

cUserDel Char(24)

tDtDel DateTime

iDel Int

default value for iDel is...