                      ;; qualitative
                      [:score_type :varchar]
                      [:qualitative_notes :text]
+
+                     ;; NOTE: no status field here; use our current
+                     ;; enrollments table for status for now.
+
                      [:date_created "TIMESTAMP WITH TIME ZONE" "NOT NULL" "DEFAULT CURRENT_TIMESTAMP"]]
+
+              ;; Note that a user may have more than one relationship
+              ;; to a comp, if she started and then decided to hold
+              ;; off and take it much later.
               :primary-key [:sis_user_id :comp_id :start_date]
               :indices {:user2comp_id_ux [[:id] :unique]
                         :user2comp_u_ix [[:sis_user_id]]

                   :indices {:comp2perf_asmt_id_ux [[:id] :unique]}
                   :foreign-keys {:comp2perf_asmt_c_fk [:comp_id :comp :id]
                                  :comp2perf_asmt_pa_fk [:perf_asmt_id :perf_asmt :id]}}
  :user2comp {:cols [[:id :bigserial]

                     [:sis_user_id :bigint]

                                              :comp_tag_disp_ctx2comp_tag_ct_fk
                                              [:comp_tag_id :comp_tag :id]}
                               :indices {:comp_tag_disp_ctx2comp_tag_id_ux [[:id] :unique]}}

  ;; All of VLACS old competencies will be represented in the
  ;; perf_asmt table in order to show that students use[d] them to
  ;; demonstrate competency.
  :perf_asmt {:cols [[:id :bigserial]
                     [:id_sk :varchar]
                     [:name :varchar]
