Google Classroom

Explore the interactive ERD

Column	Type	Keys
`index`	Unknown	PK
`course_id`	Unknown	PKFK
`course_work_id`	Unknown	PKFK
`student_submission_id`	Unknown	PKFK
`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

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	PKFK
`course_work_id`	Unknown	PKFK
`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

Column	Type	Keys
`index`	Unknown	PK
`course_id`	Unknown	PKFK
`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

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

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	PKFK
`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

Column	Type	Keys
`index`	Unknown	PK
`course_id`	Unknown	PKFK
`course_work_id`	Unknown	PKFK
`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

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	PKFK
`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