userkeywords

userkeywords — Clustered. Stores userpic (userpic2) keywords. Also stores entry keywords (tags), and memory keywords. A site-configurable limit to the number of keywords for each userpic exists; default is 5. This table never gets deleted from, except if the user itself gets deleted. Please see also userpicmap2.

userkeywords

Column name Type Null Default Description
userid int unsigned   0  
kwid int unsigned   0  
keyword varchar(80)    
Key name Type Column(s)
PRIMARY PRIMARY
userid UNIQUE