Alter SMALLINT to INT for ID fields and add views table.