db.clj

(defembedded Grade
  [:scored
   :possible
   :percentage])

(defentity Scorecard
  [#_ :questionnaire-id ;not needed? use client's questionnaire-id
   #_ :questionnaire-title ;also not needed?
   :operator {:type Employee}
   :evaluator {:type Employee}
   :client {:type Client}
   :call-date
   :timestamp
   :notes
   :questions {:type :references :of Question}
   :grade {:type Grade}]
  (index (desc :timestamp))
  (index (desc :call-date))
  (index (asc :evaluator))
  (index (asc :operator))
  (index (asc :client))
  (index (desc :grade)))