icon

Welcome to Schema Evolution Toolsuite

Database: ham_atutor

Here a description of the program and the functions provided, a brief explanation and escription of the different sections like in the prism layout

  • Table name: contains the name of the table
  • Column count evolution:report the evolution in terms of number of columns of the table; the columns are calculated as difference between the number of columns in the first and in the last revision
  • Columns data tyep changes: report the number of changes in the data type of each column; show the name of the column that changed type and the evolution of the type
  • Primary key changes: count the number of times the primary key of the table changed, in terms of columns added or deleted
  • Number roll back: number of roll back undergone by the table
Db first release 2003-11-26
Db latest release 2009-05-28
Db initial size 26
Db end size 98
Db evolution rate
6%
 
 
Table Name Colomns evolution Colomns data type changes Number of roll back Primary key changes Foreign key changes Index changes Table evolution rate Table Name
content 6 Details...hide/show 0 0 0 0
4%
 
 
content
courses 47 Details...hide/show 0 0 0 0
24%
 
 
courses
course_cats 25 Details...hide/show 0 0 0 0
13%
 
 
course_cats
course_enrollment 12 Details...hide/show 0 0 0 0
6%
 
 
course_enrollment
course_stats 8 0 0 0 0
4%
 
 
course_stats
forums_accessed 8 0 0 0 0
4%
 
 
forums_accessed
forums_subscriptions 4 0 0 0 0
2%
 
 
forums_subscriptions
forums_threads 13 Details...hide/show 0 0 0 0
7%
 
 
forums_threads
glossary 16 0 0 0 0
8%
 
 
glossary
g_click_data 10 0 0 0 0
5%
 
 
g_click_data
g_refs 9 0 0 0 0
4%
 
 
g_refs
instructor_approvals 5 Details...hide/show 0 0 0 0
3%
 
 
instructor_approvals
lang2 8 0 0 0 0
4%
 
 
lang2
lang_base_pages 4 0 0 0 0
2%
 
 
lang_base_pages
learning_concepts 5 0 0 0 0
2%
 
 
learning_concepts
members 29 Details...hide/show 1 0 0 0
24%
 
 
members
news 28 Details...hide/show 0 0 0 0
14%
 
 
news
preferences 6 0 0 0 0
3%
 
 
preferences
related_content 5 0 0 0 0
2%
 
 
related_content
resource_categories 6 0 0 0 0
3%
 
 
resource_categories
resource_links 12 0 0 0 0
6%
 
 
resource_links
tests 36 Details...hide/show 0 0 0 0
18%
 
 
tests
tests_answers 30 0 0 0 0
15%
 
 
tests_answers
tests_questions 54 Details...hide/show 1 0 0 0
39%
 
 
tests_questions
tests_results 46 Details...hide/show 0 0 0 0
23%
 
 
tests_results
theme_settings 11 0 0 0 0
6%
 
 
theme_settings
forums 12 Details...hide/show 0 0 0 0
6%
 
 
forums
messages 20 Details...hide/show 0 0 0 0
10%
 
 
messages
polls 26 Details...hide/show 0 0 0 0
15%
 
 
polls
polls_members 19 0 0 0 0
10%
 
 
polls_members
languages 13 0 0 0 0
6%
 
 
languages
language_pages 9 0 0 0 0
4%
 
 
language_pages
backups 14 Details...hide/show 1 0 0 0
16%
 
 
backups
themes 14 Details...hide/show 0 0 0 0
7%
 
 
themes
forums_courses 8 0 0 0 0
4%
 
 
forums_courses
tests_questions_assoc 7 Details...hide/show 0 0 0 0
4%
 
 
tests_questions_assoc
tests_questions_categories 8 0 0 0 0
4%
 
 
tests_questions_categories
groups 6 0 0 0 0
3%
 
 
groups
groups_members 5 0 0 0 0
2%
 
 
groups_members
tests_groups 2 0 0 0 0
1%
 
 
tests_groups
forums_thread_subscriptions 4 0 0 0 0
2%
 
 
forums_thread_subscriptions
member_track 6 Details...hide/show 0 0 0 0
3%
 
 
member_track
admins 13 Details...hide/show 0 0 0 0
7%
 
 
admins
admin_log 11 Details...hide/show 0 0 0 0
6%
 
 
admin_log
users_online 8 0 0 0 0
4%
 
 
users_online
master_list 5 0 0 0 0
2%
 
 
master_list
cmi 6 0 0 0 0
3%
 
 
cmi
packages 10 0 0 0 0
5%
 
 
packages
scorm_1_2_item 16 0 0 0 0
8%
 
 
scorm_1_2_item
scorm_1_2_org 12 0 0 0 0
6%
 
 
scorm_1_2_org
handbook_notes 12 Details...hide/show 0 0 0 0
6%
 
 
handbook_notes
modules 19 Details...hide/show 3 0 0 0
34%
 
 
modules
config 8 Details...hide/show 0 0 0 0
4%
 
 
config
faq_entries 8 Details...hide/show 0 0 0 0
4%
 
 
faq_entries
faq_topics 7 Details...hide/show 0 0 0 0
4%
 
 
faq_topics
feeds 5 0 0 0 0
2%
 
 
feeds
external_resources 10 Details...hide/show 0 0 0 0
6%
 
 
external_resources
reading_list 13 0 0 0 0
6%
 
 
reading_list
forums_groups 9 0 0 0 0
4%
 
 
forums_groups
groups_types 5 Details...hide/show 0 0 0 0
3%
 
 
groups_types
files 17 Details...hide/show 0 0 0 0
9%
 
 
files
files_comments 11 Details...hide/show 0 0 0 0
6%
 
 
files_comments
folders 10 0 0 0 0
5%
 
 
folders
file_storage_groups 6 0 0 0 0
3%
 
 
file_storage_groups
assignments 8 0 0 0 0
4%
 
 
assignments
mail_queue 15 Details...hide/show 0 0 0 0
8%
 
 
mail_queue
blog_posts 15 Details...hide/show 0 0 0 0
8%
 
 
blog_posts
links 19 Details...hide/show 0 0 0 0
10%
 
 
links
links_categories 13 Details...hide/show 0 0 0 0
7%
 
 
links_categories
blog_posts_comments 11 Details...hide/show 0 0 0 0
6%
 
 
blog_posts_comments
AT_tests_questions 0 0 0 0 0
0%
 
 
AT_tests_questions
course_access 85 0 0 0 0
42%
 
 
course_access
messages_sent 9 Details...hide/show 0 0 0 0
5%
 
 
messages_sent
auto_enroll 10 0 0 0 0
5%
 
 
auto_enroll
auto_enroll_courses 4 0 0 0 0
2%
 
 
auto_enroll_courses
myown_patches 10 0 0 0 0
5%
 
 
myown_patches
myown_patches_dependent 8 0 0 0 0
4%
 
 
myown_patches_dependent
myown_patches_files 9 0 0 0 0
4%
 
 
myown_patches_files
patches 21 0 0 0 0
10%
 
 
patches
patches_files 16 0 0 0 0
8%
 
 
patches_files
patches_files_actions 6 0 0 0 0
3%
 
 
patches_files_actions
primary_resources 9 0 0 0 0
4%
 
 
primary_resources
primary_resources_types 4 0 0 0 0
2%
 
 
primary_resources_types
resource_types 2 0 0 0 0
1%
 
 
resource_types
secondary_resources 6 0 0 0 0
3%
 
 
secondary_resources
secondary_resources_types 4 0 0 0 0
2%
 
 
secondary_resources_types
content_tests_assoc 4 0 0 0 0
2%
 
 
content_tests_assoc
gradebook_detail 5 0 0 0 0
2%
 
 
gradebook_detail
gradebook_tests 8 0 0 0 0
4%
 
 
gradebook_tests
grade_scales 9 0 0 0 0
4%
 
 
grade_scales
grade_scales_detail 6 0 0 0 0
3%
 
 
grade_scales_detail
guests 10 0 0 0 0
5%
 
 
guests
fha_student_tools 8 0 0 0 0
4%
 
 
fha_student_tools
social_activities 0 0 0 0 0
0%
 
 
social_activities
social_applications 0 0 0 0 0
0%
 
 
social_applications
social_application_settings 0 0 0 0 0
0%
 
 
social_application_settings
social_friends 0 0 0 0 0
0%
 
 
social_friends
social_friend_requests 0 0 0 0 0
0%
 
 
social_friend_requests
social_groups 0 0 0 0 0
0%
 
 
social_groups
social_groups_activities 0 0 0 0 0
0%
 
 
social_groups_activities
social_groups_board 0 0 0 0 0
0%
 
 
social_groups_board
social_groups_invitations 0 0 0 0 0
0%
 
 
social_groups_invitations
social_groups_members 0 0 0 0 0
0%
 
 
social_groups_members
social_groups_requests 0 0 0 0 0
0%
 
 
social_groups_requests
social_groups_types 0 0 0 0 0
0%
 
 
social_groups_types
social_members_applications 0 0 0 0 0
0%
 
 
social_members_applications
social_member_additional_information 0 0 0 0 0
0%
 
 
social_member_additional_information
social_member_education 0 0 0 0 0
0%
 
 
social_member_education
social_member_position 0 0 0 0 0
0%
 
 
social_member_position
social_member_track 0 0 0 0 0
0%
 
 
social_member_track
social_member_websites 0 0 0 0 0
0%
 
 
social_member_websites
social_privacy_preferences 0 0 0 0 0
0%
 
 
social_privacy_preferences
social_user_settings 0 0 0 0 0
0%
 
 
social_user_settings