edx

Tables (50)

announcements_announcement

  • id — int(11) — Primary key — NOT NULL
  • content — varchar(1000) — NOT NULL
  • active — tinyint(1) — NOT NULL

api_admin_apiaccessconfig

  • id — int(11) — Primary key — NOT NULL
  • change_date — datetime(6) — NOT NULL
  • enabled — tinyint(1) — NOT NULL
  • changed_by_id — int(11) — Foreign key → auth_user.id

api_admin_apiaccessrequest

  • id — int(11) — Primary key — NOT NULL
  • created — datetime(6) — NOT NULL
  • modified — datetime(6) — NOT NULL
  • status — varchar(255) — NOT NULL
  • website — varchar(200) — NOT NULL
  • reason — longtext — NOT NULL
  • user_id — int(11) — Foreign key → auth_user.id — NOT NULL
  • company_address — varchar(255) — NOT NULL
  • company_name — varchar(255) — NOT NULL
  • contacted — tinyint(1) — NOT NULL
  • site_id — int(11) — Foreign key — NOT NULL

assessment_assessment

  • id — int(11) — Primary key — NOT NULL
  • submission_uuid — varchar(128) — NOT NULL
  • scored_at — datetime(6) — NOT NULL
  • scorer_id — varchar(40) — NOT NULL
  • score_type — varchar(2) — NOT NULL
  • feedback — longtext — NOT NULL
  • rubric_id — int(11) — Foreign key → assessment_rubric.id — NOT NULL

assessment_assessmentfeedback

  • id — int(11) — Primary key — NOT NULL
  • submission_uuid — varchar(128) — NOT NULL
  • feedback_text — longtext — NOT NULL

assessment_assessmentfeedback_assessments

  • id — int(11) — Primary key — NOT NULL
  • assessmentfeedback_id — int(11) — Foreign key → assessment_assessmentfeedback.id — NOT NULL
  • assessment_id — int(11) — Foreign key → assessment_assessment.id — NOT NULL

assessment_assessmentfeedback_options

  • id — int(11) — Primary key — NOT NULL
  • assessmentfeedback_id — int(11) — Foreign key → assessment_assessmentfeedback.id — NOT NULL
  • assessmentfeedbackoption_id — int(11) — Foreign key → assessment_assessmentfeedbackoption.id — NOT NULL

assessment_assessmentfeedbackoption

  • id — int(11) — Primary key — NOT NULL
  • text — varchar(255) — NOT NULL

assessment_assessmentpart

  • id — int(11) — Primary key — NOT NULL
  • feedback — longtext — NOT NULL
  • assessment_id — int(11) — Foreign key → assessment_assessment.id — NOT NULL
  • criterion_id — int(11) — Foreign key → assessment_criterion.id — NOT NULL
  • option_id — int(11) — Foreign key → assessment_criterionoption.id

assessment_criterion

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • label — varchar(100) — NOT NULL
  • order_num — int(10) — NOT NULL
  • prompt — longtext — NOT NULL
  • rubric_id — int(11) — Foreign key → assessment_rubric.id — NOT NULL

assessment_criterionoption

  • id — int(11) — Primary key — NOT NULL
  • order_num — int(10) — NOT NULL
  • points — int(10) — NOT NULL
  • name — varchar(100) — NOT NULL
  • label — varchar(100) — NOT NULL
  • explanation — longtext — NOT NULL
  • criterion_id — int(11) — Foreign key → assessment_criterion.id — NOT NULL

assessment_historicalsharedfileupload

  • history_id — int(11) — Primary key — NOT NULL
  • id — int(11) — NOT NULL
  • created — datetime(6) — NOT NULL
  • modified — datetime(6) — NOT NULL
  • team_id — varchar(255) — NOT NULL
  • course_id — varchar(255) — NOT NULL
  • item_id — varchar(255) — NOT NULL
  • owner_id — varchar(255) — NOT NULL
  • file_key — varchar(255) — NOT NULL
  • description — longtext — NOT NULL
  • size — bigint(20) — NOT NULL
  • history_date — datetime(6) — NOT NULL
  • history_change_reason — varchar(100)
  • history_type — varchar(1) — NOT NULL
  • history_user_id — int(11) — Foreign key → auth_user.id
  • name — varchar(255) — NOT NULL

