 
 ------ User Subjects, Responses > Triggers
 
-create trigger update_user_subject_modified before update on sg_public.user_subject for each row execute procedure sg_private.update_modified_column();
--- todo comment
-
-create trigger update_response_modified before update on sg_public.response for each row execute procedure sg_private.update_modified_column();
--- todo comment
-
-/* TODO 
+create trigger update_user_subject_modified
+  before update on sg_public.user_subject
+  for each row execute procedure sg_private.update_modified_column();
+-- todo comment
+
+create trigger update_response_modified
+  before update on sg_public.response
+  for each row execute procedure sg_private.update_modified_column();
+-- todo comment
+
+/* TODO
 - Trigger: Create response ->
   - Update p(learned)
   - Calculate updated guess value


------ Topics, Posts, Notices, Follows > Triggers (todo)

create trigger update_topic_modified before update on sg_public.topic for each row execute procedure sg_private.update_modified_column(); -- todo comment

create trigger update_post_modified before update on sg_public.post for each row execute procedure sg_private.update_modified_column(); -- todo comment

create trigger update_notice_modified before update on sg_public.notice for each row execute procedure sg_private.update_modified_column(); -- todo comment

create trigger update_follow_modified before update on sg_public.follow for each row execute procedure sg_private.update_modified_column(); -- todo comment

-- TODO Trigger: when I create or update a vote post, we can update entity status



------ Cards, Units, Subjects > Triggers

create trigger update_unit_modified
  before update on sg_public.unit_version
  for each row execute procedure sg_private.update_modified_column(); -- TODO comment

create trigger update_subject_modified
  before update on sg_public.subject_version
  for each row execute procedure sg_private.update_modified_column();  -- TODO comment

create trigger update_card_modified
  before update on sg_public.card_version
  for each row execute procedure sg_private.update_modified_column();  -- TODO comment

create trigger update_card_parameters_modified
  before update on sg_public.card_parameters
  for each row execute procedure sg_private.update_modified_column();  -- TODO comment

------ Cards, Units, Subjects > Capabilities (TODO)

