강의실 ERD
테이블 (12)
과제(캔버스기본) (assignments)
- 아이디 (id) — bigserial — 기본 키 — NOT NULL
- 제목 (title) — varchar(255)
- 내용 (description) — text
- 정상 제출 종료 일시 (지연시작 일시) (due_at) — timestamp
- 정상 제출(열림) 시작 일시 (unlock_at) — timestamp
- 마감 제출 종료 일시 (lock_at) — timestamp
- 획득 가능 점수 (points_possible) — double
- min_score — double
- max_score — double
- mastery_score — double
- 성적 형식 (미반영 , 포인트 등) (grading_type) — varchar(255)
- submission_types — varchar(255)
- 작업상태 (workflow_state) — varchar(255) — NOT NULL
- context_id — bigint — NOT NULL
- context_type — varchar(255) — NOT NULL
- assignment_group_id — bigint
- grading_standard_id — bigint
- 생성일시 (created_at) — timestamp
- 수정일시 (updated_at) — timestamp
- group_category — varchar(255)
- submissions_downloads — integer
- peer_review_count — integer
- peer_reviews_due_at — timestamp
- peer_reviews_assigned — boolean — NOT NULL
- peer_reviews — boolean — NOT NULL
- automatic_peer_reviews — boolean — NOT NULL
- all_day — boolean — NOT NULL
- all_day_date — date
- could_be_locked — boolean — NOT NULL
- cloned_item_id — bigint
- context_code — varchar(255)
- 위치 (position) — integer
- migration_id — varchar(255)
- grade_group_students_individually — boolean — NOT NULL
- anonymous_peer_reviews — boolean — NOT NULL
- time_zone_edited — varchar(255)
- turnitin_enabled — boolean — NOT NULL
- allowed_extensions — varchar(255)
- turnitin_settings — text
- muted — boolean — NOT NULL
- group_category_id — bigint
- freeze_on_copy — boolean — NOT NULL
- copied — boolean — NOT NULL
- only_visible_to_overrides — boolean — NOT NULL
- post_to_sis — boolean — NOT NULL
- integration_id — varchar(255)
- integration_data — text
- turnitin_id — bigint
- moderated_grading — boolean — NOT NULL
- grades_published_at — timestamp
- omit_from_final_grade — boolean — NOT NULL
- vericite_enabled — boolean — NOT NULL
- intra_group_peer_reviews — boolean — NOT NULL
- lti_context_id — varchar
- anonymous_instructor_annotations — boolean — NOT NULL
- duplicate_of_id — bigint
- anonymous_grading — boolean
- graders_anonymous_to_graders — boolean
- grader_count — integer
- grader_comments_visible_to_graders — boolean
- … +10
과제수행 (캔버스기본) (submissions)
- id — bigserial — 기본 키 — NOT NULL
- body — text
- url — varchar(255)
- attachment_id — bigint
- grade — varchar(255)
- score — double
- 제출일시 (submitted_at) — timestamp
- 과제 아이디 (assignment_id) — bigint — 외래 키 → 과제(캔버스기본).아이디 — NOT NULL
- user_id — bigint — NOT NULL
- submission_type — varchar(255)
- workflow_state — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- group_id — bigint
- attachment_ids — text
- processed — boolean
- grade_matches_current_submission — boolean
- published_score — double
- published_grade — varchar(255)
- graded_at — timestamp
- student_entered_score — double
- grader_id — bigint
- media_comment_id — varchar(255)
- media_comment_type — varchar(255)
- quiz_submission_id — bigint
- submission_comments_count — integer
- attempt — integer
- media_object_id — bigint
- turnitin_data — text
- cached_due_date — timestamp
- excused — boolean
- graded_anonymously — boolean
- late_policy_status — varchar(16)
- points_deducted — numeric(6,2)
- grading_period_id — bigint
- seconds_late_override — bigint
- lti_user_id — varchar
- anonymous_id — varchar(5)
- last_comment_at — timestamp
- extra_attempts — integer
- posted_at — timestamp
- cached_quiz_lti — boolean — NOT NULL
- cached_tardiness — varchar(16)
- course_id — bigint — NOT NULL
- root_account_id — bigint
동영상진도율 (contents_progress)
- 아이디 (id) — bigserial — 기본 키 — NOT NULL
- 영상아이디 (cntnts_id) — bigint
- 과제아이디 (assignment_id) — bigint — 외래 키 → 과제(캔버스기본).아이디 — NOT NULL
- 사용자아이디 (user_id) — bigint
- 과목아이디 (course_id) — bigint
- seconds — integer
- 진도율 (progress_rate_percent) — numeric
- 생성일시 (created_at) — timestamp
- 수정일시 (updated_at) — timestamp
- 삭제일시 (deleted_at) — timestamp
- 작업상태 (workflow_state) — varchar(255)
- current_seconds — integer
모듈 완료 조건 처리(캔버스기본) (context_module_progressions)
- 아이디 (id) — bigserial — 기본 키 — NOT NULL
- 모듈 마스터 아이디 (context_module_id) — bigint — 외래 키 → 모듈마스터.아이디 — NOT NULL
- 사용자 아이디 (user_id) — bigint
- 완료조건 처리 내역 (requirements_met) — text
- workflow_state — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- collapsed — boolean
- current_position — integer
- completed_at — timestamp
- current — boolean
- lock_version — integer — NOT NULL
- evaluated_at — timestamp
- incomplete_requirements — text
- root_account_id — bigint
모듈 출석 (context_module_attendance)
- 아이디 (id) — bigserial — 기본 키 — NOT NULL
- 모듈 마스터 아이디 (context_module_id) — bigint — 외래 키 → 모듈마스터.아이디 — NOT NULL
- 사용자 아이디 (user_id) — bigint
- 과목 아이디 (course_id) — bigint
- 출석율 (attendance_process) — integer
- 출석상태 (attendance_state) — integer
- 작업상태 (workflow_state) — varchar(255)
- 생성일시 (created_at) — timestamp
- 수정일시 (updated_at) — timestamp
- 삭제일시 (deleted_at) — timestamp
모듈마스터 (context_modules)
- 아이디 (id) — 기본 키 — NOT NULL
- context_id — bigint — NOT NULL
- context_type — varchar(255) — NOT NULL
- 이름 (name) — text
- 위치 (position) — integer
- prerequisites — text
- 완료조건 (completion_requirements) — text
- 생싱일시 (created_at) — timestamp
- 수정일시 (updated_at) — timestamp
- 작업상태 (workflow_state) — varchar(255) — NOT NULL
- 삭제일시 (deleted_at) — timestamp
- 열림 일시 (unlock_at) — timestamp
- migration_id — varchar(255)
- require_sequential_progress — boolean
- cloned_item_id — bigint
- completion_events — text
- requirement_count — integer
- root_account_id — bigint
주차교육과정 (week_curriculum)
- 아이디 (id) — 기본 키 — NOT NULL
- 모듈 마스터 아이디 (context_modules_id) — bigint — 외래 키 → 모듈마스터.아이디 — NOT NULL
- 주 번호 (week) — integer
- 정상 출석 기간 일단위 (week_unit) — integer
- 지각 출석 기간 일단위 (late_unit) — integer
- 출석 인정 시작 일시 (attendance_start_at) — timestamp
- 출석 인정 종료 일시 (attendance_end_at) — timestamp
- 지각 출석 시작 일시 (late_due_at) — timestamp
- 생성일시 (created_at) — timestamp
- 수정일시 (updated_at) — timestamp
- 삭제일시 (deleted_at) — timestamp
- 작업상태 (workflow_state) — varchar(255)
콘텐츠 꼬리표 출석 (contents_tag_attendance)
- 아이디 (id) — bigserial — 기본 키 — NOT NULL
- 모듈 출석 아이디 (context_module_attendance_id) — bigint — 외래 키 → 모듈 출석.아이디 — NOT NULL
- 콘텐츠 꼬리표 아이디 (contents_tag_id) — bigint — 외래 키 → 콘텐츠 꼬리표(캔버스기본).id — NOT NULL
- 출석율 (attendance_process) — integer
- 춣석상태 (attendance_state) — integer
- 작업상태 (workflow_state) — varchar(255)
- 생성일시 (created_at) — timestamp
- 수정일시 (updated_at) — timestamp
- 삭제일시 (deleted_at) — timestamp
콘텐츠 꼬리표(캔버스기본) (content_tags)
- id — bigserial — 기본 키 — NOT NULL
- 모듈 마스터 아이디 (context_module_id) — bigint — 외래 키 → 모듈마스터.아이디 — NOT NULL
- 과제 퀴즈 토론 아이디 (content_id) — bigint — 외래 키 → 과제(캔버스기본).아이디 — NOT NULL
- 콘텐츠 형태 (content_type) — varchar(255)
- context_id — bigint — NOT NULL
- context_type — varchar(255) — NOT NULL
- 이름 (title) — text
- tag — varchar(255)
- 링크 또는 파일 url (url) — text
- 생성일시 (created_at) — timestamp
- 수정일시 (updated_at) — timestamp
- comments — text
- tag_type — varchar(255)
- 위치 (position) — integer
- indent — integer
- migration_id — varchar(255)
- learning_outcome_id — bigint
- context_code — varchar(255)
- mastery_score — double
- rubric_association_id — bigint
- 작업상태 (workflow_state) — varchar(255) — NOT NULL
- cloned_item_id — bigint
- associated_asset_id — bigint
- associated_asset_type — varchar(255)
- new_tab — boolean
- 콘텐츠 상세 분류 (link_settings) — jsonb
- root_account_id — bigint
- external_data — jsonb
퀴즈 수행(캔버스기본) (quiz_submissions)
- id — bigserial — 기본 키 — NOT NULL
- 퀴즈 아이디 (quiz_id) — bigint — 외래 키 → 퀴즈(캔버스기본).아이디 — NOT NULL
- quiz_version — integer
- 사용자 아이디 (user_id) — bigint
- submission_data — text
- submission_id — bigint
- score — double
- kept_score — double
- quiz_data — text
- started_at — timestamp
- end_at — timestamp
- 완료 일시 (finished_at) — timestamp
- attempt — integer
- workflow_state — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- fudge_points — double
- quiz_points_possible — double
- extra_attempts — integer
- temporary_user_code — varchar(255)
- extra_time — integer
- manually_unlocked — boolean
- manually_scored — boolean
- validation_token — varchar(255)
- score_before_regrade — double
- was_preview — boolean
- has_seen_results — boolean
- question_references_fixed — boolean
- root_account_id — bigint
퀴즈(캔버스기본) (quizzes)
- 아이디 (id) — bigserial — 기본 키 — NOT NULL
- 제목 (title) — varchar(255)
- 내용 (description) — text
- quiz_data — text
- 획특가능 점수 (points_possible) — double
- context_id — bigint — NOT NULL
- context_type — varchar(255) — NOT NULL
- 과제 아이디 (assignment_id) — bigint — 외래 키 → 과제(캔버스기본).아이디 — NOT NULL
- 작업상태 (workflow_state) — varchar(255) — NOT NULL
- shuffle_answers — boolean — NOT NULL
- show_correct_answers — boolean — NOT NULL
- time_limit — integer
- allowed_attempts — integer
- scoring_policy — varchar(255)
- 퀴즈형식 (평가퀴즈, 평가설문, 미평가퀴즈, 미평가설문) (quiz_type) — varchar(255)
- 생성일시 (created_at) — timestamp
- 수정일시 (updated_at) — timestamp
- 제출 종료일시 (lock_at) — timestamp
- 제술 시작일시 (unlock_at) — timestamp
- 삭제일시 (deleted_at) — timestamp
- could_be_locked — boolean — NOT NULL
- cloned_item_id — bigint
- access_code — varchar(255)
- migration_id — varchar(255)
- unpublished_question_count — integer
- 지연 제출 시작 일시 (due_at) — timestamp
- question_count — integer
- last_assignment_id — bigint
- published_at — timestamp
- last_edited_at — timestamp
- anonymous_submissions — boolean — NOT NULL
- assignment_group_id — bigint
- hide_results — varchar(255)
- ip_filter — varchar(255)
- require_lockdown_browser — boolean — NOT NULL
- require_lockdown_browser_for_results — boolean — NOT NULL
- one_question_at_a_time — boolean — NOT NULL
- cant_go_back — boolean — NOT NULL
- show_correct_answers_at — timestamp
- hide_correct_answers_at — timestamp
- require_lockdown_browser_monitor — boolean — NOT NULL
- lockdown_browser_monitor_data — text
- only_visible_to_overrides — boolean — NOT NULL
- one_time_results — boolean — NOT NULL
- show_correct_answers_last_attempt — boolean — NOT NULL
- root_account_id — bigint
- disable_timer_autosubmission — boolean — NOT NULL
토론(캔버스기본) (discussion_topics)
- 아이디 (id) — bigserial — 기본 키 — NOT NULL
- 제목 (title) — varchar(255)
- message — text
- context_id — bigint — NOT NULL
- context_type — varchar(255) — NOT NULL
- type — varchar(255)
- 사용자 아이디 (user_id) — bigint
- 작업상태 (workflow_state) — varchar(255) — NOT NULL
- last_reply_at — timestamp
- 생성일시 (created_at) — timestamp
- 수정일시 (updated_at) — timestamp
- 제출시작일시 (delayed_post_at) — timestamp
- posted_at — timestamp
- 과제 아이디 (assignment_id) — bigint — 외래 키 → 과제(캔버스기본).아이디 — NOT NULL
- attachment_id — bigint
- 삭제일시 (deleted_at) — timestamp
- root_topic_id — bigint
- could_be_locked — boolean — NOT NULL
- cloned_item_id — bigint
- context_code — varchar(255)
- 위치 (position) — integer
- migration_id — varchar(255)
- old_assignment_id — bigint
- subtopics_refreshed_at — timestamp
- last_assignment_id — bigint
- external_feed_id — bigint
- editor_id — bigint
- podcast_enabled — boolean — NOT NULL
- podcast_has_student_posts — boolean — NOT NULL
- require_initial_post — boolean — NOT NULL
- discussion_type — varchar(255)
- 마감일시 (lock_at) — timestamp
- pinned — boolean — NOT NULL
- locked — boolean — NOT NULL
- group_category_id — bigint
- allow_rating — boolean — NOT NULL
- only_graders_can_rate — boolean — NOT NULL
- sort_by_rating — boolean — NOT NULL
- todo_date — timestamp
- is_section_specific — boolean — NOT NULL
- root_account_id — bigint