강의실 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