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