6. Data Reference

The following sections provide reference information about the data stored in SQL and NoSQL databases that is provided as part of the edX data package.

• 6.1. Email Opt-in Report
  • 6.1.1. user_id
  • 6.1.2. username
  • 6.1.3. email
  • 6.1.4. full_name
  • 6.1.5. course_id
  • 6.1.6. is_opted_in_for_email
  • 6.1.7. preference_set_datetime
• 6.2. Course Content Data
  • 6.2.1. Shared Fields
  • 6.2.2. Course Data
  • 6.2.3. Course Building Block Data
  • 6.2.4. Course Component Data
• 6.3. User Info and Learner Progress Data
  • 6.3.1. Conventions
  • 6.3.2. MySQL Terminology
  • 6.3.3. User Data
  • 6.3.4. Courseware Progress Data
  • 6.3.5. Course Grades Data
  • 6.3.6. Course Certificate Data
  • 6.3.7. Credit Eligibility Data
  • 6.3.8. Cohort Membership Data
• 6.4. Discussion Forums Data
  • 6.4.1. Data File and Object Overview
  • 6.4.2. Samples
  • 6.4.3. Shared Fields
  • 6.4.4. CommentThread Fields
  • 6.4.5. Comment Fields
• 6.5. Wiki Data
  • 6.5.1. Fields in the wiki_article File
  • 6.5.2. Fields in the wiki_articlerevision File
• 6.6. Open Response Assessment Data
  • 6.6.1. Workflow Tables
  • 6.6.2. Assessment and Rubric Tables
  • 6.6.3. Submission, StudentItem, and Score Tables
  • 6.6.4. Detailed ERD
• 6.7. Events in the Tracking Logs
  • 6.7.1. Reviewing a Sample Event
  • 6.7.2. Common Fields
  • 6.7.3. Student Events
  • 6.7.4. Course Team Events
• 6.8. Alphabetical Event List
  • 6.8.1. A, B, C
  • 6.8.2. D, E, F
  • 6.8.3. G, H, I
  • 6.8.4. J, K, L
  • 6.8.5. M, N, O
  • 6.8.6. P, Q, R
  • 6.8.7. S, T
  • 6.8.8. U, V, W, X, Y, Z