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