add column types on all of the columns

There are so many columns that don't have the column type, add them all up

I also have the ER diagram all drawn here:

http://content.screencast.com/users/grady.albumatic/folders/Jing/media/6b29d7a1-e318-4c85-a29a-2f353187b2f4/00000074.png

I just need to know the relationship between the tables, if someone can help me on that