added necessary column for parts table
updated inventory queries for normalized tables