Re: [edx-code] require edx platform database schema/er

[James Tauber]

You can likely extract an ER diagram from the Django models in the various Django apps and that might be a fun activity for someone such as yourself to undertake. Course content itself makes use of either XML or MongoDB so SQL or and ER diagram might not make sense but there is documentation in the docs directory that explains some of that.

We want to improve (and update) the documentation covering the high level architecture and data models but let us know if you hit any specific questions with regard to the data models.

James

On Sat, Jun 1, 2013 at 1:55 AM, Zeel Shah <ksha...@gmail.com> wrote:

Hello Sir,

I am student of India and I need your help. I want database schema of edx platform. Is it possible that you can share sql file or er diagram of platform. As EdX platform is opensource under AGPL license, is it available in your git repository? I just want to reuse it. 

Thank you,

Zeel Shah.

[Sef Kloninger]

For student data, use the models.

> find . -name models.py | xargs wc -l

      33 ./common/djangoapps/course_groups/models.py

      74 ./common/djangoapps/django_comment_common/models.py

      31 ./common/djangoapps/external_auth/models.py

     779 ./common/djangoapps/student/models.py

      21 ./common/djangoapps/track/models.py

       3 ./common/djangoapps/util/models.py

     141 ./lms/djangoapps/certificates/models.py

      13 ./lms/djangoapps/circuit/models.py

     264 ./lms/djangoapps/courseware/models.py

       3 ./lms/djangoapps/dashboard/models.py

       3 ./lms/djangoapps/debug/models.py

       1 ./lms/djangoapps/django_comment_client/models.py

     136 ./lms/djangoapps/foldit/models.py

      81 ./lms/djangoapps/licenses/models.py

      81 ./lms/djangoapps/notes/models.py

      45 ./lms/djangoapps/psychometrics/models.py

     386 ./lms/djangoapps/simplewiki/models.py

       3 ./lms/djangoapps/static_template_view/models.py

       3 ./lms/djangoapps/staticbook/models.py

     131 ./lms/lib/comment_client/models.py

       3 ./lms/lib/perfstats/models.py

    2235 total

Note that there are two other data stores, both MongoDB: the course information, maintained by the CMS, and the forum content, maintained but he comments service.  Those are schemaless of course.

- Sef

[Jay Zoldak]

Zeel --

Check out data.edx.org.

Specifically you might find this link of interest: http://data.edx.org/internal_data_formats/sql_schema.html

JZ