keywords_user
Purpose: Stores the text of keywords for both individual users and teams.
Joins: keywords_questions, 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. |