not using hibernate anymore. fucking not worth it.

added view data to normalize data