Essential Database Design: Five Fields Every Table Must Have

Definitely not every table needs an audit trail, or soft delete capability.

Bolting this stuff on where it's not needed just leads to ... well the author apparently didn't think about that, now did they.