CanvasDataLevel1_042417_1330.sql

USE [CanvasDataLevel1]
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vWikiPage'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vWikiPage'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vWiki'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vWiki'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vUser'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vUser'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vSubmissionParticipantComment'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vSubmissionParticipantComment'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vSubmissionComment'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vSubmissionComment'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vSubmission'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vSubmission'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vScore'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vScore'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vRole'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vRole'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vRequests'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vRequests'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuizSubmissionHistorical'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuizSubmissionHistorical'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuizSubmission'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuizSubmission'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuizQuestionGroup'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuizQuestionGroup'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuizQuestionAnswer'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuizQuestionAnswer'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuizQuestion'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuizQuestion'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuiz'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuiz'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vPseudonym'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vPseudonym'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModuleProgressionCompletionRequirement'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModuleProgressionCompletionRequirement'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModuleProgression'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModuleProgression'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModulePrerequisite'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModulePrerequisite'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModuleItem'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModuleItem'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModuleCompletionRequirement'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModuleCompletionRequirement'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModule'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModule'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vGroupMembership'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vGroupMembership'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vGradingPeriodGroup'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vGradingPeriodGroup'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vGradingPeriod'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vGradingPeriod'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vFile'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vFile'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vExternalToolActivation'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vExternalToolActivation'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vEnrollmentTerm'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vEnrollmentTerm'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vEnrollmentRollup'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vEnrollmentRollup'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vEnrollment'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vEnrollment'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vDiscussionTopic'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vDiscussionTopic'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vDiscussionEntry'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vDiscussionEntry'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vCourseUINavigationItem'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vCourseUINavigationItem'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vCourseUICanvasNavigation'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vCourseUICanvasNavigation'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vCourseSection'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vCourseSection'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vCourse'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vCourse'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vConversationMessageParticipant'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vConversationMessageParticipant'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vConversationMessage'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vConversationMessage'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vConversation'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vConversation'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vCommunicationChannel'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vCommunicationChannel'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAssignmentRule'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAssignmentRule'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAssignmentOverride'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAssignmentOverride'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAssignmentGroupRule'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAssignmentGroupRule'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAssignmentGroup'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAssignmentGroup'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAssignment'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAssignment'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAccount'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAccount'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'cvUsers'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'cvUsers'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'cvTeacherEnrollments'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'cvTeacherEnrollments'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'cvStudentEnrollments'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'cvStudentEnrollments'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'cvDiscussions'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'cvDiscussions'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'cvAnnouncements'

GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'cvAnnouncements'

