# Numerical question developer docs
- [1 Database tables](#bkmrk-database-tables)
- [1.1 quiz\_numerical](#bkmrk-quiz_numerical)
- [1.2 quiz\_numerical\_units](#bkmrk-quiz_numerical_units-1)
- [2 Response storage](#bkmrk-response-storage)
- [3 Question->options](#bkmrk-question-%3Eoptions)
- [4 State->options](#bkmrk-state-%3Eoptions)
- [5 See also](#bkmrk-see-also)
## Database tables
### quiz\_numerical
The quiz\_numerical table is an extension of the quiz\_answers table, defining a tolerance value for each answer.
- id
- int(10) unsigned NOT NULL auto\_increment,
- question
- int(10) unsigned NOT NULL default '0',
- answer
- int(10) unsigned NOT NULL default '0',
- tolerance
- varchar(255) NOT NULL default '0.0',
### quiz\_numerical\_units
The quiz\_numerical\_units table is used by the numerical questiontype and the calculated questionype. It extends the quiz\_questions table, defining an arbitrary number of units that can be used in the responses.
- id
- int(10) unsigned NOT NULL auto\_increment,
- question
- int(10) unsigned NOT NULL default '0',
- multiplier
- decimal(40,20) NOT NULL default '1.00000000000000000000',
- unit
- varchar(50) NOT NULL default *,*
## Response storage
The numerical questiontype, which inherits the function print\_question\_formulation\_and\_controls() from the shortanswer questiontype, has only one response field, so its responses are handled by the default questiontype. The response is stored without any modifications in the answer field of the table quiz\_states.
## Question->options
## State->options
## See also
[Numerical formats](https://docs.moodle.org/503/en/Development:Question_Engine_2:Numerical_formats "Development:Question Engine 2:Numerical formats"), gives a proposal for implementing various numerical formats for numerical and calculated question type in Question Engine 2.1.
---
Source: [docs.moodle.org/503/en/Numerical question developer docs](https://docs.moodle.org/503/en/Numerical%20question%20developer%20docs) — MoodleDocs (GPL) · Imported 2026-11-10.