Documentation on Database Tables: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
<!--This page is under construction -->
<!--This page is under construction -->
[[Image:pg_development.png|thumb|right|200px|Expertiza partial database diagram]]
[[Image:pg_development.png|thumb|right|200px|Expertiza partial database diagram]]
# '''PROJECT TITLE: Regularize Expertiza DB schema'''
'''PROJECT TITLE: Regularize Expertiza DB schema'''
# <b>PROBLEM DESCRIPTION:</b>
<b>PROBLEM DESCRIPTION:</b>
   <br>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.
   <br>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.
   <br> 1. Go through the Expertiza_development database to find tables that not used any more or redundant records.
   <br> 1. Go through the Expertiza_development database to find tables that not used any more or redundant records.
Line 9: Line 9:
   <br> 4. Modify database wiki page to make it up to date
   <br> 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'''
'''DATABASE TABLE DESCRIPTION:'''




Revision as of 20:01, 8 April 2018

Expertiza partial database diagram

PROJECT TITLE: Regularize Expertiza DB schema 

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

DATABASE TABLE DESCRIPTION:


  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.

Retrieved from "https://wiki.expertiza.ncsu.edu/index.php?title=Documentation_on_Database_Tables&oldid=116286"