cache_paper_stats
- Neill Magill
Owned by Neill Magill
Oct 25, 2022
1 min read
Loading data...
Purpose: Holds statistics of the performance of a paper. Used in the Performance Summary reports.
| Field | Type | Purpose |
|---|---|---|
| paperID | mediumint(8) unsigned | ID of the paper |
| cached | int(10) unsigned | Unix timestamp when the data was cached. |
| max_mark | decimal(10,5) | Maximum student mark on the paper. |
| max_percent | decimal(10,5) | Maximum student percentage on the paper. |
| min_mark | decimal(10,5) | Minimum student mark on the paper. |
| min_percent | decimal(10,5) | Minimum student percentage on the paper. |
| q1 | decimal(10,5) | Quartile 1 percentage. |
| q2 | decimal(10,5) | Quartile 2 percentage. |
| q3 | decimal(10,5) | Quartile 3 percentage. |
| mean_mark | decimal(10,5) | Mean student mark on the paper. |
| mean_percent | decimal(10,5) | Mean student percentage on the paper. |
| stdev_mark | decimal(10,5) | Standard deviation mark. |
| stdev_percent | decimal(10,5) | Standard deviation percentage. |
See also: Marks Caching