# Google Classroom schema ERD

Table and field reference for the Fivetran Google Classroom connector.

## Table & Field Reference

### student_submission_history

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| course_id | Unknown | PK, FK |
| course_work_id | Unknown | PK, FK |
| student_submission_id | Unknown | PK, FK |
| grade_change_type | Unknown |  |
| grade_history_actor_user_id | Unknown |  |
| grade_max_points | Unknown |  |
| grade_timestamp | Unknown |  |
| points_earned | Unknown |  |
| state | Unknown |  |
| state_history_actor_user_id | Unknown |  |
| state_timestamp | Unknown |  |

### student_submission_attachment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| course_id | Unknown | PK, FK |
| course_work_id | Unknown | PK, FK |
| student_submission_id | Unknown | PK, FK |
| drive_file_alternate_link | Unknown |  |
| drive_file_id | Unknown |  |
| drive_file_thumbnail_url | Unknown |  |
| drive_file_title | Unknown |  |
| form_response_url | Unknown |  |
| form_thumbnail_url | Unknown |  |
| form_title | Unknown |  |
| form_url | Unknown |  |
| link_thumbnail_url | Unknown |  |
| link_title | Unknown |  |
| link_url | Unknown |  |
| youtube_video_alternate_link | Unknown |  |
| youtube_video_id | Unknown |  |
| youtube_video_thumbnail_url | Unknown |  |
| youtube_video_title | Unknown |  |

### student_submission

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| course_id | Unknown | PK, FK |
| course_work_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| alternate_link | Unknown |  |
| assigned_grade | Unknown |  |
| associated_with_developer | Unknown |  |
| course_work_type | Unknown |  |
| creation_time | Unknown |  |
| draft_grade | Unknown |  |
| late | Unknown |  |
| multiple_choice_submission_answer | Unknown |  |
| preview_version | Unknown |  |
| short_answer_submission_answer | Unknown |  |
| state | Unknown |  |
| update_time | Unknown |  |

### course_material_set

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| course_id | Unknown | PK, FK |
| drive_file_alternate_link | Unknown |  |
| drive_file_id | Unknown |  |
| drive_file_thumbnail_url | Unknown |  |
| drive_file_title | Unknown |  |
| form_response_url | Unknown |  |
| form_thumbnail_url | Unknown |  |
| form_title | Unknown |  |
| form_url | Unknown |  |
| link_thumbnai_lurl | Unknown |  |
| link_title | Unknown |  |
| link_url | Unknown |  |
| title | Unknown |  |
| youtube_video_alternate_link | Unknown |  |
| youtube_video_id | Unknown |  |
| youtube_video_thumbnail_url | Unknown |  |
| youtube_video_title | Unknown |  |

### course_grade_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| course_id | Unknown | PK, FK |
| default_grade_denominator | Unknown |  |
| name | Unknown |  |
| weight | Unknown |  |

### course

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| alternate_link | Unknown |  |
| calendar_id | Unknown |  |
| course_group_email | Unknown |  |
| course_state | Unknown |  |
| creation_time | Unknown |  |
| description_heading | Unknown |  |
| enrollment_code | Unknown |  |
| gradebook_setting_calculation_type | Unknown |  |
| gradebook_setting_display_setting | Unknown |  |
| guardians_enabled | Unknown |  |
| name | Unknown |  |
| owner_id | Unknown |  |
| section | Unknown |  |
| teacher_folder_alternate_link | Unknown |  |
| teacher_folder_id | Unknown |  |
| teacher_folder_title | Unknown |  |
| teacher_group_email | Unknown |  |
| update_time | Unknown |  |

### student_permission

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| student_course_id | Unknown | PK, FK |
| student_id | Unknown | PK, FK |
| permission | Unknown |  |

### student

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| course_id | Unknown | PK, FK |
| profile_email_address | Unknown |  |
| profile_family_name | Unknown |  |
| profile_full_name | Unknown |  |
| profile_given_name | Unknown |  |
| profile_photo_url | Unknown |  |
| profile_verified_teacher | Unknown |  |
| student_work_folder_alternate_link | Unknown |  |
| student_work_folder_id | Unknown |  |
| student_work_folder_title | Unknown |  |

