add foreign keys
fix todos
include project
cut way down on bid queries
remove todo