add utility methods
remove unused column
restructure account* activity