assessment_peerworkflow

  • id — int(11) — Primary key — NOT NULL
  • student_id — varchar(40) — NOT NULL
  • item_id — varchar(128) — NOT NULL
  • course_id — varchar(255) — NOT NULL
  • submission_uuid — varchar(128) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • completed_at — datetime(6)
  • grading_completed_at — datetime(6)
  • cancelled_at — datetime(6)

assessment_peerworkflowitem

  • id — int(11) — Primary key — NOT NULL
  • submission_uuid — varchar(128) — NOT NULL
  • started_at — datetime(6) — NOT NULL
  • scored — tinyint(1) — NOT NULL
  • assessment_id — int(11) — Foreign key → assessment_assessment.id
  • author_id — int(11) — Foreign key → assessment_peerworkflow.id — NOT NULL
  • scorer_id — int(11) — Foreign key → assessment_peerworkflow.id — NOT NULL

assessment_rubric

  • id — int(11) — Primary key — NOT NULL
  • content_hash — varchar(40) — NOT NULL
  • structure_hash — varchar(40) — NOT NULL

assessment_sharedfileupload

  • id — int(11) — Primary key — NOT NULL
  • created — datetime(6) — NOT NULL
  • modified — datetime(6) — NOT NULL
  • team_id — varchar(255) — NOT NULL
  • course_id — varchar(255) — NOT NULL
  • item_id — varchar(255) — NOT NULL
  • owner_id — varchar(255) — NOT NULL
  • file_key — varchar(255) — NOT NULL
  • description — longtext — NOT NULL
  • size — bigint(20) — NOT NULL
  • name — varchar(255) — NOT NULL

assessment_staffworkflow

  • id — int(11) — Primary key — NOT NULL
  • scorer_id — varchar(40) — NOT NULL
  • course_id — varchar(255) — NOT NULL
  • item_id — varchar(128) — NOT NULL
  • submission_uuid — varchar(128) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • grading_completed_at — datetime(6)
  • grading_started_at — datetime(6)
  • cancelled_at — datetime(6)
  • assessment — varchar(128)

assessment_studenttrainingworkflow

  • id — int(11) — Primary key — NOT NULL
  • submission_uuid — varchar(128) — NOT NULL
  • student_id — varchar(40) — NOT NULL
  • item_id — varchar(128) — NOT NULL
  • course_id — varchar(255) — NOT NULL

assessment_studenttrainingworkflowitem

  • id — int(11) — Primary key — NOT NULL
  • order_num — int(10) — NOT NULL
  • started_at — datetime(6) — NOT NULL
  • completed_at — datetime(6)
  • training_example_id — int(11) — Foreign key → assessment_trainingexample.id — NOT NULL
  • workflow_id — int(11) — Foreign key → assessment_studenttrainingworkflow.id — NOT NULL

assessment_teamstaffworkflow

  • staffworkflow_ptr_id — int(11) — Foreign key → assessment_staffworkflow.id — NOT NULL
  • team_submission_uuid — varchar(128) — NOT NULL

assessment_trainingexample

  • id — int(11) — Primary key — NOT NULL
  • raw_answer — longtext — NOT NULL
  • content_hash — varchar(40) — NOT NULL
  • rubric_id — int(11) — Foreign key → assessment_rubric.id — NOT NULL

assessment_trainingexample_options_selected

  • id — int(11) — Primary key — NOT NULL
  • trainingexample_id — int(11) — Foreign key → assessment_trainingexample.id — NOT NULL
  • criterionoption_id — int(11) — Foreign key → assessment_criterionoption.id — NOT NULL

auth_accountrecovery

  • id — int(11) — Primary key — NOT NULL
  • secondary_email — varchar(254) — NOT NULL
  • user_id — int(11) — Foreign key → auth_user.id — NOT NULL
  • is_active — tinyint(1) — NOT NULL

auth_group

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(150) — NOT NULL

