Research:Article feedback/Data

The data collected via the AFTv5 extension is stored in the following MySQL tables of the MediaWiki database and is replicated on the Toolserver. A real-time data stream is available here.

aft_article_answerEdit

mysql> EXPLAIN aft_article_answer;
+-----------------------+------------------+------+-----+---------+-------+
| Field                 | Type             | Null | Key | Default | Extra |
+-----------------------+------------------+------+-----+---------+-------+
| aa_feedback_id        | int(10) unsigned | NO   | PRI | NULL    |       |
| aa_field_id           | int(10) unsigned | NO   | PRI | NULL    |       |
| aa_response_rating    | int(11)          | YES  |     | NULL    |       |
| aa_response_text      | blob             | YES  |     | NULL    |       |
| aa_response_boolean   | tinyint(1)       | YES  |     | NULL    |       |
| aa_response_option_id | int(10) unsigned | YES  |     | NULL    |       |
+-----------------------+------------------+------+-----+---------+-------+

aft_article_feedbackEdit

mysql> EXPLAIN aft_article_feedback;
+------------------------+------------------+------+-----+----------------+----------------+
| Field                  | Type             | Null | Key | Default        | Extra          |
+------------------------+------------------+------+-----+----------------+----------------+
| af_id                  | int(10) unsigned | NO   | PRI | NULL           | auto_increment |
| af_page_id             | int(10) unsigned | NO   | MUL | NULL           |                |
| af_user_id             | int(11)          | NO   |     | NULL           |                |
| af_user_ip             | varbinary(32)    | YES  |     | NULL           |                |
| af_user_anon_token     | varbinary(32)    | NO   |     |                |                |
| af_revision_id         | int(10) unsigned | NO   | MUL | NULL           |                |
| af_bucket_id           | int(10) unsigned | NO   |     | 0              |                |
| af_cta_id              | int(10) unsigned | NO   |     | 0              |                |
| af_link_id             | int(10) unsigned | NO   |     | 0              |                |
| af_created             | binary(14)       | NO   | MUL |                |                |
| af_abuse_count         | int(10) unsigned | NO   |     | 0              |                |
| af_helpful_count       | int(10) unsigned | NO   |     | 0              |                |
| af_unhelpful_count     | int(10) unsigned | NO   |     | 0              |                |
| af_oversight_count     | int(10) unsigned | NO   |     | 0              |                |
| af_is_deleted          | tinyint(1)       | NO   |     | 0              |                |
| af_is_hidden           | tinyint(1)       | NO   |     | 0              |                |
| af_net_helpfulness     | int(11)          | NO   |     | 0              |                |
| af_has_comment         | tinyint(1)       | NO   |     | 0              |                |
| af_is_unhidden         | tinyint(1)       | NO   |     | 0              |                |
| af_is_undeleted        | tinyint(1)       | NO   |     | 0              |                |
| af_is_declined         | tinyint(1)       | NO   |     | 0              |                |
| af_activity_count      | int(10) unsigned | NO   |     | 0              |                |
| af_hide_user_id        | int(10) unsigned | NO   |     | 0              |                |
| af_oversight_user_id   | int(10) unsigned | NO   |     | 0              |                |
| af_hide_timestamp      | binary(14)       | NO   |     |                |                |
| af_oversight_timestamp | binary(14)       | NO   |     |                |                |
+------------------------+------------------+------+-----+----------------+----------------+

aft_article_feedback_propertiesEdit

mysql> EXPLAIN aft_article_feedback_properties;
+-----------------+------------------+------+-----+---------+-------+
| Field           | Type             | Null | Key | Default | Extra |
+-----------------+------------------+------+-----+---------+-------+
| afp_feedback_id | int(10) unsigned | NO   | PRI | NULL    |       |
| afp_key         | varbinary(255)   | NO   | PRI | NULL    |       |
| afp_value_int   | int(11)          | NO   |     | NULL    |       |
| afp_value_text  | varbinary(255)   | NO   |     |         |       |
+-----------------+------------------+------+-----+---------+-------+

aft_article_feedback_ratings_rollupEdit

mysql> EXPLAIN aft_article_feedback_ratings_rollup;
+--------------+------------------+------+-----+---------+-------+
| Field        | Type             | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+-------+
| arr_page_id  | int(10) unsigned | NO   | PRI | NULL    |       |
| arr_field_id | int(10) unsigned | NO   | PRI | NULL    |       |
| arr_total    | int(10) unsigned | NO   |     | NULL    |       |
| arr_count    | int(10) unsigned | NO   |     | NULL    |       |
+--------------+------------------+------+-----+---------+-------+

