questions_metadata
- Neill Magill
Owned by Neill Magill
Oct 25, 2022
1 min read
Loading data...
Purpose: Extensible table to allow any metadata information to be associated with a question.
Joins: questions table.
| Field | Type | Purpose |
|---|---|---|
| id | int(11) | Primary Key auto_increment |
| questionID | int(11) | questionID from the questions table (this is a foreign key from Rogo 7.4) |
| type | varchar(255) | The type (or name) of the metadata information. (e.g. 'town') |
| value | varchar(255) | The value of the metadata information. (e.g. 'London') |