Documentation on Database Tables

Expertiza partial database diagram

1. PROJECT TITLE: Regularize Expertiza DB schema
2. PROBLEM DESCRIPTION:

 
The current Expertiza database has some problems which needs to be rectified.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

1. DATABASE TABLE DESCRIPTION: Below is the detailed description of the tables in the Expertiza DB schema

1. Assignments

   assignments

   assignment_questionnaires

   deadline_types

   deadline_rights

   due_dates

   late_policies

   participants

   wiki_types

   Deprecated Tables

   assignments_questionnaires

2. Goldberg

   content_pages

   controller_actions

   markup_styles

   menu_items

   permissions

   plugin_schema_info

   roles

   roles_permissions

   schema_info

   site_controllers

   users

   system_settings

3. Reviewing

   comments

   mapping_strategies

   responses

   response_maps

   review_strategies

   score_caches

   scores

   Deprecated Tables

   review_feedbacks

   review_mappings

   review_of_review_mappings

   review_of_reviews

   reviews

   teammate_reviews

4. Teammate

   invitations

   teams

   teams_users

5. Courses

   courses

6. Hierarchy

   institutions

   languages

7. Display

   nodes

   tree_folders

8. Questionnaires/Rubrics

   question_advices

   questionnaires

   questions

   Deprecated Tables

   questionnaire_types

9. Surveys

   survey_deployments

   survey_participants

   survey_responses

10. Other Features

    signed_up_users

    sign_up_topics

    resubmission_times

    ta_mappings

Back to Expertiza_documentation Main page.