Documentation on Database Tables
PROJECT TITLE: Regularize Expertiza DB schema
PROBLEM DESCRIPTION:
The current Expertiza database has some problems which needs to be rectified.
The current Expertiza database has issues similar to what is described below:
1. redundant record. For instance, deadline_types table has two signup and team_formation record.
2. some field name is confused. For instance, in users table assignment_id becomes parent_id and in response_maps_assignment_id becomes reviewed_object_id.
The scope of our project is to rectify these problems by performing the below steps.
1. Go through the Expertiza_development database to find tables that not used any more or redundant records.
2. Write migrations to regularize the Expertiza database and also change code if necessary.
3. Make sure all existing tests are passed and change test code if necessary
4. Modify database wiki page to make it up to date
DATABASE TABLE DESCRIPTION:
Below is the detailed description of the tables in the Expertiza DB schema
- Assignments
- Goldberg
- Reviewing
- Teammate
- Courses
- Hierarchy
- Display
- Questionnaires/Rubrics
- question_advices
- questionnaires
- questions
- Deprecated Tables
- Surveys
- Other Features
Back to Expertiza_documentation Main page.