What table are field types stored in.

I am building a query to show the fields and all info. I have the fields table and would like to join on the table that shows what type of field it is. I need to know what table stores the values for the Field Type numbers