I'm perplexed as to why PJNOTES places four potential join fields into one key_value.

Do I have to parse the keyvalue to do lookups on other tables?

I'm mainly interested in getting the user, hours (both embedded in key_value) and notes(in PJNOTES.notes1) for each project.  Why didn't they just add project id as a field, date as a field I could perform joins on?

Or am I supposed to be using a different field in that table to do such lookups?