   `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 'Foreign key to the group categories table of the group 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 (

  ('enrollment_dim',0,NULL),
  ('enrollment_fact',0,NULL),
  ('enrollment_rollup_dim',0,NULL),
  ('group_dim',0,NULL),
  ('group_fact',0,NULL),
  ('group_membership_fact',0,NULL),

  `most_privileged_role` VARCHAR(256) COMMENT 'The most privileged role associated with the user in the course.',
  `least_privileged_role` VARCHAR(256) COMMENT 'The least privileged role associated with the user in the course.'
) ENGINE = MyISAM DEFAULT CHARSET=utf8 COMMENT = "Would be an empty table. Roll-up aggregating the roles held by the users in the courses they are associated with.";
DROP TABLE IF EXISTS file_dim;
CREATE TABLE IF NOT EXISTS file_dim (
  `id` BIGINT PRIMARY KEY COMMENT 'Unique surrogate ID for this file.',
  `canvas_id` BIGINT COMMENT 'Primary key for this file in the attachments table.',
  `display_name` LONGTEXT COMMENT 'Name of this file.',
  `account_id` BIGINT COMMENT 'Foreign key to the account this file belongs to.',
  `assignment_id` BIGINT COMMENT 'Foreign key to the assignment this file belongs to.',
  `conversation_message_id` BIGINT COMMENT 'Foreign key to the conversation message this file belongs to.',
  `course_id` BIGINT COMMENT 'Foreign key to the course this file belongs to.',
  `folder_id` BIGINT COMMENT 'Foreign key to the folder this file belongs to.',
  `group_id` BIGINT COMMENT 'Foreign key to the group this file belongs to.',
  `quiz_id` BIGINT COMMENT 'Foreign key to the quiz this file belongs to.',
  `quiz_submission_id` BIGINT COMMENT 'Foreign key to the quiz submission this file belongs to.',
  `replacement_file_id` BIGINT COMMENT 'ID of the overwriting file if this file is overwritten.',
  `root_file_id` BIGINT COMMENT 'ID of the source file from which this file was copied and created. Set to \'NULL\' when this is the only copy.',
  `submission_id` BIGINT COMMENT 'Foreign key to the submission this file belongs to.',
  `uploader_id` BIGINT COMMENT 'Foreign key to the user who uploaded this file. Might contain users which are not in the user dimension table.',
  `user_id` BIGINT COMMENT 'Foreign key to the user this file belongs to.',
  `owner_entity_type` ENUM('account', 'assignment', 'conversation_message', 'course', 'group', 'quiz', 'quiz_submission', 'submission', 'user') COMMENT 'Table this file is associated with.',
  `content_type` VARCHAR(256) COMMENT 'Contains the MIME type of this file.',
  `md5` VARCHAR(256) COMMENT 'Contains the MD5 checksum of the contents of this file.',
  `file_state` ENUM('available', 'broken', 'deleted', 'errored', 'hidden') COMMENT 'Denotes the current state of this file.',
  `could_be_locked` ENUM('allow_locking', 'disallow_locking') COMMENT 'Dictates if the quiz can be locked or not.',
  `locked` ENUM('is_locked', 'is_not_locked') COMMENT 'Denotes the current lock status of this file.',
  `lock_at` TIMESTAMP NULL COMMENT 'Date/Time when this file is to be locked.',
  `unlock_at` TIMESTAMP NULL COMMENT 'Date/Time when this file is to unlocked.',
  `viewed_at` TIMESTAMP NULL COMMENT 'Date/Time when this file was last viewed.',
  `created_at` TIMESTAMP NULL COMMENT 'Date/Time when this file was created.',
  `updated_at` TIMESTAMP NULL COMMENT 'Date/Time when this file was last updated.',
  `deleted_at` TIMESTAMP NULL COMMENT 'Date/Time when this file was deleted.'
) ENGINE = MyISAM DEFAULT CHARSET=utf8 COMMENT = "Attributes for files.";
DROP TABLE IF EXISTS file_fact;
CREATE TABLE IF NOT EXISTS file_fact (
  `file_id` BIGINT COMMENT 'Foreign key to this file dimesion table.',
  `account_id` BIGINT COMMENT 'Foreign key to the account this file belongs to.',
  `assignment_id` BIGINT COMMENT 'Foreign key to the assignment, the quiz/quiz submission/submission associated with this file belongs to.',
  `assignment_group_id` BIGINT COMMENT 'Foreign key to the assignment group, the assignment/submission associated with this file belongs to.',
  `conversation_id` BIGINT COMMENT 'Foreign key to the conversation, the conversation message associated with this file belongs to.',
  `conversation_message_author_id` BIGINT COMMENT 'Foreign key to the user, who authored the conversation message this file belongs to.',
  `conversation_message_id` BIGINT COMMENT 'Foreign key to the conversation message this file belongs to.',
  `course_id` BIGINT COMMENT 'Foreign key to the course, the assignment/quiz/quiz submission/submission associated with this file belongs to.',
  `enrollment_rollup_id` BIGINT COMMENT 'Foreign key to the enrollment roll-up, the quiz submission/submission associated with this file belongs to.',
  `enrollment_term_id` BIGINT COMMENT 'Foreign Key to enrollment term, the assignment/conversation message/group/quiz/quiz submission/submission associated with this file belongs to.',
  `folder_id` BIGINT COMMENT 'Foreign key to the folder this file belongs to.',
  `grader_id` BIGINT COMMENT 'Foreign key to the user who graded the submission associated with this file.',
  `group_id` BIGINT COMMENT 'Foreign key to the group this file belongs to.',
  `group_category_id` BIGINT COMMENT '(Not implemented) Foreign key to group category the group associated with this file belongs to.',
  `quiz_id` BIGINT COMMENT 'Foreign key to the quiz, the quiz/quiz submission associated with this file belongs to.',
  `quiz_submission_id` BIGINT COMMENT 'Foreign key to the quiz submission this file belongs to.',
  `replacement_file_id` BIGINT COMMENT 'Foreign key to the file which overwrote/replaced this file. Defaults to \'NULL\' when the file was not overwritten/replaced.',
  `root_file_id` BIGINT COMMENT 'Foreign key to the source file from which this file was copied and created. Defaults to \'NULL\' when this is the only copy.',
  `sis_source_id` VARCHAR(256) COMMENT 'Correlated ID for the record for the course, associated with this file, in the SIS system (assuming SIS integration is configured).',
  `submission_id` BIGINT COMMENT 'Foreign key to the submission this file belongs to.',
  `uploader_id` BIGINT COMMENT 'Foreign key to the user who uploaded this file. Might contain users which are not in the user dimension table.',
  `user_id` BIGINT COMMENT 'Foreign key to the user this file belongs to.',
  `wiki_id` BIGINT COMMENT 'Foreign key to the wiki the conversation message/group/submission associated with this file belongs to.',
  `size` BIGINT COMMENT 'Size of this file in bytes.'
) ENGINE = MyISAM DEFAULT CHARSET=utf8 COMMENT = "Measures for files.";
DROP TABLE IF EXISTS group_dim;
CREATE TABLE IF NOT EXISTS group_dim (
  `id` BIGINT PRIMARY KEY COMMENT 'Unique surrogate id for the group.',