aft_article_feedback_ratings_rollupEdit

mysql> EXPLAIN aft_article_feedback_select_rollup;
+----------------+------------------+------+-----+---------+-------+
| Field          | Type             | Null | Key | Default | Extra |
+----------------+------------------+------+-----+---------+-------+
| afsr_page_id   | int(10) unsigned | NO   | PRI | NULL    |       |
| afsr_option_id | int(10) unsigned | NO   | PRI | NULL    |       |
| afsr_field_id  | int(10) unsigned | NO   |     | NULL    |       |
| afsr_total     | int(10) unsigned | NO   |     | NULL    |       |
| afsr_count     | int(10) unsigned | NO   |     | NULL    |       |

aft_article_fieldEdit

mysql> EXPLAIN aft_article_field;
+---------------+---------------------------------------------+------+-----+---------+----------------+
| Field         | Type                                        | Null | Key | Default | Extra          |
+---------------+---------------------------------------------+------+-----+---------+----------------+
| afi_id        | int(10) unsigned                            | NO   | PRI | NULL    | auto_increment |
| afi_name      | varbinary(255)                              | NO   | MUL | NULL    |                |
| afi_data_type | enum('text','boolean','rating','option_id') | YES  | MUL | NULL    |                |
| afi_group_id  | int(10) unsigned                            | YES  |     | NULL    |                |
| afi_bucket_id | int(10) unsigned                            | NO   |     | NULL    |                |
+---------------+---------------------------------------------+------+-----+---------+----------------+

aft_article_field_groupEdit

mysql> EXPLAIN aft_article_field_group;
+----------+------------------+------+-----+---------+----------------+
| Field    | Type             | Null | Key | Default | Extra          |
+----------+------------------+------+-----+---------+----------------+
| afg_id   | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| afg_name | varbinary(255)   | NO   | UNI | NULL    |                |
+----------+------------------+------+-----+---------+----------------+

aft_article_field_optionEdit

mysql> EXPLAIN aft_article_field_option;
+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| afo_option_id | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| afo_field_id  | int(10) unsigned | NO   | MUL | NULL    |                |
| afo_name      | varbinary(255)   | NO   |     | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+

aft_article_filter_countEdit

mysql> EXPLAIN aft_article_filter_count;
+------------------+------------------+------+-----+---------+-------+
| Field            | Type             | Null | Key | Default | Extra |
+------------------+------------------+------+-----+---------+-------+
| afc_page_id      | int(10) unsigned | NO   | PRI | NULL    |       |
| afc_filter_name  | varbinary(64)    | NO   | PRI | NULL    |       |
| afc_filter_count | int(10) unsigned | NO   |     | NULL    |       |
+------------------+------------------+------+-----+---------+-------+

aft_article_revision_feedback_ratings_rollupEdit

mysql> EXPLAIN aft_article_revision_feedback_ratings_rollup;
+------------------+------------------+------+-----+---------+-------+
| Field            | Type             | Null | Key | Default | Extra |
+------------------+------------------+------+-----+---------+-------+
| afrr_page_id     | int(10) unsigned | NO   | PRI | NULL    |       |
| afrr_revision_id | int(10) unsigned | NO   | PRI | NULL    |       |
| afrr_field_id    | int(10) unsigned | NO   | PRI | NULL    |       |
| afrr_total       | int(10) unsigned | NO   |     | NULL    |       |
| afrr_count       | int(10) unsigned | NO   |     | NULL    |       |
+------------------+------------------+------+-----+---------+-------+

aft_article_revision_feedback_select_rollupEdit

mysql> EXPLAIN aft_article_revision_feedback_select_rollup;
+-------------------+------------------+------+-----+---------+-------+
| Field             | Type             | Null | Key | Default | Extra |
+-------------------+------------------+------+-----+---------+-------+
| arfsr_page_id     | int(10) unsigned | NO   | PRI | NULL    |       |
| arfsr_revision_id | int(10) unsigned | NO   | PRI | NULL    |       |
| arfsr_option_id   | int(10) unsigned | NO   | PRI | NULL    |       |
| arfsr_field_id    | int(10) unsigned | NO   | PRI | NULL    |       |
| arfsr_total       | int(10) unsigned | NO   |     | NULL    |       |
| arfsr_count       | int(10) unsigned | NO   |     | NULL    |       |
+-------------------+------------------+------+-----+---------+-------+