changed default caseID for case detail object to a string
updated sql statements for normalized inventory table
auto format
remove unused code
update local db
sql queries update and allocation checkboxes