# D2L Brightspace schema ERD

Table and field reference for the Fivetran D2L Brightspace connector.

## Table & Field Reference

### survey_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| name | Unknown |  |
| sort_order | Unknown |  |

### organization_descendant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| last_modified_user_id | Unknown | FK |
| last_modified_date | Unknown |  |
| name | Unknown |  |

### enrollement_class_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| 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 | PK, FK |
| organization_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| topic_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| completion_date | Unknown |  |
| completion_type | Unknown |  |

### dropbox_folder_access

| Column | Type | Keys |
| --- | --- | --- |
| dropbox_folder_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| has_access | Unknown |  |

### dropbox_folder_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| dropbox_folder_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| file_name | Unknown |  |
| size | Unknown |  |

### dropbox_folder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| 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 | PK, FK |
| organization_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| dropbox_folder_submission_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| 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 | PK, FK |
| organization_id | Unknown | PK, FK |
| 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 | PK, FK |
| survey_question_organization_id | Unknown | PK, FK |
| survey_question_survey_id | Unknown | PK, FK |
| value | Unknown |  |

### survey_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| survey_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- survey_category(organization_id) → organization(id)
- organization_descendant(organization_id) → organization(id)
- survey_attempt(survey_id) → survey(id)
- survey_attempt(user_id) → users(id)
- survey_attempt(organization_id) → organization(id)
- organization_parent(organization_id) → organization(id)
- dropbox_folder_category(last_modified_user_id) → users(id)
- dropbox_folder_category(organization_id) → organization(id)
- enrollement_class_list(id) → users(id)
- enrollement_class_list(organization_id) → organization(id)
- enrollment_user(id) → users(id)
- enrollment_user(organization_id) → organization(id)
- quiz(organization_id) → organization(id)
- completion(user_id) → users(id)
- completion(org_id) → organization(id)
- completion(topic_id) → topic(id)
- dropbox_folder_access(user_id) → users(id)
- dropbox_folder_access(dropbox_folder_id) → dropbox_folder(id)
- dropbox_folder_access(organization_id) → dropbox_folder(organization_id)
- dropbox_folder_attachment(dropbox_folder_id) → dropbox_folder(id)
- dropbox_folder_attachment(organization_id) → dropbox_folder(organization_id)
- dropbox_folder(category_id) → dropbox_folder_category(id)
- dropbox_folder(organization_id) → organization(id)
- topic(module_id) → module(id)
- topic(organization_id) → module(organization_id)
- module(organization_id) → organization(id)
- dropbox_folder_submission_file(dropbox_folder_submission_id) → dropbox_folder_submission(id)
- dropbox_folder_submission_file(dropbox_folder_id) → dropbox_folder_submission(dropbox_folder_id)
- dropbox_folder_submission_file(organization_id) → dropbox_folder_submission(organization_id)
- dropbox_folder_submission(submitted_by_identifier) → users(id)
- dropbox_folder_submission(dropbox_folder_id) → dropbox_folder(id)
- dropbox_folder_submission(organization_id) → dropbox_folder(organization_id)
- survey_question_info(survey_question_id) → survey_question(id)
- survey_question_info(survey_question_survey_id) → survey_question(survey_id)
- survey_question_info(survey_question_organization_id) → survey_question(organization_id)
- survey_question(survey_id) → survey(id)
- survey_question(organization_id) → organization(id)
- organization_child(organization_id) → organization(id)
- users(org_id) → organization(id)
- organization_ancestor(organization_id) → organization(id)
- survey(category_id) → survey_category(id)
- survey(organization_id) → organization(id)