added stateid and quantity cols to inventory table to eliminate need for join to resources table