auth_group_permissions

  • id — int(11) — Primary key — NOT NULL
  • group_id — int(11) — Foreign key → auth_group.id — NOT NULL
  • permission_id — int(11) — Foreign key → auth_permission.id — NOT NULL

auth_permission

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • content_type_id — int(11) — Foreign key — NOT NULL
  • codename — varchar(100) — NOT NULL

auth_registration

  • id — int(11) — Primary key — NOT NULL
  • activation_key — varchar(32) — NOT NULL
  • user_id — int(11) — Foreign key → auth_user.id — NOT NULL

auth_user

  • id — int(11) — Primary key — NOT NULL
  • password — varchar(128) — NOT NULL
  • last_login — datetime(6)
  • is_superuser — tinyint(1) — NOT NULL
  • username — varchar(150) — NOT NULL
  • first_name — varchar(30) — NOT NULL
  • last_name — varchar(150) — NOT NULL
  • email — varchar(254) — NOT NULL
  • is_staff — tinyint(1) — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • date_joined — datetime(6) — NOT NULL

auth_user_groups

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — Foreign key → auth_user.id — NOT NULL
  • group_id — int(11) — Foreign key → auth_group.id — NOT NULL

auth_user_user_permissions

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — Foreign key → auth_user.id — NOT NULL
  • permission_id — int(11) — Foreign key → auth_permission.id — NOT NULL

auth_userprofile

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • meta — longtext — NOT NULL
  • courseware — varchar(255) — NOT NULL
  • language — varchar(255) — NOT NULL
  • location — varchar(255) — NOT NULL
  • year_of_birth — int(11)
  • gender — varchar(6)
  • level_of_education — varchar(6)
  • mailing_address — longtext
  • city — longtext
  • country — varchar(2)
  • goals — longtext
  • allow_certificate — tinyint(1) — NOT NULL
  • bio — varchar(3000)
  • profile_image_uploaded_at — datetime(6)
  • user_id — int(11) — Foreign key → auth_user.id — NOT NULL
  • phone_number — varchar(50)
  • state — varchar(2)

badges_badgeassertion

  • id — int(11) — Primary key — NOT NULL
  • data — longtext — NOT NULL
  • backend — varchar(50) — NOT NULL
  • image_url — varchar(200) — NOT NULL
  • assertion_url — varchar(200) — NOT NULL
  • modified — datetime(6) — NOT NULL
  • created — datetime(6) — NOT NULL
  • badge_class_id — int(11) — Foreign key → badges_badgeclass.id — NOT NULL
  • user_id — int(11) — Foreign key → auth_user.id — NOT NULL

badges_badgeclass

  • id — int(11) — Primary key — NOT NULL
  • slug — varchar(255) — NOT NULL
  • issuing_component — varchar(50) — NOT NULL
  • display_name — varchar(255) — NOT NULL
  • course_id — varchar(255) — NOT NULL
  • description — longtext — NOT NULL
  • criteria — longtext — NOT NULL
  • mode — varchar(100) — NOT NULL
  • image — varchar(100) — NOT NULL

badges_coursecompleteimageconfiguration

  • id — int(11) — Primary key — NOT NULL
  • mode — varchar(125) — NOT NULL
  • icon — varchar(100) — NOT NULL
  • default — tinyint(1) — NOT NULL

badges_courseeventbadgesconfiguration

  • id — int(11) — Primary key — NOT NULL
  • change_date — datetime(6) — NOT NULL
  • enabled — tinyint(1) — NOT NULL
  • courses_completed — longtext — NOT NULL
  • courses_enrolled — longtext — NOT NULL
  • course_groups — longtext — NOT NULL
  • changed_by_id — int(11) — Foreign key → auth_user.id

block_structure

  • id — int(11) — Primary key — NOT NULL
  • created — datetime(6) — NOT NULL
  • modified — datetime(6) — NOT NULL
  • data_usage_key — varchar(255) — NOT NULL
  • data_version — varchar(255)
  • data_edit_timestamp — datetime(6)
  • transformers_schema_version — varchar(255) — NOT NULL
  • block_structure_schema_version — varchar(255) — NOT NULL
  • data — varchar(500) — NOT NULL

