adds associations and some extra datetime fields