updated tables for json type, and updated views for new column headers