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?