Purpose: Stores the text of keywords for both individual users and teams.
Joins: keywords_question, users and modules tables.
| Field | Type | Purpose |
|---|---|---|
| id | int(11) | Primary Key – auto increment. |
| userID | int(10) unsigned | User ID of the person owning the keyword. If a team keyword the join is with modules on id |
| keyword | char(255) | The keyword itself. |
| keyword_type | enum('personal','team') | Type of the keyword, personal or team. |