Analytics/Reportcard/2.0/Database design

=Database design Report Card 2.0= This page documents the database design for the new reportcard ([http://reportcard.wmflabs.org/reportCard/ reportcard.wmflabs.org/reportCard/). The document consists of two sections:
 * the current database design consists of 10 tables. Most of these tables have the same structure.
 * a new simplified proposed design. Please chime in on the Talk page with your thoughts.

The high level goals are documented here Analytics/Reportcard/Requirements.

Suggested Table Design
Summary of changes:


 * Merge different tables in one single table
 * change CHARSET to UTF8
 * change column type date to timestamp
 * set engine to Innodb instead of MyISAM.
 * add view column which is of type ENUM
 * change size of extension field to 4
 * change size of language_code field to 4
 * change bigint to bigint unsigned as 'value' will always be 0 or large
 * rename binaries to value
 * rename table name to aggregated_data

Background Links

 * http://backchannel.org/blog/friendfeed-schemaless-mysql