Article feedback/Version 5/Technical Design Schema

This page describes the database schema for the Article Feedback Tool Version 5 (AFT V5).

Overview
There are three parts of the schema: tables that describe the type of data that can be expected (in green), tables that hold the feedback itself (in yellow), and tables that track the aggregate data by page or revision (in blue). Greyed-down tables are not currently in use.



Data Type Tables
The data type tables --,  , and   -- describe the fields used by each version of the feedback form.

aft_article_field
Describes each field for each form option. For example, form option #1 has two rows here:  (type  ) and   (type  ). It is used in the submit API call for validation, query building, and building the parameters list.

aft_article_field_option
Describes the options for fields with type. For example, option 2's field  has options ,  ,  , and. It is used in the submit API call for validation.

aft_article_field_group
This table is not currently in use. It would allow you to group fields logically: a set of related checkboxes, for example.

aft_article_feedback
This is the primary table for storing feedback posts. Every valid submit generates a new row here.