Top => user_data User "variables" that control or modify the actual operation of the software.

Categories: Users

Notes: Typically "sparse" data, in that most users do not have values for "most" variables. Whereas fields that have data for everyone typically are added as new columns in user_info.

Name Type Index Null? Default
userid varchar(255) (pk) No '' Actual userid (with 'name' combines to form primary key) name. FK user_info

name varchar(240) (pk) No '' name of user "variable"

value mediumtext value of "variable"

Name	Type	Index	Null?	Default
userid	varchar(255)	(pk)	No	''	Actual userid (with 'name' combines to form primary key) name. FK user_info
name	varchar(240)	(pk)	No	''	name of user "variable"
value	mediumtext				value of "variable"