D2L Brightspace

Explore the interactive ERD

Table & Field Reference

survey_category

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`name`	Unknown
`sort_order`	Unknown

organization_descendant

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`code`	Unknown
`name`	Unknown
`path`	Unknown
`type_code`	Unknown
`type_id`	Unknown
`type_name`	Unknown

survey_attempt

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`survey_id`	Unknown	FK
`user_id`	Unknown	FK
`attempt_number`	Unknown
`completed`	Unknown
`started`	Unknown

organization_colour

Column	Type	Keys
`_fivetran_id`	String	PK
`dark`	Unknown
`light`	Unknown
`soft`	Unknown

organization_parent

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`code`	Unknown
`name`	Unknown
`path`	Unknown
`type_code`	Unknown
`type_id`	Unknown
`type_name`	Unknown

dropbox_folder_category

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`last_modified_user_id`	Unknown	FK
`last_modified_date`	Unknown
`name`	Unknown

enrollement_class_list

Column	Type	Keys
`id`	Unknown	PKFK
`organization_id`	Unknown	PKFK
`classlist_role_display_name`	Unknown
`display_name`	Unknown
`email`	Unknown
`is_online`	Unknown
`org_defined_id`	Unknown
`profile_id`	Unknown
`role_id`	Unknown

enrollment_user

Column	Type	Keys
`id`	Unknown	PKFK
`organization_id`	Unknown	PKFK
`email`	Unknown
`org_defined_id`	Unknown
`profile_badge_url`	Unknown
`profile_id`	Unknown
`role_code`	Unknown
`role_id`	Unknown
`role_name`	Unknown

quiz

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`activity_id`	Unknown
`allow_hints`	Unknown
`allow_only_users_with_special_access`	Unknown
`auto_export_to_grade`	Unknown
`calc_type_id`	Unknown
`category_id`	Unknown
`description_is_displayed`	Unknown
`description_text`	Unknown
`disable_pager_and_alerts`	Unknown
`disable_right_click`	Unknown
`display_in_calendar`	Unknown
`due_date`	Unknown
`end_date`	Unknown
`footer_is_displayed`	Unknown
`footer_text`	Unknown
`grade_item_id`	Unknown
`header_is_displayed`	Unknown
`header_text`	Unknown
`instructions_is_displayed`	Unknown
`instructions_text`	Unknown
`is_active`	Unknown
`is_attempts_unlimited`	Unknown
`is_auto_set_graded`	Unknown
`is_retake_incorrect_only`	Unknown
`late_limit_minutes`	Unknown
`late_submission_option`	Unknown
`name`	Unknown
`notification_email`	Unknown
`number_of_attempts_allowed`	Unknown
`password`	Unknown
`prevent_moving_backwards`	Unknown
`restrict_ip_address_range`	Json
`shuffle`	Unknown
`sort_order`	Unknown
`start_date`	Unknown
`submission_grace_period`	Unknown
`submission_time_limit_is_enforced`	Unknown
`submission_time_limit_show_clock`	Unknown
`submission_time_limit_time_limit_value`	Unknown

completion

Column	Type	Keys
`org_id`	Unknown	PKFK
`topic_id`	Unknown	PKFK
`user_id`	Unknown	PKFK
`completion_date`	Unknown
`completion_type`	Unknown

dropbox_folder_access

Column	Type	Keys
`dropbox_folder_id`	Unknown	PKFK
`organization_id`	Unknown	PKFK
`user_id`	Unknown	PKFK
`has_access`	Unknown

dropbox_folder_attachment

Column	Type	Keys
`id`	Unknown	PK
`dropbox_folder_id`	Unknown	PKFK
`organization_id`	Unknown	PKFK
`file_name`	Unknown
`size`	Unknown

dropbox_folder

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`category_id`	Unknown	FK
`activity_id`	Unknown
`allow_only_users_with_special_access`	Unknown
`allowable_file_type`	Unknown
`assessment_rubric`	Json
`assessment_score_denominator`	Unknown
`availability_end_date`	Unknown
`availability_end_date_availability_type`	Unknown
`availability_start_date`	Unknown
`availability_start_date_availability_type`	Unknown
`completion_type`	Unknown
`custom_allowable_file_type`	Json
`custom_instruction`	Json
`display_in_calendar`	Unknown
`dropbox_type`	Unknown
`due_date`	Unknown
`grade_item_id`	Unknown
`group_type_id`	Unknown
`is_anonymous`	Unknown
`is_hidden`	Unknown
`link_attachment`	Json
`name`	Unknown
`notification_email`	Unknown
`submission_type`	Unknown