### course_work_material

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| course_id | Unknown | PK, FK |
| course_work_id | Unknown | PK, FK |
| drive_file_alternate_link | Unknown |  |
| drive_file_id | Unknown |  |
| drive_file_thumbnail_url | Unknown |  |
| drive_file_title | Unknown |  |
| form_response_url | Unknown |  |
| form_thumbnail_url | Unknown |  |
| form_title | Unknown |  |
| form_url | Unknown |  |
| link_thumbnai_lurl | Unknown |  |
| link_title | Unknown |  |
| link_url | Unknown |  |
| share_mode | Unknown |  |
| youtube_video_alternate_link | Unknown |  |
| youtube_video_id | Unknown |  |
| youtube_video_thumbnail_url | Unknown |  |
| youtube_video_title | Unknown |  |

### course_work_multiple_choice_question

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| course_id | Unknown | PK, FK |
| course_work_id | Unknown | PK, FK |
| choice | Unknown |  |

### course_work_student

| Column | Type | Keys |
| --- | --- | --- |
| course_id | Unknown | PK, FK |
| course_work_id | Unknown | PK, FK |
| student_id | Unknown | PK, FK |

### course_work

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| course_id | Unknown | PK, FK |
| alternate_link | Unknown |  |
| assignee_mode | Unknown |  |
| associated_with_developer | Unknown |  |
| creation_time | Unknown |  |
| creator_user_id | Unknown |  |
| description | Unknown |  |
| due_date_day | Unknown |  |
| due_date_month | Unknown |  |
| due_date_year | Unknown |  |
| due_time_hours | Unknown |  |
| due_time_minutes | Unknown |  |
| grade_category_default_grade_denominator | Unknown |  |
| grade_category_id | Unknown |  |
| grade_category_name | Unknown |  |
| grade_category_weight | Unknown |  |
| grading_period_id | Unknown |  |
| max_points | Unknown |  |
| preview_version | Unknown |  |
| scheduled_time | Unknown |  |
| state | Unknown |  |
| student_work_folder_alternate_link | Unknown |  |
| student_work_folder_id | Unknown |  |
| student_work_folder_title | Unknown |  |
| submission_modification_mode | Unknown |  |
| title | Unknown |  |
| topic_id | Unknown |  |
| update_time | Instant |  |
| work_type | Unknown |  |

### teacher_permission

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| teacher_course_id | Unknown | PK, FK |
| teacher_id | Unknown | PK, FK |
| permission | Unknown |  |

### teacher

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| course_id | Unknown | PK, FK |
| profile_email_address | Unknown |  |
| profile_family_name | Unknown |  |
| profile_full_name | Unknown |  |
| profile_given_name | Unknown |  |
| profile_photo_url | Unknown |  |
| profile_verified_teacher | Unknown |  |

## Relationships

- student_submission_history(student_submission_id) → student_submission(id)
- student_submission_history(course_id) → student_submission(course_id)
- student_submission_history(course_work_id) → student_submission(course_work_id)
- student_submission_attachment(student_submission_id) → student_submission(id)
- student_submission_attachment(course_id) → student_submission(course_id)
- student_submission_attachment(course_work_id) → student_submission(course_work_id)
- student_submission(user_id) → student(id)
- student_submission(course_id) → course_work(course_id)
- student_submission(course_work_id) → course_work(id)
- course_material_set(course_id) → course(id)
- course_grade_category(course_id) → course(id)
- student_permission(student_course_id) → student(course_id)
- student_permission(student_id) → student(id)
- student(course_id) → course(id)
- course_work_material(course_work_id) → course_work(id)
- course_work_material(course_id) → course_work(course_id)
- course_work_multiple_choice_question(course_work_id) → course_work(id)
- course_work_multiple_choice_question(course_id) → course_work(course_id)
- course_work_student(student_id) → student(id)
- course_work_student(course_work_id) → course_work(id)
- course_work_student(course_id) → course_work(course_id)
- course_work(course_id) → course(id)
- teacher_permission(teacher_id) → teacher(id)
- teacher_permission(teacher_course_id) → teacher(course_id)
- teacher(course_id) → course(id)