GO
/****** Object:  View [dbo].[vWikiPage]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vWikiPage]
GO
/****** Object:  View [dbo].[vWiki]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vWiki]
GO
/****** Object:  View [dbo].[vSubmissionParticipantComment]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vSubmissionParticipantComment]
GO
/****** Object:  View [dbo].[vSubmissionComment]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vSubmissionComment]
GO
/****** Object:  View [dbo].[vSubmission]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vSubmission]
GO
/****** Object:  View [dbo].[vScore]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vScore]
GO
/****** Object:  View [dbo].[vRole]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vRole]
GO
/****** Object:  View [dbo].[vRequests]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vRequests]
GO
/****** Object:  View [dbo].[vQuizSubmissionHistorical]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vQuizSubmissionHistorical]
GO
/****** Object:  View [dbo].[vQuizSubmission]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vQuizSubmission]
GO
/****** Object:  View [dbo].[vQuizQuestionGroup]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vQuizQuestionGroup]
GO
/****** Object:  View [dbo].[vQuizQuestionAnswer]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vQuizQuestionAnswer]
GO
/****** Object:  View [dbo].[vQuizQuestion]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vQuizQuestion]
GO
/****** Object:  View [dbo].[vQuiz]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vQuiz]
GO
/****** Object:  View [dbo].[vModuleProgressionCompletionRequirement]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vModuleProgressionCompletionRequirement]
GO
/****** Object:  View [dbo].[vModuleProgression]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vModuleProgression]
GO
/****** Object:  View [dbo].[vModulePrerequisite]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vModulePrerequisite]
GO
/****** Object:  View [dbo].[vModuleItem]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vModuleItem]
GO
/****** Object:  View [dbo].[vModuleCompletionRequirement]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vModuleCompletionRequirement]
GO
/****** Object:  View [dbo].[vModule]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vModule]
GO
/****** Object:  View [dbo].[vGroupMembership]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vGroupMembership]
GO
/****** Object:  View [dbo].[vGradingPeriodGroup]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vGradingPeriodGroup]
GO
/****** Object:  View [dbo].[vGradingPeriod]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vGradingPeriod]
GO
/****** Object:  View [dbo].[vFile]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vFile]
GO
/****** Object:  View [dbo].[vExternalToolActivation]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vExternalToolActivation]
GO
/****** Object:  View [dbo].[vEnrollmentTerm]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vEnrollmentTerm]
GO
/****** Object:  View [dbo].[vEnrollment]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vEnrollment]
GO
/****** Object:  View [dbo].[vDiscussionEntry]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vDiscussionEntry]
GO
/****** Object:  View [dbo].[vCourseUINavigationItem]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vCourseUINavigationItem]
GO
/****** Object:  View [dbo].[vCourseUICanvasNavigation]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vCourseUICanvasNavigation]
GO
/****** Object:  View [dbo].[vCourseSection]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vCourseSection]
GO
/****** Object:  View [dbo].[vConversationMessageParticipant]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vConversationMessageParticipant]
GO
/****** Object:  View [dbo].[vConversationMessage]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vConversationMessage]
GO
/****** Object:  View [dbo].[vConversation]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vConversation]
GO
/****** Object:  View [dbo].[vCommunicationChannel]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vCommunicationChannel]
GO
/****** Object:  View [dbo].[vAssignmentRule]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vAssignmentRule]
GO
/****** Object:  View [dbo].[vAssignmentOverride]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vAssignmentOverride]
GO
/****** Object:  View [dbo].[vAssignmentGroupRule]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vAssignmentGroupRule]
GO
/****** Object:  View [dbo].[vAssignmentGroup]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vAssignmentGroup]
GO
/****** Object:  View [dbo].[vAssignment]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vAssignment]
GO
/****** Object:  View [dbo].[vAccount]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vAccount]
GO
/****** Object:  View [dbo].[cvDiscussions]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[cvDiscussions]
GO
/****** Object:  View [dbo].[cvAnnouncements]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[cvAnnouncements]
GO
/****** Object:  View [dbo].[vDiscussionTopic]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vDiscussionTopic]
GO
/****** Object:  View [dbo].[cvStudentEnrollments]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[cvStudentEnrollments]
GO
/****** Object:  View [dbo].[cvTeacherEnrollments]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[cvTeacherEnrollments]
GO
/****** Object:  View [dbo].[vEnrollmentRollup]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vEnrollmentRollup]
GO
/****** Object:  View [dbo].[vCourse]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vCourse]
GO
/****** Object:  View [dbo].[cvUsers]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[cvUsers]
GO
/****** Object:  View [dbo].[vUser]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vUser]
GO
/****** Object:  View [dbo].[vPseudonym]    Script Date: 4/24/2017 1:31:03 PM ******/
DROP VIEW [dbo].[vPseudonym]
GO
/****** Object:  View [dbo].[vPseudonym]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vPseudonym]
AS
SELECT     CanvasDataStore.dbo.pseudonym_dim.id, CanvasDataStore.dbo.pseudonym_dim.canvas_id, CanvasDataStore.dbo.pseudonym_dim.user_id, CanvasDataStore.dbo.pseudonym_dim.workflow_state, CanvasDataStore.dbo.pseudonym_dim.last_request_at, CanvasDataStore.dbo.pseudonym_dim.last_login_at, CanvasDataStore.dbo.pseudonym_dim.current_login_at, 
                  CanvasDataStore.dbo.pseudonym_dim.last_login_ip, CanvasDataStore.dbo.pseudonym_dim.current_login_ip, CanvasDataStore.dbo.pseudonym_dim.position, CanvasDataStore.dbo.pseudonym_dim.created_at, CanvasDataStore.dbo.pseudonym_dim.updated_at, CanvasDataStore.dbo.pseudonym_dim.password_auto_generated, CanvasDataStore.dbo.pseudonym_dim.deleted_at, 
                  CanvasDataStore.dbo.pseudonym_dim.sis_user_id, CanvasDataStore.dbo.pseudonym_dim.unique_name, CanvasDataStore.dbo.pseudonym_dim.integration_id, CanvasDataStore.dbo.pseudonym_dim.authentication_provider_id, CanvasDataStore.dbo.pseudonym_dim.account_id, CanvasDataStore.dbo.pseudonym_fact.failed_login_count, 
                  CanvasDataStore.dbo.pseudonym_fact.login_count
FROM        CanvasDataStore.dbo.pseudonym_dim INNER JOIN
                  CanvasDataStore.dbo.pseudonym_fact ON CanvasDataStore.dbo.pseudonym_dim.id = CanvasDataStore.dbo.pseudonym_fact.pseudonym_id


GO
/****** Object:  View [dbo].[vUser]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vUser]
AS
SELECT     id, canvas_id, root_account_id, name, time_zone, created_at, visibility, school_name, school_position, gender, locale, [public], birthdate, country_code, workflow_state, sortable_name
FROM        CanvasDataStore.dbo.user_dim


GO
/****** Object:  View [dbo].[cvUsers]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[cvUsers]
AS
SELECT        dbo.vUser.id, dbo.vUser.canvas_id, dbo.vUser.name, dbo.vUser.sortable_name, dbo.vPseudonym.unique_name, dbo.vPseudonym.sis_user_id, dbo.vUser.created_at, dbo.vPseudonym.login_count, 
                         dbo.vPseudonym.failed_login_count, dbo.vPseudonym.last_login_at, dbo.vPseudonym.last_login_ip
FROM            dbo.vUser LEFT OUTER JOIN
                         dbo.vPseudonym ON dbo.vUser.id = dbo.vPseudonym.user_id
WHERE        (dbo.vPseudonym.workflow_state = 'active') AND (dbo.vPseudonym.position = 1)

GO
/****** Object:  View [dbo].[vCourse]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vCourse]
AS
SELECT     id AS course_id, canvas_id AS course_canvas_id, sis_source_id AS course_sis_source_id, code AS course_code, name AS course_name, type AS course_type, start_at AS course_start_at, conclude_at AS course_conclude_at, created_at, publicly_visible, 
                  workflow_state, wiki_id, root_account_id, account_id, enrollment_term_id
FROM        CanvasDataStore.dbo.course_dim
WHERE     (workflow_state NOT IN ('claimed', 'deleted'))


GO
/****** Object:  View [dbo].[vEnrollmentRollup]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vEnrollmentRollup]
AS
SELECT        user_id, id, course_id, enrollment_count, role_count, base_role_count, account_admin_role_count, least_privileged_role, no_permissions_enrollment_id, most_privileged_role, 
                         account_membership_enrollment_id, teacher_enrollment_role_count, designer_enrollment_role_count, ta_enrollment_role_count, student_enrollment_role_count, observer_enrollment_role_count, 
                         account_membership_role_count, no_permissions_role_count, account_admin_enrollment_id, teacher_enrollment_enrollment_id, designer_enrollment_enrollment_id, ta_enrollment_enrollment_id, 
                         student_enrollment_enrollment_id, observer_enrollment_enrollment_id
FROM            CanvasDataStore.dbo.enrollment_rollup_dim

GO
/****** Object:  View [dbo].[cvTeacherEnrollments]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[cvTeacherEnrollments]
AS
SELECT        dbo.vCourse.course_code, dbo.vCourse.course_name, dbo.vEnrollmentRollup.most_privileged_role, dbo.cvUsers.name, dbo.cvUsers.sortable_name, dbo.cvUsers.sis_user_id, dbo.cvUsers.created_at
FROM            dbo.vEnrollmentRollup INNER JOIN
                         dbo.cvUsers ON dbo.vEnrollmentRollup.user_id = dbo.cvUsers.id INNER JOIN
                         dbo.vCourse ON dbo.vEnrollmentRollup.course_id = dbo.vCourse.course_id
WHERE        (dbo.vEnrollmentRollup.most_privileged_role = 'TeacherEnrollment')

GO
/****** Object:  View [dbo].[cvStudentEnrollments]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[cvStudentEnrollments]
AS
SELECT        dbo.vCourse.course_code, dbo.vCourse.course_name, dbo.vEnrollmentRollup.most_privileged_role, dbo.cvUsers.name, dbo.cvUsers.sortable_name, dbo.cvUsers.sis_user_id, dbo.cvUsers.created_at
FROM            dbo.vEnrollmentRollup INNER JOIN
                         dbo.cvUsers ON dbo.vEnrollmentRollup.user_id = dbo.cvUsers.id INNER JOIN
                         dbo.vCourse ON dbo.vEnrollmentRollup.course_id = dbo.vCourse.course_id
WHERE        (dbo.vEnrollmentRollup.most_privileged_role = 'StudentEnrollment')

GO
/****** Object:  View [dbo].[vDiscussionTopic]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vDiscussionTopic]
AS
SELECT        CanvasDataStore.dbo.discussion_topic_dim.id, CanvasDataStore.dbo.discussion_topic_dim.canvas_id, CanvasDataStore.dbo.discussion_topic_dim.type, 
                         CanvasDataStore.dbo.discussion_topic_dim.workflow_state, CanvasDataStore.dbo.discussion_topic_dim.last_reply_at, CanvasDataStore.dbo.discussion_topic_dim.created_at, 
                         CanvasDataStore.dbo.discussion_topic_dim.updated_at, CanvasDataStore.dbo.discussion_topic_dim.delayed_post_at, CanvasDataStore.dbo.discussion_topic_dim.deleted_at, 
                         CanvasDataStore.dbo.discussion_topic_dim.posted_at, CanvasDataStore.dbo.discussion_topic_dim.discussion_type, CanvasDataStore.dbo.discussion_topic_dim.pinned, 
                         CanvasDataStore.dbo.discussion_topic_dim.locked, CanvasDataStore.dbo.discussion_topic_fact.user_id, CanvasDataStore.dbo.discussion_topic_fact.assignment_id, 
                         CanvasDataStore.dbo.discussion_topic_fact.editor_id, CanvasDataStore.dbo.discussion_topic_fact.enrollment_rollup_id, CanvasDataStore.dbo.discussion_topic_fact.message_length, 
                         CanvasDataStore.dbo.discussion_topic_dim.course_id, CanvasDataStore.dbo.discussion_topic_dim.group_id, CanvasDataStore.dbo.discussion_topic_dim.title, 
                         CanvasDataStore.dbo.discussion_topic_dim.message, CanvasDataStore.dbo.discussion_topic_fact.group_parent_course_id, CanvasDataStore.dbo.discussion_topic_fact.group_parent_account_id, 
                         CanvasDataStore.dbo.discussion_topic_fact.group_parent_course_account_id, CanvasDataStore.dbo.discussion_topic_fact.course_account_id, 
                         CanvasDataStore.dbo.discussion_topic_fact.enrollment_term_id
FROM            CanvasDataStore.dbo.discussion_topic_dim LEFT OUTER JOIN
                         CanvasDataStore.dbo.discussion_topic_fact ON CanvasDataStore.dbo.discussion_topic_dim.id = CanvasDataStore.dbo.discussion_topic_fact.discussion_topic_id

GO
/****** Object:  View [dbo].[cvAnnouncements]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[cvAnnouncements]
AS
SELECT        dbo.vDiscussionTopic.canvas_id, dbo.vCourse.course_sis_source_id, dbo.vCourse.course_name, dbo.vCourse.course_code, dbo.vDiscussionTopic.title, dbo.vDiscussionTopic.message, 
                         dbo.vDiscussionTopic.created_at, dbo.vDiscussionTopic.delayed_post_at, dbo.vDiscussionTopic.posted_at, dbo.cvUsers.name, dbo.cvUsers.sortable_name, dbo.cvUsers.sis_user_id, 
                         dbo.cvUsers.unique_name
FROM            dbo.vDiscussionTopic LEFT OUTER JOIN
                         dbo.cvUsers ON dbo.vDiscussionTopic.user_id = dbo.cvUsers.id LEFT OUTER JOIN
                         dbo.vCourse ON dbo.vDiscussionTopic.course_id = dbo.vCourse.course_id
WHERE        (dbo.vDiscussionTopic.type = 'Announcement') AND (dbo.vDiscussionTopic.workflow_state = 'active')

GO
/****** Object:  View [dbo].[cvDiscussions]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[cvDiscussions]
AS
SELECT        dbo.vDiscussionTopic.canvas_id, dbo.vCourse.course_sis_source_id, dbo.vCourse.course_name, dbo.vCourse.course_code, dbo.vDiscussionTopic.title, dbo.vDiscussionTopic.message, 
                         dbo.vDiscussionTopic.created_at, dbo.vDiscussionTopic.delayed_post_at, dbo.vDiscussionTopic.posted_at, dbo.cvUsers.name, dbo.cvUsers.sortable_name, dbo.cvUsers.sis_user_id, 
                         dbo.cvUsers.unique_name
FROM            dbo.vDiscussionTopic LEFT OUTER JOIN
                         dbo.cvUsers ON dbo.vDiscussionTopic.user_id = dbo.cvUsers.id LEFT OUTER JOIN
                         dbo.vCourse ON dbo.vDiscussionTopic.course_id = dbo.vCourse.course_id
WHERE        (dbo.vDiscussionTopic.type IS NULL) AND (dbo.vDiscussionTopic.workflow_state = 'active')

GO
/****** Object:  View [dbo].[vAccount]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vAccount]
AS
SELECT        [CanvasDataStore].dbo.account_dim.*
FROM            [CanvasDataStore].dbo.account_dim




GO
/****** Object:  View [dbo].[vAssignment]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vAssignment]
AS
SELECT     CanvasDataStore.dbo.assignment_dim.id, CanvasDataStore.dbo.assignment_dim.canvas_id, CanvasDataStore.dbo.assignment_dim.due_at, CanvasDataStore.dbo.assignment_dim.unlock_at, CanvasDataStore.dbo.assignment_dim.lock_at, CanvasDataStore.dbo.assignment_dim.points_possible, CanvasDataStore.dbo.assignment_dim.grading_type, CanvasDataStore.dbo.assignment_dim.submission_types, 
                  CanvasDataStore.dbo.assignment_dim.workflow_state, CanvasDataStore.dbo.assignment_dim.peer_review_count, CanvasDataStore.dbo.assignment_dim.peer_reviews_due_at, CanvasDataStore.dbo.assignment_dim.peer_reviews_assigned, CanvasDataStore.dbo.assignment_dim.peer_reviews, CanvasDataStore.dbo.assignment_dim.automatic_peer_reviews, 
                  CanvasDataStore.dbo.assignment_dim.all_day, CanvasDataStore.dbo.assignment_dim.all_day_date, CanvasDataStore.dbo.assignment_dim.could_be_locked, CanvasDataStore.dbo.assignment_dim.grade_group_students_individually, CanvasDataStore.dbo.assignment_dim.anonymous_peer_reviews, CanvasDataStore.dbo.assignment_dim.muted, 
                  CanvasDataStore.dbo.assignment_dim.title, CanvasDataStore.dbo.assignment_dim.description, CanvasDataStore.dbo.assignment_dim.course_id, CanvasDataStore.dbo.assignment_dim.position, CanvasDataStore.dbo.assignment_dim.visibility, CanvasDataStore.dbo.assignment_dim.assignment_group_id, CanvasDataStore.dbo.assignment_fact.enrollment_term_id, 
                  CanvasDataStore.dbo.assignment_fact.course_account_id, CanvasDataStore.dbo.assignment_dim.created_at, CanvasDataStore.dbo.assignment_dim.updated_at
FROM        CanvasDataStore.dbo.assignment_dim INNER JOIN
                  CanvasDataStore.dbo.assignment_fact ON CanvasDataStore.dbo.assignment_dim.id = CanvasDataStore.dbo.assignment_fact.assignment_id


GO
/****** Object:  View [dbo].[vAssignmentGroup]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vAssignmentGroup]
AS
SELECT     CanvasDataStore.dbo.assignment_group_dim.id, CanvasDataStore.dbo.assignment_group_fact.group_weight, CanvasDataStore.dbo.assignment_group_dim.canvas_id, CanvasDataStore.dbo.assignment_group_dim.course_id, CanvasDataStore.dbo.assignment_group_dim.name, CanvasDataStore.dbo.assignment_group_dim.default_assignment_name, 
                  CanvasDataStore.dbo.assignment_group_dim.workflow_state, CanvasDataStore.dbo.assignment_group_dim.position, CanvasDataStore.dbo.assignment_group_fact.assignment_group_id, CanvasDataStore.dbo.assignment_group_dim.updated_at, CanvasDataStore.dbo.assignment_group_dim.created_at
FROM        CanvasDataStore.dbo.assignment_group_dim INNER JOIN
                  CanvasDataStore.dbo.assignment_group_fact ON CanvasDataStore.dbo.assignment_group_dim.id = CanvasDataStore.dbo.assignment_group_fact.assignment_group_id


GO
/****** Object:  View [dbo].[vAssignmentGroupRule]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vAssignmentGroupRule]
AS
SELECT     assignment_group_id, drop_lowest, drop_highest
FROM        CanvasDataStore.dbo.assignment_group_rule_dim


GO
/****** Object:  View [dbo].[vAssignmentOverride]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vAssignmentOverride]
AS
SELECT     CanvasDataStore.dbo.assignment_override_dim.id, CanvasDataStore.dbo.assignment_override_dim.canvas_id, CanvasDataStore.dbo.assignment_override_dim.assignment_id, CanvasDataStore.dbo.assignment_override_dim.course_section_id, CanvasDataStore.dbo.assignment_override_dim.group_id, CanvasDataStore.dbo.assignment_override_dim.quiz_id, 
                  CanvasDataStore.dbo.assignment_override_dim.all_day, CanvasDataStore.dbo.assignment_override_dim.all_day_date, CanvasDataStore.dbo.assignment_override_dim.assignment_version, CanvasDataStore.dbo.assignment_override_dim.due_at_overridden, CanvasDataStore.dbo.assignment_override_dim.lock_at, 
                  CanvasDataStore.dbo.assignment_override_dim.lock_at_overridden, CanvasDataStore.dbo.assignment_override_dim.due_at, CanvasDataStore.dbo.assignment_override_dim.set_type, CanvasDataStore.dbo.assignment_override_dim.title, CanvasDataStore.dbo.assignment_override_dim.unlock_at, CanvasDataStore.dbo.assignment_override_dim.unlock_at_overridden, 
                  CanvasDataStore.dbo.assignment_override_dim.quiz_version, CanvasDataStore.dbo.assignment_override_dim.workflow_state, CanvasDataStore.dbo.assignment_override_fact.account_id, CanvasDataStore.dbo.assignment_override_fact.assignment_group_id, CanvasDataStore.dbo.assignment_override_fact.course_id, 
                  CanvasDataStore.dbo.assignment_override_fact.enrollment_term_id, CanvasDataStore.dbo.assignment_override_fact.group_category_id, CanvasDataStore.dbo.assignment_override_fact.group_parent_account_id, CanvasDataStore.dbo.assignment_override_fact.nonxlist_course_id, CanvasDataStore.dbo.assignment_override_fact.group_wiki_id, 
                  CanvasDataStore.dbo.assignment_override_dim.created_at, CanvasDataStore.dbo.assignment_override_dim.updated_at
FROM        CanvasDataStore.dbo.assignment_override_dim INNER JOIN
                  CanvasDataStore.dbo.assignment_override_fact ON CanvasDataStore.dbo.assignment_override_dim.id = CanvasDataStore.dbo.assignment_override_fact.assignment_override_id


GO
/****** Object:  View [dbo].[vAssignmentRule]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vAssignmentRule]
AS
SELECT     drop_rule, assignment_id
FROM        CanvasDataStore.dbo.assignment_rule_dim


GO
/****** Object:  View [dbo].[vCommunicationChannel]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vCommunicationChannel]
AS
SELECT     CanvasDataStore.dbo.communication_channel_dim.id, CanvasDataStore.dbo.communication_channel_dim.canvas_id, CanvasDataStore.dbo.communication_channel_dim.user_id, CanvasDataStore.dbo.communication_channel_dim.address, CanvasDataStore.dbo.communication_channel_dim.type, CanvasDataStore.dbo.communication_channel_dim.position, 
                  CanvasDataStore.dbo.communication_channel_dim.workflow_state, CanvasDataStore.dbo.communication_channel_fact.bounce_count, CanvasDataStore.dbo.communication_channel_dim.created_at, CanvasDataStore.dbo.communication_channel_dim.updated_at
FROM        CanvasDataStore.dbo.communication_channel_dim INNER JOIN
                  CanvasDataStore.dbo.communication_channel_fact ON CanvasDataStore.dbo.communication_channel_dim.id = CanvasDataStore.dbo.communication_channel_fact.communication_channel_id


GO
/****** Object:  View [dbo].[vConversation]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vConversation]
AS
SELECT     id, canvas_id, has_attachments, has_media_objects, subject, course_id, group_id, account_id
FROM        CanvasDataStore.dbo.conversation_dim


GO
/****** Object:  View [dbo].[vConversationMessage]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vConversationMessage]
AS
SELECT     id, canvas_id, conversation_id, author_id, created_at, generated, has_attachments, has_media_objects, body
FROM        CanvasDataStore.dbo.conversation_message_dim


GO
/****** Object:  View [dbo].[vConversationMessageParticipant]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vConversationMessageParticipant]
AS
SELECT     conversation_message_id, conversation_id, user_id, course_id, enrollment_term_id, course_account_id, group_id, account_id, enrollment_rollup_id, message_size_bytes, message_character_count, message_word_count, message_line_count
FROM        CanvasDataStore.dbo.conversation_message_participant_fact


GO
/****** Object:  View [dbo].[vCourseSection]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vCourseSection]
AS
SELECT     id, canvas_id, name, course_id, default_section, workflow_state, restrict_enrollments_to_section_dates, sis_source_id, enrollment_term_id, accepting_enrollments, can_manually_enroll, start_at, end_at, nonxlist_course_id, created_at, updated_at
FROM        CanvasDataStore.dbo.course_section_dim


GO
/****** Object:  View [dbo].[vCourseUICanvasNavigation]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vCourseUICanvasNavigation]
AS
SELECT        canvas_id, name, [default], original_position, id
FROM            [CanvasDataStore].dbo.course_ui_canvas_navigation_dim




GO
/****** Object:  View [dbo].[vCourseUINavigationItem]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vCourseUINavigationItem]
AS
SELECT     CanvasDataStore.dbo.course_ui_navigation_item_dim.id, CanvasDataStore.dbo.course_ui_navigation_item_fact.course_ui_canvas_navigation_id, CanvasDataStore.dbo.course_ui_navigation_item_fact.course_id, CanvasDataStore.dbo.course_ui_navigation_item_dim.visible, CanvasDataStore.dbo.course_ui_navigation_item_dim.position, 
                  CanvasDataStore.dbo.course_ui_navigation_item_fact.external_tool_activation_id, CanvasDataStore.dbo.course_ui_navigation_item_fact.enrollment_term_id, CanvasDataStore.dbo.course_ui_navigation_item_fact.course_account_id, CanvasDataStore.dbo.course_ui_navigation_item_dim.root_account_id
FROM        CanvasDataStore.dbo.course_ui_navigation_item_dim INNER JOIN
                  CanvasDataStore.dbo.course_ui_navigation_item_fact ON CanvasDataStore.dbo.course_ui_navigation_item_dim.id = CanvasDataStore.dbo.course_ui_navigation_item_fact.course_ui_navigation_item_id


GO
/****** Object:  View [dbo].[vDiscussionEntry]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vDiscussionEntry]
AS
SELECT     CanvasDataStore.dbo.discussion_entry_dim.id, CanvasDataStore.dbo.discussion_entry_dim.canvas_id, CanvasDataStore.dbo.discussion_entry_dim.workflow_state, CanvasDataStore.dbo.discussion_entry_dim.depth, CanvasDataStore.dbo.discussion_entry_fact.parent_discussion_entry_id, CanvasDataStore.dbo.discussion_entry_fact.user_id, 
                  CanvasDataStore.dbo.discussion_entry_fact.topic_id, CanvasDataStore.dbo.discussion_entry_fact.course_id, CanvasDataStore.dbo.discussion_entry_fact.message_length, CanvasDataStore.dbo.discussion_entry_dim.message, CanvasDataStore.dbo.discussion_entry_fact.enrollment_term_id, CanvasDataStore.dbo.discussion_entry_fact.course_account_id, 
                  CanvasDataStore.dbo.discussion_entry_fact.topic_user_id, CanvasDataStore.dbo.discussion_entry_fact.topic_assignment_id, CanvasDataStore.dbo.discussion_entry_fact.topic_editor_id, CanvasDataStore.dbo.discussion_entry_fact.enrollment_rollup_id, CanvasDataStore.dbo.discussion_entry_dim.deleted_at, CanvasDataStore.dbo.discussion_entry_dim.created_at, 
                  CanvasDataStore.dbo.discussion_entry_dim.updated_at
FROM        CanvasDataStore.dbo.discussion_entry_dim LEFT OUTER JOIN
                  CanvasDataStore.dbo.discussion_entry_fact ON CanvasDataStore.dbo.discussion_entry_dim.id = CanvasDataStore.dbo.discussion_entry_fact.discussion_entry_id


GO
/****** Object:  View [dbo].[vEnrollment]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vEnrollment]
AS
SELECT        CanvasDataStore.dbo.enrollment_dim.id, CanvasDataStore.dbo.enrollment_dim.canvas_id, CanvasDataStore.dbo.enrollment_dim.course_section_id, CanvasDataStore.dbo.enrollment_dim.role_id, 
                         CanvasDataStore.dbo.enrollment_dim.type, CanvasDataStore.dbo.enrollment_dim.workflow_state, CanvasDataStore.dbo.enrollment_dim.created_at, CanvasDataStore.dbo.enrollment_dim.updated_at, 
                         CanvasDataStore.dbo.enrollment_dim.start_at, CanvasDataStore.dbo.enrollment_dim.end_at, CanvasDataStore.dbo.enrollment_dim.completed_at, CanvasDataStore.dbo.enrollment_fact.computed_current_score, 
                         CanvasDataStore.dbo.enrollment_fact.computed_final_score, CanvasDataStore.dbo.enrollment_fact.course_account_id, CanvasDataStore.dbo.enrollment_fact.enrollment_term_id, 
                         CanvasDataStore.dbo.enrollment_dim.user_id, CanvasDataStore.dbo.enrollment_dim.course_id, CanvasDataStore.dbo.enrollment_dim.sis_source_id, CanvasDataStore.dbo.enrollment_dim.self_enrolled, 
                         CanvasDataStore.dbo.enrollment_dim.root_account_id
FROM            CanvasDataStore.dbo.enrollment_dim INNER JOIN
                         CanvasDataStore.dbo.enrollment_fact ON CanvasDataStore.dbo.enrollment_dim.id = CanvasDataStore.dbo.enrollment_fact.enrollment_id

GO
/****** Object:  View [dbo].[vEnrollmentTerm]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vEnrollmentTerm]
AS
SELECT     id, canvas_id, root_account_id, name, date_start, date_end, sis_source_id
FROM        CanvasDataStore.dbo.enrollment_term_dim


GO
/****** Object:  View [dbo].[vExternalToolActivation]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vExternalToolActivation]
AS
SELECT     CanvasDataStore.dbo.external_tool_activation_dim.id, CanvasDataStore.dbo.external_tool_activation_dim.canvas_id, CanvasDataStore.dbo.external_tool_activation_dim.course_id, CanvasDataStore.dbo.external_tool_activation_dim.account_id, CanvasDataStore.dbo.external_tool_activation_dim.activation_target_type, 
                  CanvasDataStore.dbo.external_tool_activation_dim.url, CanvasDataStore.dbo.external_tool_activation_dim.name, CanvasDataStore.dbo.external_tool_activation_dim.description, CanvasDataStore.dbo.external_tool_activation_dim.workflow_state, CanvasDataStore.dbo.external_tool_activation_dim.privacy_level, CanvasDataStore.dbo.external_tool_activation_dim.tool_id, 
                  CanvasDataStore.dbo.external_tool_activation_dim.selectable_all, CanvasDataStore.dbo.external_tool_activation_dim.created_at, CanvasDataStore.dbo.external_tool_activation_dim.updated_at, CanvasDataStore.dbo.external_tool_activation_fact.root_account_id, CanvasDataStore.dbo.external_tool_activation_fact.enrollment_term_id, 
                  CanvasDataStore.dbo.external_tool_activation_fact.course_account_id
FROM        CanvasDataStore.dbo.external_tool_activation_dim INNER JOIN
                  CanvasDataStore.dbo.external_tool_activation_fact ON CanvasDataStore.dbo.external_tool_activation_dim.id = CanvasDataStore.dbo.external_tool_activation_fact.external_tool_activation_id


GO
/****** Object:  View [dbo].[vFile]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vFile]
AS
SELECT     CanvasDataStore.dbo.file_dim.id, CanvasDataStore.dbo.file_dim.canvas_id, CanvasDataStore.dbo.file_dim.display_name, CanvasDataStore.dbo.file_dim.account_id, CanvasDataStore.dbo.file_dim.assignment_id, CanvasDataStore.dbo.file_dim.conversation_message_id, CanvasDataStore.dbo.file_dim.course_id, CanvasDataStore.dbo.file_dim.folder_id, CanvasDataStore.dbo.file_dim.group_id, CanvasDataStore.dbo.file_dim.quiz_id, 
                  CanvasDataStore.dbo.file_dim.quiz_submission_id, CanvasDataStore.dbo.file_dim.replacement_file_id, CanvasDataStore.dbo.file_dim.root_file_id, CanvasDataStore.dbo.file_dim.submission_id, CanvasDataStore.dbo.file_dim.uploader_id, CanvasDataStore.dbo.file_dim.user_id, CanvasDataStore.dbo.file_dim.owner_entity_type, CanvasDataStore.dbo.file_dim.content_type, CanvasDataStore.dbo.file_dim.file_state, 
                  CanvasDataStore.dbo.file_dim.could_be_locked, CanvasDataStore.dbo.file_dim.locked, CanvasDataStore.dbo.file_dim.lock_at, CanvasDataStore.dbo.file_dim.unlock_at, CanvasDataStore.dbo.file_fact.size, CanvasDataStore.dbo.file_fact.wiki_id, CanvasDataStore.dbo.file_fact.sis_source_id, CanvasDataStore.dbo.file_fact.assignment_group_id, CanvasDataStore.dbo.file_fact.conversation_message_author_id, 
                  CanvasDataStore.dbo.file_fact.conversation_id, CanvasDataStore.dbo.file_dim.deleted_at, CanvasDataStore.dbo.file_dim.updated_at, CanvasDataStore.dbo.file_dim.created_at, CanvasDataStore.dbo.file_dim.viewed_at, CanvasDataStore.dbo.file_dim.md5, CanvasDataStore.dbo.file_fact.enrollment_rollup_id, CanvasDataStore.dbo.file_fact.enrollment_term_id, CanvasDataStore.dbo.file_fact.grader_id, 
                  CanvasDataStore.dbo.file_fact.group_category_id
FROM        CanvasDataStore.dbo.file_dim INNER JOIN
                  CanvasDataStore.dbo.file_fact ON CanvasDataStore.dbo.file_dim.id = CanvasDataStore.dbo.file_fact.file_id


GO
/****** Object:  View [dbo].[vGradingPeriod]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vGradingPeriod]
AS
SELECT     CanvasDataStore.dbo.grading_period_dim.id, CanvasDataStore.dbo.grading_period_dim.canvas_id, CanvasDataStore.dbo.grading_period_dim.grading_period_group_id, CanvasDataStore.dbo.grading_period_dim.end_date, CanvasDataStore.dbo.grading_period_dim.close_date, CanvasDataStore.dbo.grading_period_dim.start_date, CanvasDataStore.dbo.grading_period_dim.title, 
                  CanvasDataStore.dbo.grading_period_dim.workflow_state, CanvasDataStore.dbo.grading_period_fact.weight, CanvasDataStore.dbo.grading_period_dim.updated_at, CanvasDataStore.dbo.grading_period_dim.created_at, CanvasDataStore.dbo.grading_period_fact.grading_period_group_account_id, 
                  CanvasDataStore.dbo.grading_period_fact.grading_period_group_course_id
FROM        CanvasDataStore.dbo.grading_period_dim INNER JOIN
                  CanvasDataStore.dbo.grading_period_fact ON CanvasDataStore.dbo.grading_period_dim.id = CanvasDataStore.dbo.grading_period_fact.grading_period_id


GO
/****** Object:  View [dbo].[vGradingPeriodGroup]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vGradingPeriodGroup]
AS
SELECT     id, canvas_id, course_id, title, workflow_state, account_id, created_at, updated_at
FROM        CanvasDataStore.dbo.grading_period_group_dim


GO
/****** Object:  View [dbo].[vGroupMembership]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vGroupMembership]
AS
SELECT     CanvasDataStore.dbo.group_membership_dim.id, CanvasDataStore.dbo.group_membership_dim.canvas_id, CanvasDataStore.dbo.group_membership_dim.group_id, CanvasDataStore.dbo.group_membership_dim.moderator, CanvasDataStore.dbo.group_membership_dim.workflow_state, CanvasDataStore.dbo.group_membership_fact.group_membership_id, 
                  CanvasDataStore.dbo.group_membership_dim.created_at, CanvasDataStore.dbo.group_membership_fact.parent_account_id, CanvasDataStore.dbo.group_membership_fact.parent_course_account_id, CanvasDataStore.dbo.group_membership_fact.enrollment_term_id, CanvasDataStore.dbo.group_membership_fact.user_id, 
                  CanvasDataStore.dbo.group_membership_dim.updated_at
FROM        CanvasDataStore.dbo.group_membership_dim INNER JOIN
                  CanvasDataStore.dbo.group_membership_fact ON CanvasDataStore.dbo.group_membership_dim.id = CanvasDataStore.dbo.group_membership_fact.group_membership_id


GO
/****** Object:  View [dbo].[vModule]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vModule]
AS
SELECT     CanvasDataStore.dbo.module_dim.id, CanvasDataStore.dbo.module_dim.canvas_id, CanvasDataStore.dbo.module_dim.course_id, CanvasDataStore.dbo.module_dim.require_sequential_progress, CanvasDataStore.dbo.module_dim.workflow_state, CanvasDataStore.dbo.module_dim.position, CanvasDataStore.dbo.module_dim.name, CanvasDataStore.dbo.module_dim.unlock_at, CanvasDataStore.dbo.module_dim.deleted_at, 
                  CanvasDataStore.dbo.module_dim.updated_at, CanvasDataStore.dbo.module_dim.created_at, CanvasDataStore.dbo.module_fact.module_id, CanvasDataStore.dbo.module_fact.account_id, CanvasDataStore.dbo.module_fact.enrollment_term_id, CanvasDataStore.dbo.module_fact.wiki_id
FROM        CanvasDataStore.dbo.module_dim INNER JOIN
                  CanvasDataStore.dbo.module_fact ON CanvasDataStore.dbo.module_dim.id = CanvasDataStore.dbo.module_fact.module_id


GO
/****** Object:  View [dbo].[vModuleCompletionRequirement]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vModuleCompletionRequirement]
AS
SELECT     CanvasDataStore.dbo.module_completion_requirement_dim.id, CanvasDataStore.dbo.module_completion_requirement_dim.module_id, CanvasDataStore.dbo.module_completion_requirement_dim.module_item_id, CanvasDataStore.dbo.module_completion_requirement_dim.requirement_type, 
                  CanvasDataStore.dbo.module_completion_requirement_fact.course_id, CanvasDataStore.dbo.module_completion_requirement_fact.discussion_topic_id, CanvasDataStore.dbo.module_completion_requirement_fact.discussion_topic_editor_id, CanvasDataStore.dbo.module_completion_requirement_fact.file_id, 
                  CanvasDataStore.dbo.module_completion_requirement_fact.user_id, CanvasDataStore.dbo.module_completion_requirement_fact.quiz_id, CanvasDataStore.dbo.module_completion_requirement_fact.wiki_id, CanvasDataStore.dbo.module_completion_requirement_fact.wiki_page_id, CanvasDataStore.dbo.module_completion_requirement_fact.min_score, 
                  CanvasDataStore.dbo.module_completion_requirement_fact.account_id, CanvasDataStore.dbo.module_completion_requirement_fact.assignment_id, CanvasDataStore.dbo.module_completion_requirement_fact.assignment_group_id, CanvasDataStore.dbo.module_completion_requirement_fact.enrollment_rollup_id, 
                  CanvasDataStore.dbo.module_completion_requirement_fact.enrollment_term_id
FROM        CanvasDataStore.dbo.module_completion_requirement_dim INNER JOIN
                  CanvasDataStore.dbo.module_completion_requirement_fact ON CanvasDataStore.dbo.module_completion_requirement_dim.id = CanvasDataStore.dbo.module_completion_requirement_fact.module_completion_requirement_id


GO
/****** Object:  View [dbo].[vModuleItem]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vModuleItem]
AS
SELECT        CanvasDataStore.dbo.module_item_dim.canvas_id, CanvasDataStore.dbo.module_item_dim.id, CanvasDataStore.dbo.module_item_dim.assignment_id, CanvasDataStore.dbo.module_item_dim.course_id, 
                         CanvasDataStore.dbo.module_item_dim.discussion_topic_id, CanvasDataStore.dbo.module_item_dim.file_id, CanvasDataStore.dbo.module_item_dim.module_id, 
                         CanvasDataStore.dbo.module_item_dim.quiz_id, CanvasDataStore.dbo.module_item_dim.wiki_page_id, CanvasDataStore.dbo.module_item_dim.content_type, 
                         CanvasDataStore.dbo.module_item_dim.workflow_state, CanvasDataStore.dbo.module_item_dim.position, CanvasDataStore.dbo.module_item_dim.title, CanvasDataStore.dbo.module_item_dim.url, 
                         CanvasDataStore.dbo.module_item_fact.wiki_id, CanvasDataStore.dbo.module_item_fact.assignment_group_id, CanvasDataStore.dbo.module_item_fact.account_id, 
                         CanvasDataStore.dbo.module_item_fact.discussion_topic_editor_id, CanvasDataStore.dbo.module_item_fact.enrollment_rollup_id, CanvasDataStore.dbo.module_item_fact.enrollment_term_id, 
                         CanvasDataStore.dbo.module_item_fact.user_id, CanvasDataStore.dbo.module_item_dim.created_at, CanvasDataStore.dbo.module_item_dim.updated_at
FROM            CanvasDataStore.dbo.module_item_dim INNER JOIN
                         CanvasDataStore.dbo.module_item_fact ON CanvasDataStore.dbo.module_item_dim.id = CanvasDataStore.dbo.module_item_fact.module_item_id

GO
/****** Object:  View [dbo].[vModulePrerequisite]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vModulePrerequisite]
AS
SELECT     CanvasDataStore.dbo.module_prerequisite_dim.id, CanvasDataStore.dbo.module_prerequisite_dim.module_id, CanvasDataStore.dbo.module_prerequisite_dim.prerequisite_module_id, CanvasDataStore.dbo.module_prerequisite_fact.account_id, CanvasDataStore.dbo.module_prerequisite_fact.course_id, 
                  CanvasDataStore.dbo.module_prerequisite_fact.prerequisite_wiki_id, CanvasDataStore.dbo.module_prerequisite_fact.wiki_id, CanvasDataStore.dbo.module_prerequisite_fact.enrollment_term_id
FROM        CanvasDataStore.dbo.module_prerequisite_dim INNER JOIN
                  CanvasDataStore.dbo.module_prerequisite_fact ON CanvasDataStore.dbo.module_prerequisite_dim.id = CanvasDataStore.dbo.module_prerequisite_fact.module_prerequisite_id


GO
/****** Object:  View [dbo].[vModuleProgression]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vModuleProgression]
AS
SELECT        CanvasDataStore.dbo.module_progression_dim.id, CanvasDataStore.dbo.module_progression_dim.canvas_id, CanvasDataStore.dbo.module_progression_dim.module_id, 
                         CanvasDataStore.dbo.module_progression_dim.user_id, CanvasDataStore.dbo.module_progression_dim.collapsed, CanvasDataStore.dbo.module_progression_dim.is_current, 
                         CanvasDataStore.dbo.module_progression_dim.current_position, CanvasDataStore.dbo.module_progression_dim.lock_version, CanvasDataStore.dbo.module_progression_dim.workflow_state, 
                         CanvasDataStore.dbo.module_progression_dim.completed_at, CanvasDataStore.dbo.module_progression_dim.evaluated_at, CanvasDataStore.dbo.module_progression_fact.account_id, 
                         CanvasDataStore.dbo.module_progression_fact.course_id, CanvasDataStore.dbo.module_progression_fact.wiki_id, CanvasDataStore.dbo.module_progression_dim.created_at, 
                         CanvasDataStore.dbo.module_progression_dim.updated_at, CanvasDataStore.dbo.module_progression_fact.enrollment_term_id
FROM            CanvasDataStore.dbo.module_progression_dim INNER JOIN
                         CanvasDataStore.dbo.module_progression_fact ON CanvasDataStore.dbo.module_progression_dim.id = CanvasDataStore.dbo.module_progression_fact.module_progression_id

GO
/****** Object:  View [dbo].[vModuleProgressionCompletionRequirement]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vModuleProgressionCompletionRequirement]
AS
SELECT     CanvasDataStore.dbo.module_progression_completion_requirement_dim.id, CanvasDataStore.dbo.module_progression_completion_requirement_dim.module_progression_id, CanvasDataStore.dbo.module_progression_completion_requirement_dim.requirement_type, 
                  CanvasDataStore.dbo.module_progression_completion_requirement_dim.completion_status, CanvasDataStore.dbo.module_progression_completion_requirement_fact.account_id, CanvasDataStore.dbo.module_progression_completion_requirement_fact.assignment_id, 
                  CanvasDataStore.dbo.module_progression_completion_requirement_fact.assignment_group_id, CanvasDataStore.dbo.module_progression_completion_requirement_fact.course_id, CanvasDataStore.dbo.module_progression_completion_requirement_dim.module_item_id, 
                  CanvasDataStore.dbo.module_progression_completion_requirement_fact.discussion_topic_id, CanvasDataStore.dbo.module_progression_completion_requirement_fact.discussion_topic_editor_id, CanvasDataStore.dbo.module_progression_completion_requirement_fact.enrollment_rollup_id, 
                  CanvasDataStore.dbo.module_progression_completion_requirement_fact.enrollment_term_id, CanvasDataStore.dbo.module_progression_completion_requirement_fact.file_id, CanvasDataStore.dbo.module_progression_completion_requirement_fact.module_id, 
                  CanvasDataStore.dbo.module_progression_completion_requirement_fact.quiz_id, CanvasDataStore.dbo.module_progression_completion_requirement_fact.user_id, CanvasDataStore.dbo.module_progression_completion_requirement_fact.wiki_page_id, CanvasDataStore.dbo.module_progression_completion_requirement_fact.wiki_id, 
                  CanvasDataStore.dbo.module_progression_completion_requirement_fact.min_score, CanvasDataStore.dbo.module_progression_completion_requirement_fact.score
FROM        CanvasDataStore.dbo.module_progression_completion_requirement_dim INNER JOIN
                  CanvasDataStore.dbo.module_progression_completion_requirement_fact ON CanvasDataStore.dbo.module_progression_completion_requirement_dim.id = CanvasDataStore.dbo.module_progression_completion_requirement_fact.module_progression_completion_requirement_id


GO
/****** Object:  View [dbo].[vQuiz]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vQuiz]
AS
SELECT     CanvasDataStore.dbo.quiz_dim.id, CanvasDataStore.dbo.quiz_dim.canvas_id, CanvasDataStore.dbo.quiz_dim.course_id, CanvasDataStore.dbo.quiz_dim.quiz_type, CanvasDataStore.dbo.quiz_dim.assignment_id, CanvasDataStore.dbo.quiz_dim.points_possible, CanvasDataStore.dbo.quiz_dim.name, CanvasDataStore.dbo.quiz_dim.workflow_state, CanvasDataStore.dbo.quiz_dim.scoring_policy, 
                  CanvasDataStore.dbo.quiz_dim.anonymous_submissions, CanvasDataStore.dbo.quiz_dim.display_questions, CanvasDataStore.dbo.quiz_dim.answer_display_order, CanvasDataStore.dbo.quiz_dim.go_back_to_previous_question, CanvasDataStore.dbo.quiz_dim.could_be_locked, CanvasDataStore.dbo.quiz_dim.browser_lockdown, 
                  CanvasDataStore.dbo.quiz_dim.browser_lockdown_for_displaying_results, CanvasDataStore.dbo.quiz_dim.browser_lockdown_monitor, CanvasDataStore.dbo.quiz_dim.ip_filter, CanvasDataStore.dbo.quiz_dim.show_results, CanvasDataStore.dbo.quiz_dim.show_correct_answers, CanvasDataStore.dbo.quiz_dim.show_correct_answers_at, 
                  CanvasDataStore.dbo.quiz_dim.hide_correct_answers_at, CanvasDataStore.dbo.quiz_dim.created_at, CanvasDataStore.dbo.quiz_dim.updated_at, CanvasDataStore.dbo.quiz_dim.published_at, CanvasDataStore.dbo.quiz_dim.unlock_at, CanvasDataStore.dbo.quiz_dim.lock_at, CanvasDataStore.dbo.quiz_dim.due_at, CanvasDataStore.dbo.quiz_dim.deleted_at, CanvasDataStore.dbo.quiz_fact.time_limit, 
                  CanvasDataStore.dbo.quiz_fact.allowed_attempts, CanvasDataStore.dbo.quiz_fact.question_count, CanvasDataStore.dbo.quiz_fact.unpublished_question_count, CanvasDataStore.dbo.quiz_fact.course_account_id, CanvasDataStore.dbo.quiz_fact.enrollment_term_id
FROM        CanvasDataStore.dbo.quiz_dim INNER JOIN
                  CanvasDataStore.dbo.quiz_fact ON CanvasDataStore.dbo.quiz_dim.id = CanvasDataStore.dbo.quiz_fact.quiz_id


GO
/****** Object:  View [dbo].[vQuizQuestion]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vQuizQuestion]
AS
SELECT     CanvasDataStore.dbo.quiz_question_dim.id, CanvasDataStore.dbo.quiz_question_dim.canvas_id, CanvasDataStore.dbo.quiz_question_dim.quiz_id, CanvasDataStore.dbo.quiz_question_dim.quiz_question_group_id, CanvasDataStore.dbo.quiz_question_dim.position, CanvasDataStore.dbo.quiz_question_dim.workflow_state, CanvasDataStore.dbo.quiz_question_dim.question_type, 
                  CanvasDataStore.dbo.quiz_question_fact.points_possible, CanvasDataStore.dbo.quiz_question_dim.created_at, CanvasDataStore.dbo.quiz_question_dim.updated_at, CanvasDataStore.dbo.quiz_question_dim.regrade_option, CanvasDataStore.dbo.quiz_question_dim.assessment_question_id, CanvasDataStore.dbo.quiz_question_dim.assessment_question_version, 
                  CanvasDataStore.dbo.quiz_question_dim.name, CanvasDataStore.dbo.quiz_question_dim.question_text, CanvasDataStore.dbo.quiz_question_dim.correct_comments, CanvasDataStore.dbo.quiz_question_dim.incorrect_comments, CanvasDataStore.dbo.quiz_question_dim.neutral_comments, CanvasDataStore.dbo.quiz_question_fact.course_id, 
                  CanvasDataStore.dbo.quiz_question_fact.assignment_id, CanvasDataStore.dbo.quiz_question_fact.course_account_id, CanvasDataStore.dbo.quiz_question_fact.enrollment_term_id
FROM        CanvasDataStore.dbo.quiz_question_dim INNER JOIN
                  CanvasDataStore.dbo.quiz_question_fact ON CanvasDataStore.dbo.quiz_question_dim.id = CanvasDataStore.dbo.quiz_question_fact.quiz_question_id


GO
/****** Object:  View [dbo].[vQuizQuestionAnswer]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vQuizQuestionAnswer]
AS
SELECT     CanvasDataStore.dbo.quiz_question_answer_dim.id, CanvasDataStore.dbo.quiz_question_answer_dim.canvas_id, CanvasDataStore.dbo.quiz_question_answer_dim.quiz_question_id, CanvasDataStore.dbo.quiz_question_answer_dim.text, CanvasDataStore.dbo.quiz_question_answer_dim.html, CanvasDataStore.dbo.quiz_question_answer_dim.comments, 
                  CanvasDataStore.dbo.quiz_question_answer_dim.text_after_answers, CanvasDataStore.dbo.quiz_question_answer_dim.answer_match_left, CanvasDataStore.dbo.quiz_question_answer_dim.answer_match_right, CanvasDataStore.dbo.quiz_question_answer_dim.matching_answer_incorrect_matches, 
                  CanvasDataStore.dbo.quiz_question_answer_dim.numerical_answer_type, CanvasDataStore.dbo.quiz_question_answer_dim.blank_id, CanvasDataStore.dbo.quiz_question_answer_dim.exact, CanvasDataStore.dbo.quiz_question_answer_dim.margin, CanvasDataStore.dbo.quiz_question_answer_dim.starting_range, 
                  CanvasDataStore.dbo.quiz_question_answer_dim.ending_range, CanvasDataStore.dbo.quiz_question_answer_fact.quiz_question_group_id, CanvasDataStore.dbo.quiz_question_answer_fact.quiz_id, CanvasDataStore.dbo.quiz_question_answer_fact.assessment_question_id, CanvasDataStore.dbo.quiz_question_answer_fact.course_id, 
                  CanvasDataStore.dbo.quiz_question_answer_fact.assignment_id, CanvasDataStore.dbo.quiz_question_answer_fact.course_account_id, CanvasDataStore.dbo.quiz_question_answer_fact.weight, CanvasDataStore.dbo.quiz_question_answer_fact.enrollment_term_id
FROM        CanvasDataStore.dbo.quiz_question_answer_dim INNER JOIN
                  CanvasDataStore.dbo.quiz_question_answer_fact ON CanvasDataStore.dbo.quiz_question_answer_dim.id = CanvasDataStore.dbo.quiz_question_answer_fact.quiz_question_answer_id


GO
/****** Object:  View [dbo].[vQuizQuestionGroup]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vQuizQuestionGroup]
AS
SELECT     CanvasDataStore.dbo.quiz_question_group_dim.id, CanvasDataStore.dbo.quiz_question_group_dim.canvas_id, CanvasDataStore.dbo.quiz_question_group_dim.quiz_id, CanvasDataStore.dbo.quiz_question_group_dim.name, CanvasDataStore.dbo.quiz_question_group_dim.position, CanvasDataStore.dbo.quiz_question_group_dim.created_at, 
                  CanvasDataStore.dbo.quiz_question_group_dim.updated_at, CanvasDataStore.dbo.quiz_question_group_fact.pick_count, CanvasDataStore.dbo.quiz_question_group_fact.question_points, CanvasDataStore.dbo.quiz_question_group_fact.course_id, CanvasDataStore.dbo.quiz_question_group_fact.assignment_id, 
                  CanvasDataStore.dbo.quiz_question_group_fact.course_account_id, CanvasDataStore.dbo.quiz_question_group_fact.enrollment_term_id
FROM        CanvasDataStore.dbo.quiz_question_group_dim INNER JOIN
                  CanvasDataStore.dbo.quiz_question_group_fact ON CanvasDataStore.dbo.quiz_question_group_dim.id = CanvasDataStore.dbo.quiz_question_group_fact.quiz_question_group_id


GO
/****** Object:  View [dbo].[vQuizSubmission]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vQuizSubmission]
AS
SELECT     CanvasDataStore.dbo.quiz_submission_dim.id, CanvasDataStore.dbo.quiz_submission_dim.canvas_id, CanvasDataStore.dbo.quiz_submission_dim.quiz_id, CanvasDataStore.dbo.quiz_submission_dim.submission_id, CanvasDataStore.dbo.quiz_submission_dim.user_id, CanvasDataStore.dbo.quiz_submission_dim.workflow_state, 
                  CanvasDataStore.dbo.quiz_submission_dim.quiz_state_during_submission, CanvasDataStore.dbo.quiz_submission_dim.submission_scoring_policy, CanvasDataStore.dbo.quiz_submission_fact.score, CanvasDataStore.dbo.quiz_submission_fact.kept_score, CanvasDataStore.dbo.quiz_submission_fact.quiz_points_possible, 
                  CanvasDataStore.dbo.quiz_submission_fact.date, CanvasDataStore.dbo.quiz_submission_dim.submission_source, CanvasDataStore.dbo.quiz_submission_dim.has_seen_results, CanvasDataStore.dbo.quiz_submission_dim.temporary_user_code, CanvasDataStore.dbo.quiz_submission_dim.created_at, CanvasDataStore.dbo.quiz_submission_dim.updated_at, 
                  CanvasDataStore.dbo.quiz_submission_dim.started_at, CanvasDataStore.dbo.quiz_submission_dim.finished_at, CanvasDataStore.dbo.quiz_submission_dim.due_at, CanvasDataStore.dbo.quiz_submission_fact.time_taken, CanvasDataStore.dbo.quiz_submission_fact.extra_time, CanvasDataStore.dbo.quiz_submission_fact.extra_attempts, 
                  CanvasDataStore.dbo.quiz_submission_fact.total_attempts, CanvasDataStore.dbo.quiz_submission_fact.fudge_points, CanvasDataStore.dbo.quiz_submission_fact.score_before_regrade, CanvasDataStore.dbo.quiz_submission_fact.course_id, CanvasDataStore.dbo.quiz_submission_fact.enrollment_term_id, 
                  CanvasDataStore.dbo.quiz_submission_fact.course_account_id, CanvasDataStore.dbo.quiz_submission_fact.assignment_id, CanvasDataStore.dbo.quiz_submission_fact.enrollment_rollup_id, CanvasDataStore.dbo.quiz_submission_fact.quiz_submission_id
FROM        CanvasDataStore.dbo.quiz_submission_dim INNER JOIN
                  CanvasDataStore.dbo.quiz_submission_fact ON CanvasDataStore.dbo.quiz_submission_dim.id = CanvasDataStore.dbo.quiz_submission_fact.quiz_submission_id


GO
/****** Object:  View [dbo].[vQuizSubmissionHistorical]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vQuizSubmissionHistorical]
AS
SELECT     CanvasDataStore.dbo.quiz_submission_historical_dim.canvas_id, CanvasDataStore.dbo.quiz_submission_historical_dim.quiz_id, CanvasDataStore.dbo.quiz_submission_historical_dim.submission_id, CanvasDataStore.dbo.quiz_submission_historical_dim.user_id, CanvasDataStore.dbo.quiz_submission_historical_dim.submission_state, 
                  CanvasDataStore.dbo.quiz_submission_historical_dim.workflow_state, CanvasDataStore.dbo.quiz_submission_historical_dim.quiz_state_during_submission, CanvasDataStore.dbo.quiz_submission_historical_dim.submission_scoring_policy, CanvasDataStore.dbo.quiz_submission_historical_dim.submission_source, 
                  CanvasDataStore.dbo.quiz_submission_historical_dim.has_seen_results, CanvasDataStore.dbo.quiz_submission_historical_dim.temporary_user_code, CanvasDataStore.dbo.quiz_submission_historical_dim.started_at, CanvasDataStore.dbo.quiz_submission_historical_dim.finished_at, CanvasDataStore.dbo.quiz_submission_historical_fact.course_id, 
                  CanvasDataStore.dbo.quiz_submission_historical_fact.date, CanvasDataStore.dbo.quiz_submission_historical_fact.kept_score, CanvasDataStore.dbo.quiz_submission_historical_fact.score, CanvasDataStore.dbo.quiz_submission_historical_fact.course_account_id, CanvasDataStore.dbo.quiz_submission_historical_fact.assignment_id, 
                  CanvasDataStore.dbo.quiz_submission_historical_fact.quiz_points_possible, CanvasDataStore.dbo.quiz_submission_historical_fact.score_before_regrade, CanvasDataStore.dbo.quiz_submission_historical_fact.fudge_points, CanvasDataStore.dbo.quiz_submission_historical_fact.total_attempts, 
                  CanvasDataStore.dbo.quiz_submission_historical_fact.extra_attempts, CanvasDataStore.dbo.quiz_submission_historical_fact.extra_time, CanvasDataStore.dbo.quiz_submission_historical_fact.time_taken, CanvasDataStore.dbo.quiz_submission_historical_dim.version_number, CanvasDataStore.dbo.quiz_submission_historical_dim.created_at, 
                  CanvasDataStore.dbo.quiz_submission_historical_dim.updated_at, CanvasDataStore.dbo.quiz_submission_historical_dim.due_at, CanvasDataStore.dbo.quiz_submission_historical_fact.enrollment_term_id, CanvasDataStore.dbo.quiz_submission_historical_fact.enrollment_rollup_id
FROM        CanvasDataStore.dbo.quiz_submission_historical_dim INNER JOIN
                  CanvasDataStore.dbo.quiz_submission_historical_fact ON CanvasDataStore.dbo.quiz_submission_historical_dim.id = CanvasDataStore.dbo.quiz_submission_historical_fact.quiz_submission_historical_id


GO
/****** Object:  View [dbo].[vRequests]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vRequests]
AS
SELECT     course_id, user_id, timestamp_day, timestamp_month, timestamp_year, timestamp, id, quiz_id, discussion_id, conversation_id, assignment_id, url, user_agent, http_method, remote_ip, interaction_micros, web_application_controller, web_application_context_type, 
                  web_application_context_id, web_applicaiton_action, root_account_id, course_account_id, http_version, http_status, user_agent_id, session_id, real_user_id
FROM        CanvasDataStore.dbo.requests


GO
/****** Object:  View [dbo].[vRole]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vRole]
AS
SELECT     id, canvas_id, name, base_role_type, workflow_state, created_at, updated_at, deleted_at, root_account_id, account_id
FROM        CanvasDataStore.dbo.role_dim


GO
/****** Object:  View [dbo].[vScore]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vScore]
AS
SELECT     CanvasDataStore.dbo.score_dim.id, CanvasDataStore.dbo.score_dim.canvas_id, CanvasDataStore.dbo.score_dim.grading_period_id, CanvasDataStore.dbo.score_dim.workflow_state, CanvasDataStore.dbo.score_fact.account_id, CanvasDataStore.dbo.score_fact.course_id, CanvasDataStore.dbo.score_fact.grading_period_group_account_id, CanvasDataStore.dbo.score_fact.current_score, 
                  CanvasDataStore.dbo.score_fact.final_score, CanvasDataStore.dbo.score_dim.created_at, CanvasDataStore.dbo.score_dim.updated_at, CanvasDataStore.dbo.score_dim.enrollment_id, CanvasDataStore.dbo.score_fact.grading_period_group_id
FROM        CanvasDataStore.dbo.score_dim INNER JOIN
                  CanvasDataStore.dbo.score_fact ON CanvasDataStore.dbo.score_dim.id = CanvasDataStore.dbo.score_fact.score_id


GO
/****** Object:  View [dbo].[vSubmission]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vSubmission]
AS
SELECT     CanvasDataStore.dbo.submission_dim.id, CanvasDataStore.dbo.submission_dim.canvas_id, CanvasDataStore.dbo.submission_dim.submission_type, CanvasDataStore.dbo.submission_dim.created_at, CanvasDataStore.dbo.submission_dim.updated_at, CanvasDataStore.dbo.submission_dim.submitted_at, CanvasDataStore.dbo.submission_dim.attempt, 
                  CanvasDataStore.dbo.submission_dim.workflow_state, CanvasDataStore.dbo.submission_dim.processed, CanvasDataStore.dbo.submission_dim.process_attempts, CanvasDataStore.dbo.submission_dim.graded_at, CanvasDataStore.dbo.submission_dim.grade_matches_current_submission, CanvasDataStore.dbo.submission_fact.score, 
                  CanvasDataStore.dbo.submission_fact.published_score, CanvasDataStore.dbo.submission_fact.what_if_score, CanvasDataStore.dbo.submission_dim.grade, CanvasDataStore.dbo.submission_dim.published_grade, CanvasDataStore.dbo.submission_dim.has_rubric_assessment, CanvasDataStore.dbo.submission_dim.has_admin_comment, 
                  CanvasDataStore.dbo.submission_fact.submission_comments_count, CanvasDataStore.dbo.submission_dim.body, CanvasDataStore.dbo.submission_dim.url, CanvasDataStore.dbo.submission_dim.assignment_id AS Expr1, CanvasDataStore.dbo.submission_dim.excused, CanvasDataStore.dbo.submission_dim.graded_anonymously, 
                  CanvasDataStore.dbo.submission_dim.grader_id AS Expr2, CanvasDataStore.dbo.submission_dim.group_id, CanvasDataStore.dbo.submission_dim.quiz_submission_id, CanvasDataStore.dbo.submission_dim.grade_state, CanvasDataStore.dbo.submission_dim.user_id AS Expr3, CanvasDataStore.dbo.submission_fact.course_id, CanvasDataStore.dbo.submission_fact.enrollment_term_id, 
                  CanvasDataStore.dbo.submission_fact.course_account_id, CanvasDataStore.dbo.submission_fact.enrollment_rollup_id, CanvasDataStore.dbo.submission_fact.account_id, CanvasDataStore.dbo.submission_fact.assignment_group_id, CanvasDataStore.dbo.submission_fact.quiz_id, CanvasDataStore.dbo.submission_fact.wiki_id
FROM        CanvasDataStore.dbo.submission_dim INNER JOIN
                  CanvasDataStore.dbo.submission_fact ON CanvasDataStore.dbo.submission_dim.id = CanvasDataStore.dbo.submission_fact.submission_id


GO
/****** Object:  View [dbo].[vSubmissionComment]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vSubmissionComment]
AS
SELECT     CanvasDataStore.dbo.submission_comment_dim.id, CanvasDataStore.dbo.submission_comment_dim.canvas_id, CanvasDataStore.dbo.submission_comment_dim.submission_id, CanvasDataStore.dbo.submission_comment_dim.comment, CanvasDataStore.dbo.submission_comment_dim.group_comment_id, CanvasDataStore.dbo.submission_comment_dim.author_id, 
                  CanvasDataStore.dbo.submission_comment_dim.teacher_only_comment, CanvasDataStore.dbo.submission_comment_dim.anonymous, CanvasDataStore.dbo.submission_comment_dim.updated_at, CanvasDataStore.dbo.submission_comment_dim.created_at, CanvasDataStore.dbo.submission_comment_dim.hidden, 
                  CanvasDataStore.dbo.submission_comment_fact.message_character_count, CanvasDataStore.dbo.submission_comment_fact.message_size_bytes, CanvasDataStore.dbo.submission_comment_fact.message_line_count, CanvasDataStore.dbo.submission_comment_fact.message_word_count, 
                  CanvasDataStore.dbo.submission_comment_dim.author_name, CanvasDataStore.dbo.submission_comment_dim.assessment_request_id, CanvasDataStore.dbo.submission_comment_dim.recipient_id, CanvasDataStore.dbo.submission_comment_fact.submission_comment_id, CanvasDataStore.dbo.submission_comment_fact.assignment_id, 
                  CanvasDataStore.dbo.submission_comment_fact.course_id, CanvasDataStore.dbo.submission_comment_fact.enrollment_term_id, CanvasDataStore.dbo.submission_comment_fact.course_account_id
FROM        CanvasDataStore.dbo.submission_comment_dim INNER JOIN
                  CanvasDataStore.dbo.submission_comment_fact ON CanvasDataStore.dbo.submission_comment_dim.id = CanvasDataStore.dbo.submission_comment_fact.submission_comment_id


GO
/****** Object:  View [dbo].[vSubmissionParticipantComment]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vSubmissionParticipantComment]
AS
SELECT     CanvasDataStore.dbo.submission_comment_participant_dim.canvas_id, CanvasDataStore.dbo.submission_comment_participant_fact.user_id, CanvasDataStore.dbo.submission_comment_participant_dim.participation_type, CanvasDataStore.dbo.submission_comment_participant_dim.created_at, 
                  CanvasDataStore.dbo.submission_comment_participant_dim.updated_at, CanvasDataStore.dbo.submission_comment_participant_fact.submission_comment_id, CanvasDataStore.dbo.submission_comment_participant_fact.submission_id, CanvasDataStore.dbo.submission_comment_participant_fact.assignment_id, 
                  CanvasDataStore.dbo.submission_comment_participant_fact.course_id, CanvasDataStore.dbo.submission_comment_participant_fact.enrollment_term_id, CanvasDataStore.dbo.submission_comment_participant_fact.course_account_id, CanvasDataStore.dbo.submission_comment_participant_fact.enrollment_rollup_id
FROM        CanvasDataStore.dbo.submission_comment_participant_dim INNER JOIN
                  CanvasDataStore.dbo.submission_comment_participant_fact ON CanvasDataStore.dbo.submission_comment_participant_dim.id = CanvasDataStore.dbo.submission_comment_participant_fact.submission_comment_participant_id


GO
/****** Object:  View [dbo].[vWiki]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vWiki]
AS
SELECT        [CanvasDataStore].dbo.wiki_dim.id, [CanvasDataStore].dbo.wiki_dim.canvas_id, [CanvasDataStore].dbo.wiki_fact.parent_course_id, [CanvasDataStore].dbo.wiki_fact.parent_group_id, [CanvasDataStore].dbo.wiki_dim.created_at, [CanvasDataStore].dbo.wiki_dim.title, 
                         [CanvasDataStore].dbo.wiki_dim.front_page_url, [CanvasDataStore].dbo.wiki_dim.has_no_front_page, [CanvasDataStore].dbo.wiki_dim.updated_at, [CanvasDataStore].dbo.wiki_dim.parent_type
FROM            [CanvasDataStore].dbo.wiki_dim INNER JOIN
                         [CanvasDataStore].dbo.wiki_fact ON [CanvasDataStore].dbo.wiki_dim.id = [CanvasDataStore].dbo.wiki_fact.wiki_id




GO
/****** Object:  View [dbo].[vWikiPage]    Script Date: 4/24/2017 1:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vWikiPage]
AS
SELECT        [CanvasDataStore].dbo.wiki_page_dim.id, [CanvasDataStore].dbo.wiki_page_dim.canvas_id, [CanvasDataStore].dbo.wiki_page_fact.parent_course_id, [CanvasDataStore].dbo.wiki_page_fact.parent_group_id, [CanvasDataStore].dbo.wiki_page_fact.user_id, 
                         [CanvasDataStore].dbo.wiki_page_fact.view_count, [CanvasDataStore].dbo.wiki_page_fact.wiki_page_comments_count, [CanvasDataStore].dbo.wiki_page_dim.workflow_state, [CanvasDataStore].dbo.wiki_page_dim.created_at, 
                         [CanvasDataStore].dbo.wiki_page_dim.updated_at, [CanvasDataStore].dbo.wiki_page_dim.url, [CanvasDataStore].dbo.wiki_page_dim.protected_editing, [CanvasDataStore].dbo.wiki_page_dim.editing_roles, [CanvasDataStore].dbo.wiki_page_dim.revised_at, 
                         [CanvasDataStore].dbo.wiki_page_dim.could_be_locked
FROM            [CanvasDataStore].dbo.wiki_page_dim INNER JOIN
                         [CanvasDataStore].dbo.wiki_page_fact ON [CanvasDataStore].dbo.wiki_page_dim.id = [CanvasDataStore].dbo.wiki_page_fact.wiki_page_id




GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[15] 4[69] 2[3] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "vDiscussionTopic"
            Begin Extent = 
               Top = 31
               Left = 57
               Bottom = 620
               Right = 391
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "cvUsers"
            Begin Extent = 
               Top = 153
               Left = 938
               Bottom = 528
               Right = 1141
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "vCourse"
            Begin Extent = 
               Top = 54
               Left = 541
               Bottom = 512
               Right = 845
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 2055
         Alias = 900
         Table = 2520
         Output = 2460
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'cvAnnouncements'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'cvAnnouncements'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "vDiscussionTopic"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 136
               Right = 301
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "cvUsers"
            Begin Extent = 
               Top = 6
               Left = 339
               Bottom = 136
               Right = 525
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "vCourse"
            Begin Extent = 
               Top = 6
               Left = 563
               Bottom = 136
               Right = 760
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'cvDiscussions'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'cvDiscussions'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "vEnrollmentRollup"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 136
               Right = 320
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "cvUsers"
            Begin Extent = 
               Top = 6
               Left = 358
               Bottom = 136
               Right = 544
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "vCourse"
            Begin Extent = 
               Top = 6
               Left = 582
               Bottom = 136
               Right = 779
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'cvStudentEnrollments'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'cvStudentEnrollments'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[21] 4[56] 2[4] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "vEnrollmentRollup"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 566
               Right = 342
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "cvUsers"
            Begin Extent = 
               Top = 255
               Left = 909
               Bottom = 538
               Right = 1095
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "vCourse"
            Begin Extent = 
               Top = 227
               Left = 447
               Bottom = 584
               Right = 644
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 2790
         Width = 4815
         Width = 2190
         Width = 2100
         Width = 1950
         Width = 1740
         Width = 2355
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'cvTeacherEnrollments'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'cvTeacherEnrollments'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[19] 4[60] 2[4] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = -96
         Left = 0
      End
      Begin Tables = 
         Begin Table = "vUser"
            Begin Extent = 
               Top = 9
               Left = 107
               Bottom = 495
               Right = 275
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "vPseudonym"
            Begin Extent = 
               Top = 0
               Left = 460
               Bottom = 484
               Right = 690
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1980
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'cvUsers'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'cvUsers'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[6] 4[55] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = -1399
      End
      Begin Tables = 
         Begin Table = "account_dim"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 328
               Right = 478
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAccount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAccount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[73] 4[2] 2[7] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "assignment_dim"
            Begin Extent = 
               Top = 12
               Left = 82
               Bottom = 742
               Right = 627
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "assignment_fact"
            Begin Extent = 
               Top = 91
               Left = 737
               Bottom = 403
               Right = 1161
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 12
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 3636
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAssignment'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAssignment'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "assignment_group_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 373
               Right = 327
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "assignment_group_fact"
            Begin Extent = 
               Top = 67
               Left = 532
               Bottom = 393
               Right = 810
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAssignmentGroup'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAssignmentGroup'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "assignment_group_rule_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 299
               Right = 358
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAssignmentGroupRule'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAssignmentGroupRule'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[75] 4[2] 2[4] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "assignment_override_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 654
               Right = 342
            End
            DisplayFlags = 280
            TopColumn = 8
         End
         Begin Table = "assignment_override_fact"
            Begin Extent = 
               Top = 175
               Left = 540
               Bottom = 582
               Right = 892
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAssignmentOverride'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAssignmentOverride'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "assignment_rule_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 311
               Right = 349
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAssignmentRule'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vAssignmentRule'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "communication_channel_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 352
               Right = 366
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "communication_channel_fact"
            Begin Extent = 
               Top = 65
               Left = 526
               Bottom = 371
               Right = 843
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vCommunicationChannel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vCommunicationChannel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "conversation_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 342
               Right = 394
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vConversation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vConversation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "conversation_message_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 372
               Right = 580
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vConversationMessage'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vConversationMessage'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[79] 4[2] 2[2] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "conversation_message_participant_fact"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 711
               Right = 613
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vConversationMessageParticipant'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vConversationMessageParticipant'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[81] 4[3] 2[12] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "course_dim"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 497
               Right = 543
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 2496
         Table = 2928
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vCourse'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vCourse'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[72] 4[2] 2[7] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "course_section_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 709
               Right = 640
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vCourseSection'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vCourseSection'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "course_ui_canvas_navigation_dim"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 271
               Right = 525
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vCourseUICanvasNavigation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vCourseUICanvasNavigation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[41] 4[37] 2[4] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "course_ui_navigation_item_dim"
            Begin Extent = 
               Top = 30
               Left = 86
               Bottom = 228
               Right = 336
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "course_ui_navigation_item_fact"
            Begin Extent = 
               Top = 31
               Left = 448
               Bottom = 295
               Right = 726
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 3960
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vCourseUINavigationItem'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vCourseUINavigationItem'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[80] 4[2] 2[2] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "discussion_entry_dim"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 477
               Right = 261
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "discussion_entry_fact"
            Begin Extent = 
               Top = 25
               Left = 337
               Bottom = 648
               Right = 641
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vDiscussionEntry'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vDiscussionEntry'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "discussion_topic_dim (CanvasDataStore.dbo)"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 297
               Right = 270
            End
            DisplayFlags = 280
            TopColumn = 5
         End
         Begin Table = "discussion_topic_fact (CanvasDataStore.dbo)"
            Begin Extent = 
               Top = 6
               Left = 302
               Bottom = 327
               Right = 565
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vDiscussionTopic'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vDiscussionTopic'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[75] 4[12] 3[2] 2) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "enrollment_dim (CanvasDataStore.dbo)"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 505
               Right = 450
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "enrollment_fact (CanvasDataStore.dbo)"
            Begin Extent = 
               Top = 162
               Left = 644
               Bottom = 577
               Right = 1255
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 3240
         Alias = 3330
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vEnrollment'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vEnrollment'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[12] 4[81] 2[3] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "enrollment_rollup_dim (CanvasDataStore.dbo)"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 136
               Right = 320
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 4230
         Alias = 3675
         Table = 4995
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vEnrollmentRollup'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vEnrollmentRollup'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "enrollment_term_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 383
               Right = 388
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vEnrollmentTerm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vEnrollmentTerm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[54] 4[7] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "external_tool_activation_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 524
               Right = 363
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "external_tool_activation_fact"
            Begin Extent = 
               Top = 145
               Left = 517
               Bottom = 498
               Right = 1004
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vExternalToolActivation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vExternalToolActivation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[76] 4[2] 2[3] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "file_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 773
               Right = 310
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "file_fact"
            Begin Extent = 
               Top = 29
               Left = 558
               Bottom = 768
               Right = 869
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vFile'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vFile'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[83] 4[2] 2[2] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "grading_period_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 385
               Right = 310
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "grading_period_fact"
            Begin Extent = 
               Top = 7
               Left = 358
               Bottom = 323
               Right = 678
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vGradingPeriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vGradingPeriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "grading_period_group_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 380
               Right = 354
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vGradingPeriodGroup'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vGradingPeriodGroup'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "group_membership_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 380
               Right = 335
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "group_membership_fact"
            Begin Extent = 
               Top = 7
               Left = 383
               Bottom = 381
               Right = 669
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vGroupMembership'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vGroupMembership'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[81] 4[2] 2[2] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "module_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 707
               Right = 327
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "module_fact"
            Begin Extent = 
               Top = 126
               Left = 500
               Bottom = 533
               Right = 723
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModule'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModule'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[69] 4[2] 2[10] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "module_completion_requirement_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 531
               Right = 426
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "module_completion_requirement_fact"
            Begin Extent = 
               Top = 28
               Left = 552
               Bottom = 687
               Right = 929
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModuleCompletionRequirement'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModuleCompletionRequirement'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[8] 4[64] 2[10] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "module_item_dim (CanvasDataStore.dbo)"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 434
               Right = 247
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "module_item_fact (CanvasDataStore.dbo)"
            Begin Extent = 
               Top = 27
               Left = 526
               Bottom = 479
               Right = 1204
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModuleItem'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModuleItem'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[64] 4[2] 2[15] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "module_prerequisite_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 324
               Right = 342
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "module_prerequisite_fact"
            Begin Extent = 
               Top = 7
               Left = 390
               Bottom = 353
               Right = 683
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModulePrerequisite'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModulePrerequisite'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[23] 4[70] 2[2] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "module_progression_dim (CanvasDataStore.dbo)"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 471
               Right = 285
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "module_progression_fact (CanvasDataStore.dbo)"
            Begin Extent = 
               Top = 9
               Left = 423
               Bottom = 524
               Right = 669
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModuleProgression'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModuleProgression'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[88] 4[2] 2[2] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "module_progression_completion_requirement_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 536
               Right = 510
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "module_progression_completion_requirement_fact"
            Begin Extent = 
               Top = 7
               Left = 558
               Bottom = 756
               Right = 1019
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModuleProgressionCompletionRequirement'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vModuleProgressionCompletionRequirement'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[76] 4[2] 2[3] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "pseudonym_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 601
               Right = 394
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "pseudonym_fact"
            Begin Extent = 
               Top = 132
               Left = 621
               Bottom = 503
               Right = 944
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vPseudonym'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vPseudonym'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[88] 4[2] 2[2] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "quiz_dim"
            Begin Extent = 
               Top = 12
               Left = 129
               Bottom = 870
               Right = 504
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "quiz_fact"
            Begin Extent = 
               Top = 144
               Left = 703
               Bottom = 756
               Right = 1032
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 4668
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuiz'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuiz'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[63] 4[7] 2[12] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "quiz_question_dim"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 573
               Right = 370
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "quiz_question_fact"
            Begin Extent = 
               Top = 51
               Left = 422
               Bottom = 610
               Right = 843
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 5268
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuizQuestion'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuizQuestion'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[80] 4[2] 2[2] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "quiz_question_answer_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 600
               Right = 382
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "quiz_question_answer_fact"
            Begin Extent = 
               Top = 64
               Left = 510
               Bottom = 798
               Right = 810
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuizQuestionAnswer'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuizQuestionAnswer'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[80] 4[2] 2[2] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "quiz_question_group_dim"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 279
               Right = 287
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "quiz_question_group_fact"
            Begin Extent = 
               Top = 30
               Left = 387
               Bottom = 636
               Right = 635
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuizQuestionGroup'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuizQuestionGroup'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[68] 4[19] 2[3] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "quiz_submission_dim"
            Begin Extent = 
               Top = 21
               Left = 110
               Bottom = 610
               Right = 432
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "quiz_submission_fact"
            Begin Extent = 
               Top = 34
               Left = 517
               Bottom = 665
               Right = 914
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuizSubmission'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuizSubmission'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[73] 4[2] 2[6] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "quiz_submission_historical_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 588
               Right = 379
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "quiz_submission_historical_fact"
            Begin Extent = 
               Top = 7
               Left = 427
               Bottom = 682
               Right = 757
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuizSubmissionHistorical'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vQuizSubmissionHistorical'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[65] 4[3] 2[14] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "requests"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 687
               Right = 691
            End
            DisplayFlags = 280
            TopColumn = 1
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vRequests'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vRequests'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[71] 4[2] 2[8] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "role_dim"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 644
               Right = 601
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vRole'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vRole'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[80] 4[2] 2[2] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "score_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 734
               Right = 264
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "score_fact"
            Begin Extent = 
               Top = 91
               Left = 421
               Bottom = 728
               Right = 741
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vScore'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vScore'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[71] 4[9] 2[3] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "submission_dim"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 727
               Right = 421
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "submission_fact"
            Begin Extent = 
               Top = 44
               Left = 458
               Bottom = 671
               Right = 893
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 3168
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vSubmission'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vSubmission'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[72] 4[2] 2[6] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "submission_comment_dim"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 706
               Right = 364
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "submission_comment_fact"
            Begin Extent = 
               Top = 29
               Left = 417
               Bottom = 673
               Right = 718
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vSubmissionComment'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vSubmissionComment'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[76] 4[2] 2[3] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "submission_comment_participant_dim"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 406
               Right = 415
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "submission_comment_participant_fact"
            Begin Extent = 
               Top = 34
               Left = 489
               Bottom = 484
               Right = 949
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vSubmissionParticipantComment'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vSubmissionParticipantComment'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[72] 4[2] 2[7] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "user_dim"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 675
               Right = 573
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vUser'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vUser'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "wiki_dim"
            Begin Extent = 
               Top = 18
               Left = 81
               Bottom = 297
               Right = 316
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "wiki_fact"
            Begin Extent = 
               Top = 48
               Left = 435
               Bottom = 339
               Right = 764
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vWiki'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vWiki'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "wiki_page_dim"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 305
               Right = 276
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "wiki_page_fact"
            Begin Extent = 
               Top = 32
               Left = 411
               Bottom = 351
               Right = 726
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vWikiPage'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vWikiPage'
GO