Research:Article feedback/Data

Article Feedback v5 Data & Metrics Stage 1: Design
(December 2011 - March 2012) Stage 2: Placement
(March 2012 - April 2012) Stage 3: Impact on engagement
(April 2012 - May 2012)

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_answer

[edit ]

mysql>EXPLAINaft_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_feedback

[edit ]

mysql>EXPLAINaft_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_properties

[edit ]

mysql>EXPLAINaft_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_rollup

[edit ]

mysql>EXPLAINaft_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_rollup

[edit ]

mysql>EXPLAINaft_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_field

[edit ]

mysql>EXPLAINaft_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_group

[edit ]

mysql>EXPLAINaft_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_option

[edit ]

mysql>EXPLAINaft_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_count

[edit ]

mysql>EXPLAINaft_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_rollup

[edit ]

mysql>EXPLAINaft_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_rollup

[edit ]

mysql>EXPLAINaft_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||
+-------------------+------------------+------+-----+---------+-------+

Retrieved from "https://meta.wikimedia.org/w/index.php?title=Research:Article_feedback/Data&oldid=3581998"