block_structure_config

  • id — int(11) — Primary key — NOT NULL
  • change_date — datetime(6) — NOT NULL
  • enabled — tinyint(1) — NOT NULL
  • num_versions_to_keep — int(11)
  • cache_timeout_in_seconds — int(11)
  • changed_by_id — int(11) — Foreign key → auth_user.id

bookmarks_bookmark

  • id — int(11) — Primary key — NOT NULL
  • created — datetime(6) — NOT NULL
  • modified — datetime(6) — NOT NULL
  • course_key — varchar(255) — NOT NULL
  • usage_key — varchar(255) — NOT NULL
  • path — longtext — NOT NULL
  • user_id — int(11) — Foreign key → auth_user.id — NOT NULL
  • xblock_cache_id — int(11) — Foreign key → bookmarks_xblockcache.id — NOT NULL

bookmarks_xblockcache

  • id — int(11) — Primary key — NOT NULL
  • created — datetime(6) — NOT NULL
  • modified — datetime(6) — NOT NULL
  • course_key — varchar(255) — NOT NULL
  • usage_key — varchar(255) — NOT NULL
  • display_name — varchar(255) — NOT NULL
  • paths — longtext — NOT NULL

branding_brandingapiconfig

  • id — int(11) — Primary key — NOT NULL
  • change_date — datetime(6) — NOT NULL
  • enabled — tinyint(1) — NOT NULL
  • changed_by_id — int(11) — Foreign key → auth_user.id

branding_brandinginfoconfig

  • id — int(11) — Primary key — NOT NULL
  • change_date — datetime(6) — NOT NULL
  • enabled — tinyint(1) — NOT NULL
  • configuration — longtext — NOT NULL
  • changed_by_id — int(11) — Foreign key → auth_user.id

bulk_email_bulkemailflag

  • id — int(11) — Primary key — NOT NULL
  • change_date — datetime(6) — NOT NULL
  • enabled — tinyint(1) — NOT NULL
  • require_course_email_auth — tinyint(1) — NOT NULL
  • changed_by_id — int(11) — Foreign key → auth_user.id

bulk_email_cohorttarget

  • target_ptr_id — int(11) — Foreign key → bulk_email_target.id — NOT NULL
  • cohort_id — int(11) — Foreign key — NOT NULL

bulk_email_courseauthorization

  • id — int(11) — Primary key — NOT NULL
  • course_id — varchar(255) — NOT NULL
  • email_enabled — tinyint(1) — NOT NULL

bulk_email_courseemail

  • id — int(11) — Primary key — NOT NULL
  • slug — varchar(128) — NOT NULL
  • subject — varchar(128) — NOT NULL
  • html_message — longtext
  • text_message — longtext
  • created — datetime(6) — NOT NULL
  • modified — datetime(6) — NOT NULL
  • course_id — varchar(255) — NOT NULL
  • to_option — varchar(64) — NOT NULL
  • template_name — varchar(255)
  • from_addr — varchar(255)
  • sender_id — int(11) — Foreign key → auth_user.id

bulk_email_courseemail_targets

  • id — int(11) — Primary key — NOT NULL
  • courseemail_id — int(11) — Foreign key → bulk_email_courseemail.id — NOT NULL
  • target_id — int(11) — Foreign key → bulk_email_target.id — NOT NULL

bulk_email_courseemailtemplate

  • id — int(11) — Primary key — NOT NULL
  • html_template — longtext
  • plain_template — longtext
  • name — varchar(255)

bulk_email_coursemodetarget

  • target_ptr_id — int(11) — Foreign key → bulk_email_target.id — NOT NULL
  • track_id — int(11) — Foreign key — NOT NULL

bulk_email_optout

  • id — int(11) — Primary key — NOT NULL
  • course_id — varchar(255) — NOT NULL
  • user_id — int(11) — Foreign key → auth_user.id

bulk_email_target

  • id — int(11) — Primary key — NOT NULL
  • target_type — varchar(64) — NOT NULL