icon

Welcome to Schema Evolution Toolsuite

Database: ham_zabbix

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 2001-03-27
Db latest release 2006-08-02
Db initial size 14
Db end size 48
Db evolution rate
19%
 
 
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
actions 89 Details...hide/show 0 0 0 0
45%
 
 
actions
alarms 32 0 0 0 0
16%
 
 
alarms
alerts 107 Details...hide/show 0 0 0 0
54%
 
 
alerts
config 36 0 0 0 0
18%
 
 
config
functions 42 Details...hide/show 0 0 0 0
21%
 
 
functions
history 13 0 0 0 0
6%
 
 
history
hosts 20 0 0 0 0
10%
 
 
hosts
items 219 Details...hide/show 1 0 0 0
118%
 
 
items
items_template 33 0 0 0 0
16%
 
 
items_template
media 40 0 0 0 0
20%
 
 
media
platforms 9 0 0 0 0
4%
 
 
platforms
triggers 78 0 0 0 0
39%
 
 
triggers
triggers_template 12 0 0 0 0
6%
 
 
triggers_template
users 49 Details...hide/show 0 0 0 0
25%
 
 
users
groups 13 0 0 0 0
6%
 
 
groups
graphs 36 1 0 0 0
26%
 
 
graphs
graphs_items 56 0 0 0 0
28%
 
 
graphs_items
history_str 21 Details...hide/show 0 0 0 0
11%
 
 
history_str
hosts_groups 11 0 2 0 0
24%
 
 
hosts_groups
media_type 36 0 0 0 0
18%
 
 
media_type
profiles 27 0 0 0 1
16%
 
 
profiles
rights 26 0 0 0 0
13%
 
 
rights
screens 19 0 0 0 0
10%
 
 
screens
screens_items 75 0 0 0 0
38%
 
 
screens_items
services 67 Details...hide/show 0 0 0 0
34%
 
 
services
services_links 24 0 0 0 1
14%
 
 
services_links
service_alarms 22 0 0 0 0
11%
 
 
service_alarms
sessions 17 0 0 0 0
8%
 
 
sessions
stats 55 0 4 0 0
65%
 
 
stats
sysmaps 47 0 0 0 0
24%
 
 
sysmaps
sysmaps_hosts 48 0 0 0 0
24%
 
 
sysmaps_hosts
sysmaps_links 50 0 0 0 0
25%
 
 
sysmaps_links
trends 47 0 2 0 0
42%
 
 
trends
trigger_depends 12 0 2 0 0
25%
 
 
trigger_depends
users_groups 8 0 2 0 0
23%
 
 
users_groups
usrgrp 6 0 0 0 0
3%
 
 
usrgrp
images 18 Details...hide/show 0 0 0 0
9%
 
 
images
audit 42 0 0 0 0
21%
 
 
audit
escalations 15 0 0 0 0
8%
 
 
escalations
hosts_templates 57 0 1 0 0
38%
 
 
hosts_templates
history_log 39 Details...hide/show 0 0 0 0
20%
 
 
history_log
escalation_rules 47 0 0 0 0
24%
 
 
escalation_rules
escalation_log 41 0 1 0 0
30%
 
 
escalation_log
hosts_profiles 89 0 0 0 0
44%
 
 
hosts_profiles
autoreg 28 0 0 0 0
14%
 
 
autoreg
servers 16 0 0 0 0
8%
 
 
servers
history_uint 7 0 0 0 0
4%
 
 
history_uint
conditions 6 0 0 0 0
3%
 
 
conditions
mappings 7 0 0 0 0
4%
 
 
mappings
valuemaps 4 0 0 0 0
2%
 
 
valuemaps
housekeeper 6 0 0 0 0
3%
 
 
housekeeper
acknowledges 9 0 0 0 0
4%
 
 
acknowledges
sysmaps_elements 16 0 0 0 0
8%
 
 
sysmaps_elements
applications 15 0 0 0 0
8%
 
 
applications
items_applications 4 0 0 0 0
2%
 
 
items_applications
auditlog 10 0 0 0 0
5%
 
 
auditlog
help_items 9 0 0 0 0
4%
 
 
help_items
history_text 7 0 0 0 0
4%
 
 
history_text
help 7 0 0 0 0
4%
 
 
help
categories 5 0 0 0 0
2%
 
 
categories
problems 9 0 0 0 0
4%
 
 
problems
problems_comments 11 0 0 0 0
6%
 
 
problems_comments
screens_graphs 7 0 0 0 0
4%
 
 
screens_graphs