Creating an auditing strategy when a user has been defined in a table instead of in SQL
Adding to what @DForck42 said- username is best left to the application layer. But since these tables don't have too many changes everyday,I would include a 

     IsDeleted (bit)


column and implement a soft delete (1 or 0).