Nice thanks, I was finally able to design the schema for my dog turd tracker. The foreign key to the smells table was a great suggestion!