topic

Column	Type	Keys
`id`	Unknown	PK
`module_id`	Unknown	PKFK
`organization_id`	Unknown	PKFK
`activity_id`	Unknown
`activity_type`	Unknown
`bookmarked`	Unknown
`completion_type`	Unknown
`description_text`	Unknown
`end_date_time`	Unknown
`grade_item_id`	Unknown
`identifier`	Unknown
`is_broken`	Unknown
`is_exempt`	Unknown
`is_hidden`	Unknown
`is_locked`	Unknown
`last_modified_date`	Unknown
`sort_order`	Unknown
`start_date_time`	Unknown
`title`	Unknown
`tool_id`	Unknown
`tool_item_id`	Unknown
`type_identifier`	Unknown
`unread`	Unknown
`url`	Unknown

module

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`default_path`	Unknown
`description_text`	Unknown
`end_date_time`	Unknown
`is_hidden`	Unknown
`is_locked`	Unknown
`last_modified_date`	Unknown
`pacing_end_date`	Unknown
`pacing_start_date`	Unknown
`sort_order`	Unknown
`start_date_time`	Unknown
`sub_modules`	Json
`title`	Unknown

dropbox_folder_submission_file

Column	Type	Keys
`id`	Unknown	PK
`dropbox_folder_id`	Unknown	PKFK
`dropbox_folder_submission_id`	Unknown	PKFK
`organization_id`	Unknown	PKFK
`file_name`	Unknown
`is_deleted`	Unknown
`is_flagged`	Unknown
`is_read`	Unknown
`size`	Unknown

dropbox_folder_submission

Column	Type	Keys
`id`	Unknown	PK
`dropbox_folder_id`	Unknown	PKFK
`organization_id`	Unknown	PKFK
`submitted_by_identifier`	Unknown	FK
`comment_html`	Unknown
`comment_text`	Unknown
`submission_date`	Unknown
`submitted_by_display_name`	Unknown

survey_question_info

Column	Type	Keys
`name`	Unknown	PK
`survey_question_id`	Unknown	PKFK
`survey_question_organization_id`	Unknown	PKFK
`survey_question_survey_id`	Unknown	PKFK
`value`	Unknown

survey_question

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`survey_id`	Unknown	PKFK
`bonus`	Unknown
`difficulty`	Unknown
`feedback`	Unknown
`hint`	Unknown
`last_modified`	Unknown
`last_modified_by`	Unknown
`mandatory`	Unknown
`name`	Unknown
`points`	Unknown
`section_id`	Unknown
`template_id`	Unknown
`template_version_id`	Unknown
`text`	Unknown
`type_id`	Unknown

organization_child

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`code`	Unknown
`name`	Unknown
`path`	Unknown
`type_code`	Unknown
`type_id`	Unknown
`type_name`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`org_id`	Unknown	PKFK
`display_name`	Unknown
`external_email`	Unknown
`first_name`	Unknown
`is_active`	Unknown
`last_accessed_date`	Unknown
`last_name`	Unknown
`middle_name`	Unknown
`org_defined_id`	Unknown
`pronoun`	Unknown
`unique_identifier`	Unknown
`user_name`	Unknown

organization_unit

Column	Type	Keys
`id`	Unknown	PK
`code`	Unknown
`name`	Unknown
`path`	Unknown
`type_code`	Unknown
`type_id`	Unknown
`type_name`	Unknown

organization_ancestor

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`code`	Unknown
`name`	Unknown
`path`	Unknown
`type_code`	Unknown
`type_id`	Unknown
`type_name`	Unknown

organization

Column	Type	Keys
`id`	Unknown	PK
`code`	Unknown
`name`	Unknown
`path`	Unknown
`type_code`	Unknown
`type_id`	Unknown
`type_name`	Unknown

survey

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`category_id`	Unknown	FK
`activity_id`	Unknown
`allow_only_users_with_special_access`	Unknown
`description_is_displayed`	Unknown
`description_text`	Unknown
`display_in_calendar`	Unknown
`end_date`	Unknown
`footer_is_displayed`	Unknown
`footer_text`	Unknown
`has_instant_feedback`	Unknown
`is_active`	Unknown
`is_anonymous`	Unknown
`name`	Unknown
`prevent_moving_backwards`	Unknown
`shuffle`	Unknown
`sort_order`	Unknown
`start_date`	Unknown
`submission_text`	Unknown
`user_response_attempt_allowed_type_id`	Unknown
`user_response_number_of_attempts`	Unknown