Primary Keys Count

The statistics show the evolution of the database with respect to the number of primary keys; the value is computed as the sum, over all the tables, of the number of primary key constraints per table The revision's number in x-axis of the line chart, is an identification number in place of the real revision's number, which can be found in the attached csv file

SELECT constraint_schema, count(*) FROM `PRISM_KEY_COLUMN_USAGE` k, PRISM_VERSIONS d WHERE d.schema_unique_name = k.constraint_schema AND k.constraint_schema like ? and k.constraint_name = 'PRIMARY' GROUP BY constraint_schema ORDER BY d.tstart

Foreign Keys Count

The statistics show the evolution of the database with respect to the number of foreign keys; the value is computed as the sum, over all the tables, of the number of foreign key constraints per table The revision's number in x-axis of the line chart, is an identification number in place of the real revision's number, which can be found in the attached csv file

SELECT table_schema, count(*) FROM PRISM_KEY_COLUMN_USAGE s, PRISM_VERSIONS d WHERE d.schema_unique_name = s.table_schema AND s.table_schema like ? and s.constraint_name != 'PRIMARY' AND REFERENCED_TABLE_SCHEMA IS NOT NULL GROUP BY table_schema ORDER BY d.tstart

Primary Keys Changes

The statistic show the number of primary keys modified during the lifetime of a table The aggregation level is the table name. This can be used as an index of database stability

The sql analyze the number of columns belonging to the key in each revision of the databas during the table lifetime

Foreign Keys Changes

The statistic show the number of primary keys modified during the lifetime of a table The aggregation level is the table name. This can be used as an index of database stability

The sql analyze the number of columns belonging to the key in each revision of the databas during the table lifetime