Database design - From support view

1.If there is update operation on a table, this table should has a "lastupdatedate" column to indicate when is the last update for trace or trouble shooting.

  Importantly, this column should not be used for other purposes!!

 

2.If there is a list value use in table data, like type, status .  there should be a separate table storeing all these values and descriptions for better maintenance purpose.