icon

Welcome to Schema Evolution Toolsuite

Database: ham_ktdms

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 2005-06-13
Db latest release 2009-01-08
Db initial size 99
Db end size 0
Db evolution rate
2%
 
 
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
active_sessions 0 0 0 0 0
0%
 
 
active_sessions
archive_restoration_request 8 0 0 0 0
4%
 
 
archive_restoration_request
archiving_settings 8 0 0 0 0
4%
 
 
archiving_settings
archiving_type_lookup 5 0 0 0 0
2%
 
 
archiving_type_lookup
browse_criteria 3 0 0 0 0
2%
 
 
browse_criteria
data_types 3 0 0 0 0
2%
 
 
data_types
dependant_document_instance 5 0 0 0 0
2%
 
 
dependant_document_instance
dependant_document_template 4 0 0 0 0
2%
 
 
dependant_document_template
discussion_comments 10 Details...hide/show 0 0 0 0
5%
 
 
discussion_comments
discussion_threads 15 Details...hide/show 0 0 0 0
8%
 
 
discussion_threads
documents 47 Details...hide/show 0 0 0 0
24%
 
 
documents
document_archiving_link 22 0 0 0 0
11%
 
 
document_archiving_link
document_fields 10 Details...hide/show 0 0 0 0
6%
 
 
document_fields
document_fields_link 13 0 0 0 0
6%
 
 
document_fields_link
document_link 6 0 0 0 0
3%
 
 
document_link
document_link_types 6 0 0 0 0
3%
 
 
document_link_types
document_subscriptions 6 0 0 0 0
3%
 
 
document_subscriptions
document_text 4 Details...hide/show 0 0 0 0
2%
 
 
document_text
document_transactions 13 0 0 0 0
6%
 
 
document_transactions
document_transaction_types_lookup 12 Details...hide/show 0 0 0 0
6%
 
 
document_transaction_types_lookup
document_types_lookup 2 Details...hide/show 0 0 0 0
1%
 
 
document_types_lookup
document_type_fields_link 5 0 0 0 0
2%
 
 
document_type_fields_link
folders 20 Details...hide/show 0 0 0 0
10%
 
 
folders
folders_users_roles_link 18 0 0 0 0
9%
 
 
folders_users_roles_link
folder_doctypes_link 9 0 0 0 0
4%
 
 
folder_doctypes_link
folder_subscriptions 3 0 0 0 0
2%
 
 
folder_subscriptions
groups_folders_approval_link 4 0 0 0 0
2%
 
 
groups_folders_approval_link
groups_folders_link 5 0 0 0 0
2%
 
 
groups_folders_link
groups_lookup 11 Details...hide/show 0 0 0 0
6%
 
 
groups_lookup
groups_units_link 7 0 0 0 0
4%
 
 
groups_units_link
help 4 Details...hide/show 0 0 0 0
2%
 
 
help
links 5 0 0 0 0
2%
 
 
links
metadata_lookup 6 0 0 0 0
3%
 
 
metadata_lookup
mime_types 9 0 0 0 0
4%
 
 
mime_types
news 15 Details...hide/show 0 0 0 0
8%
 
 
news
organisations_lookup 8 0 0 0 0
4%
 
 
organisations_lookup
roles 6 0 0 0 0
3%
 
 
roles
search_document_user_link 4 0 0 0 0
2%
 
 
search_document_user_link
status_lookup 4 0 0 0 0
2%
 
 
status_lookup
system_settings 1 Details...hide/show 0 0 0 0
1%
 
 
system_settings
time_period 4 0 0 0 0
2%
 
 
time_period
time_unit_lookup 3 0 0 0 0
2%
 
 
time_unit_lookup
units_lookup 1 0 0 0 0
0%
 
 
units_lookup
units_organisations_link 4 0 0 0 0
2%
 
 
units_organisations_link
upgrades 7 0 0 0 0
4%
 
 
upgrades
users 31 Details...hide/show 0 0 0 0
17%
 
 
users
users_groups_link 24 0 0 0 0
12%
 
 
users_groups_link
web_documents 7 0 0 0 0
4%
 
 
web_documents
web_documents_status_lookup 6 0 0 0 0
3%
 
 
web_documents_status_lookup
web_sites 4 0 0 0 0
2%
 
 
web_sites
zseq_active_sessions 3 0 0 0 0
2%
 
 
zseq_active_sessions
zseq_archive_restoration_request 0 0 0 0 0
0%
 
 
zseq_archive_restoration_request
zseq_archiving_settings 0 0 0 0 0
0%
 
 
zseq_archiving_settings
zseq_archiving_type_lookup 0 0 0 0 0
0%
 
 
zseq_archiving_type_lookup
zseq_browse_criteria 0 0 0 0 0
0%
 
 
zseq_browse_criteria
zseq_data_types 0 0 0 0 0
0%
 
 
zseq_data_types
zseq_dependant_document_instance 0 0 0 0 0
0%
 
 
zseq_dependant_document_instance
zseq_dependant_document_template 0 0 0 0 0
0%
 
 
zseq_dependant_document_template
zseq_discussion_comments 0 0 0 0 0
0%
 
 
zseq_discussion_comments
zseq_discussion_threads 0 0 0 0 0
0%
 
 
zseq_discussion_threads
zseq_documents 0 0 0 0 0
0%
 
 
zseq_documents
zseq_document_archiving_link 0 0 0 0 0
0%
 
 
zseq_document_archiving_link
zseq_document_fields 0 0 0 0 0
0%
 
 
zseq_document_fields
zseq_document_fields_link 0 0 0 0 0
0%
 
 
zseq_document_fields_link
zseq_document_link 0 0 0 0 0
0%
 
 
zseq_document_link
zseq_document_link_types 0 0 0 0 0
0%
 
 
zseq_document_link_types
zseq_document_subscriptions 0 0 0 0 0
0%
 
 
zseq_document_subscriptions
zseq_document_transactions 0 0 0 0 0
0%
 
 
zseq_document_transactions
zseq_document_transaction_types_lookup 0 0 0 0 0
0%
 
 
zseq_document_transaction_types_lookup
zseq_document_types_lookup 0 0 0 0 0
0%
 
 
zseq_document_types_lookup
zseq_document_type_fields_link 0 0 0 0 0
0%
 
 
zseq_document_type_fields_link
zseq_folders 0 0 0 0 0
0%
 
 
zseq_folders
zseq_folders_users_roles_link 0 0 0 0 0
0%
 
 
zseq_folders_users_roles_link
zseq_folder_doctypes_link 0 0 0 0 0
0%
 
 
zseq_folder_doctypes_link
zseq_folder_subscriptions 0 0 0 0 0
0%
 
 
zseq_folder_subscriptions
zseq_groups_folders_approval_link 0 0 0 0 0
0%
 
 
zseq_groups_folders_approval_link
zseq_groups_folders_link 0 0 0 0 0
0%
 
 
zseq_groups_folders_link
zseq_groups_lookup 0 0 0 0 0
0%
 
 
zseq_groups_lookup
zseq_groups_units_link 0 0 0 0 0
0%
 
 
zseq_groups_units_link
zseq_help 0 0 0 0 0
0%
 
 
zseq_help
zseq_links 0 0 0 0 0
0%
 
 
zseq_links
zseq_metadata_lookup 0 0 0 0 0
0%
 
 
zseq_metadata_lookup
zseq_mime_types 0 0 0 0 0
0%
 
 
zseq_mime_types
zseq_news 0 0 0 0 0
0%
 
 
zseq_news
zseq_organisations_lookup 0 0 0 0 0
0%
 
 
zseq_organisations_lookup
zseq_roles 0 0 0 0 0
0%
 
 
zseq_roles
zseq_search_document_user_link 0 0 0 0 0
0%
 
 
zseq_search_document_user_link
zseq_status_lookup 0 0 0 0 0
0%
 
 
zseq_status_lookup
zseq_system_settings 0 0 0 0 0
0%
 
 
zseq_system_settings
zseq_time_period 0 0 0 0 0
0%
 
 
zseq_time_period
zseq_time_unit_lookup 0 0 0 0 0
0%
 
 
zseq_time_unit_lookup
zseq_units_lookup 0 0 0 0 0
0%
 
 
zseq_units_lookup
zseq_units_organisations_link 0 0 0 0 0
0%
 
 
zseq_units_organisations_link
zseq_upgrades 0 0 0 0 0
0%
 
 
zseq_upgrades
zseq_users 0 0 0 0 0
0%
 
 
zseq_users
zseq_users_groups_link 0 0 0 0 0
0%
 
 
zseq_users_groups_link
zseq_web_documents 0 0 0 0 0
0%
 
 
zseq_web_documents
zseq_web_documents_status_lookup 0 0 0 0 0
0%
 
 
zseq_web_documents_status_lookup
zseq_web_sites 0 0 0 0 0
0%
 
 
zseq_web_sites
groups_groups_link 2 0 0 0 0
1%
 
 
groups_groups_link
help_replacement 7 Details...hide/show 1 0 0 0
12%
 
 
help_replacement
permissions 4 0 0 0 0
2%
 
 
permissions
permission_assignments 6 0 0 0 0
3%
 
 
permission_assignments
permission_descriptors 5 Details...hide/show 0 0 0 0
3%
 
 
permission_descriptors
permission_descriptor_groups 5 0 0 0 0
2%
 
 
permission_descriptor_groups
permission_lookups 3 0 0 0 0
2%
 
 
permission_lookups
permission_lookup_assignments 3 0 0 0 0
2%
 
 
permission_lookup_assignments
permission_objects 3 0 0 0 0
2%
 
 
permission_objects
zseq_groups_groups_link 0 0 0 0 0
0%
 
 
zseq_groups_groups_link
zseq_help_replacement 0 0 0 0 0
0%
 
 
zseq_help_replacement
zseq_permissions 0 0 0 0 0
0%
 
 
zseq_permissions
zseq_permission_assignments 0 0 0 0 0
0%
 
 
zseq_permission_assignments
zseq_permission_descriptors 0 0 0 0 0
0%
 
 
zseq_permission_descriptors
zseq_permission_lookups 0 0 0 0 0
0%
 
 
zseq_permission_lookups
zseq_permission_lookup_assignments 0 0 0 0 0
0%
 
 
zseq_permission_lookup_assignments
zseq_permission_objects 0 0 0 0 0
0%
 
 
zseq_permission_objects
document_incomplete 2 0 0 0 0
1%
 
 
document_incomplete
document_fieldsets 5 0 0 0 0
2%
 
 
document_fieldsets
document_type_fieldsets_link 11 0 0 0 0
6%
 
 
document_type_fieldsets_link
metadata_lookup_condition 3 0 0 0 0
2%
 
 
metadata_lookup_condition
metadata_lookup_condition_chain 4 0 0 0 0
2%
 
 
metadata_lookup_condition_chain
metadata_lookup_tree 4 0 0 0 0
2%
 
 
metadata_lookup_tree
zseq_document_fieldsets 0 0 0 0 0
0%
 
 
zseq_document_fieldsets
zseq_metadata_lookup_condition 3 0 0 0 0
2%
 
 
zseq_metadata_lookup_condition
zseq_metadata_lookup_condition_chain 0 0 0 0 0
0%
 
 
zseq_metadata_lookup_condition_chain
zseq_metadata_lookup_tree 0 0 0 0 0
0%
 
 
zseq_metadata_lookup_tree
fieldsets 10 Details...hide/show 0 0 0 0
6%
 
 
fieldsets
field_behaviours 11 0 0 0 0
6%
 
 
field_behaviours
field_behaviour_options 5 0 0 0 0
2%
 
 
field_behaviour_options
field_orders 6 0 0 0 0
3%
 
 
field_orders
field_value_instances 7 0 0 0 0
4%
 
 
field_value_instances
workflows 7 0 0 0 0
4%
 
 
workflows
workflow_actions 7 0 0 0 0
4%
 
 
workflow_actions
workflow_documents 3 0 0 0 0
2%
 
 
workflow_documents
workflow_states 8 0 0 0 0
4%
 
 
workflow_states
workflow_state_actions 9 0 0 0 0
4%
 
 
workflow_state_actions
workflow_state_transitions 2 0 0 0 0
1%
 
 
workflow_state_transitions
workflow_transitions 11 0 0 0 0
6%
 
 
workflow_transitions
zseq_document_type_fieldsets_link 8 0 0 0 0
4%
 
 
zseq_document_type_fieldsets_link
zseq_fieldsets 0 0 0 0 0
0%
 
 
zseq_fieldsets
zseq_field_behaviours 0 0 0 0 0
0%
 
 
zseq_field_behaviours
zseq_field_value_instances 0 0 0 0 0
0%
 
 
zseq_field_value_instances
zseq_workflows 0 0 0 0 0
0%
 
 
zseq_workflows
zseq_workflow_states 0 0 0 0 0
0%
 
 
zseq_workflow_states
zseq_workflow_transitions 0 0 0 0 0
0%
 
 
zseq_workflow_transitions
document_searchable_text 3 Details...hide/show 0 0 0 0
2%
 
 
document_searchable_text
document_transaction_text 0 0 0 0 0
0%
 
 
document_transaction_text
permission_descriptor_roles 4 0 0 0 0
2%
 
 
permission_descriptor_roles
permission_descriptor_users 2 0 0 0 0
1%
 
 
permission_descriptor_users
permission_dynamic_assignments 4 0 0 0 0
2%
 
 
permission_dynamic_assignments
permission_dynamic_conditions 6 0 0 0 0
3%
 
 
permission_dynamic_conditions
saved_searches 9 Details...hide/show 0 0 0 0
5%
 
 
saved_searches
zseq_permission_dynamic_conditions 6 0 0 0 0
3%
 
 
zseq_permission_dynamic_conditions
zseq_saved_searches 0 0 0 0 0
0%
 
 
zseq_saved_searches
notifications 9 0 0 0 0
4%
 
 
notifications
zseq_notifications 9 0 0 0 0
4%
 
 
zseq_notifications
authentication_sources 6 Details...hide/show 0 0 0 0
3%
 
 
authentication_sources
zseq_authentication_sources 6 0 0 0 0
3%
 
 
zseq_authentication_sources
dashlet_disables 2 0 0 0 0
1%
 
 
dashlet_disables
zseq_dashlet_disables 2 0 0 0 0
1%
 
 
zseq_dashlet_disables
role_allocations 3 0 0 0 0
2%
 
 
role_allocations
zseq_role_allocations 3 0 0 0 0
2%
 
 
zseq_role_allocations
plugins 7 Details...hide/show 0 0 0 0
4%
 
 
plugins
zseq_plugins 7 0 0 0 0
4%
 
 
zseq_plugins
document_content_version 7 Details...hide/show 0 0 0 0
4%
 
 
document_content_version
document_metadata_version 16 Details...hide/show 0 0 0 0
8%
 
 
document_metadata_version
zseq_document_content_version 11 0 0 0 0
6%
 
 
zseq_document_content_version
zseq_document_metadata_version 0 0 0 0 0
0%
 
 
zseq_document_metadata_version
folder_workflow_map 3 0 0 0 0
2%
 
 
folder_workflow_map
trigger_selection 4 0 0 0 0
2%
 
 
trigger_selection
type_workflow_map 4 0 0 0 0
2%
 
 
type_workflow_map
workflow_state_permission_assignments 6 0 0 0 0
3%
 
 
workflow_state_permission_assignments
zseq_workflow_state_permission_assignments 3 0 0 0 0
2%
 
 
zseq_workflow_state_permission_assignments
document_role_allocations 3 0 0 0 0
2%
 
 
document_role_allocations
zseq_document_role_allocations 3 0 0 0 0
2%
 
 
zseq_document_role_allocations
folder_transactions 8 0 0 0 0
4%
 
 
folder_transactions
user_history 9 Details...hide/show 0 0 0 0
5%
 
 
user_history
zseq_folder_transactions 5 0 0 0 0
2%
 
 
zseq_folder_transactions
zseq_user_history 0 0 0 0 0
0%
 
 
zseq_user_history
folder_searchable_text 3 Details...hide/show 0 0 0 0
2%
 
 
folder_searchable_text
comment_searchable_text 5 Details...hide/show 0 0 0 0
3%
 
 
comment_searchable_text
workflow_trigger_instances 7 0 0 0 0
4%
 
 
workflow_trigger_instances
zseq_workflow_trigger_instances 3 0 0 0 0
2%
 
 
zseq_workflow_trigger_instances
column_entries 5 0 0 0 0
2%
 
 
column_entries
zseq_column_entries 5 0 0 0 0
2%
 
 
zseq_column_entries
interceptor_instances 3 0 0 0 0
2%
 
 
interceptor_instances
zseq_interceptor_instances 3 0 0 0 0
2%
 
 
zseq_interceptor_instances
workflow_state_disabled_actions 3 0 0 0 0
2%
 
 
workflow_state_disabled_actions
zseq_workflow_state_disabled_actions 3 0 0 0 0
2%
 
 
zseq_workflow_state_disabled_actions
plugin_rss 3 0 0 0 0
2%
 
 
plugin_rss
zseq_plugin_rss 3 0 0 0 0
2%
 
 
zseq_plugin_rss
document_tags 3 0 0 0 0
2%
 
 
document_tags
tag_words 4 0 0 0 0
2%
 
 
tag_words
zseq_document_tags 1 0 0 0 0
0%
 
 
zseq_document_tags
zseq_tag_words 0 0 0 0 0
0%
 
 
zseq_tag_words
download_files 8 0 0 0 0
4%
 
 
download_files
index_files 8 0 0 0 0
4%
 
 
index_files
scheduler_tasks 13 0 0 0 0
6%
 
 
scheduler_tasks
zseq_scheduler_tasks 5 0 0 0 0
2%
 
 
zseq_scheduler_tasks