   `id` BIGINT PRIMARY KEY,
   `canvas_id` BIGINT,
   `submission_id` BIGINT,
-  `recipient_id` BIGINT,
+  `recipient_id` BIGINT COMMENT '(Deprecated) No longer used in Canvas.',
   `author_id` BIGINT,
   `assessment_request_id` BIGINT,
   `group_comment_id` VARCHAR(256),

DROP TABLE IF EXISTS assignment_rule_dim;
CREATE TABLE IF NOT EXISTS assignment_rule_dim (
  `assignment_id` BIGINT COMMENT 'ID of the assignment which can never be dropped from the group.',
  `drop_rule` VARCHAR(256) COMMENT 'Denotes if the assignment can be dropped from the assignment group if the group allows dropping assignments based on certain rules. Is set to \'never_drop\' is the assignment is exempted from dropping else set to \'can_be_dropped\'.'
) ENGINE = MyISAM DEFAULT CHARSET=utf8 COMMENT = "Rules associated with an assignment.";
DROP TABLE IF EXISTS submission_dim;
CREATE TABLE IF NOT EXISTS submission_dim (

  `account_id` BIGINT COMMENT 'Foreign key to the accounts table that this wiki belongs to. Helpful for directly finding the account associated with the wiki, irrespective of whether it belongs to a Course or a Group.',
  `root_account_id` BIGINT COMMENT 'Root account Id of the account the wiki belongs to. Foreign key to the accounts table.',
  `enrollment_term_id` BIGINT COMMENT 'Foreign key to the enrollment term table of the course this wiki is associated with. Otherwise this is set to NULL.',
  `group_category_id` BIGINT COMMENT '(Not implemented) Foreign key to the group categories table of the group this wiki is associated with. Otherwise this is set to NULL.'
) ENGINE = MyISAM DEFAULT CHARSET=utf8 COMMENT = "Measures for wikis.";
DROP TABLE IF EXISTS wiki_page_dim;
CREATE TABLE IF NOT EXISTS wiki_page_dim (
