keywords_user

Purpose: Stores the text of keywords for both individual users and teams.
Joins: keywords_questionsusers and modules tables.

FieldTypePurpose
idint(11)Primary Key – auto increment.
userIDint(10) unsignedUser ID of the person owning the keyword. If a team keyword the join is with modules on id
keywordchar(255)The keyword itself.
keyword_typeenum('personal','team')Type of the keyword, personal or team.