Article feedback/Version 5/Technical Design Schema

This page describes the database schema for the Article Feedback Tool Version 5 (AFT V5). For more information, check the feature requirements and the final project report.

Overview
There is only 1 table for AFTv5 data:. It can live on the same database as the rest of the MediaWiki setup's code, or it can be in a totally different database.

As a result of  being   by default, the standard scenario for AFTv5 will have the table live on the same database. To have AFTv5 live on a separate database, change the value for  to the external server's value. Assuming you have an external database at, you'd set

When a feedback post is submitted, a record is created in.

All moderation actions performed on a feedback entry will result in an entry being written to the core MediaWiki  table. Because it would be expensive to join  and   (and even impossible if the AFTv5 table lives on a different database) to query for the status of feedback, those statuses are de-normalized and are also represented in   (like ,  , ...)

logging

 * Parts of the documentation here (especially related to user IDs/names) are likely outdated due to actor migration; see commit 51a2eea020f2e424a8e0ea055a7c412e5980f818.