User Info Data Table Schema (user_info_data)


Description

Data for the customisable user fields

user_info_data table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
userid BIGINT 19 0
user.id userinfodata_use3_fk R

id from the user table
fieldid BIGINT 19 0
user_info_field.id userinfodata_fie3_fk R

id from the field table
data LONGTEXT 2147483647 null

Field data
dataformat TINYINT 3 0

Table contained -1 rows

user_info_data table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
userinfodata_fie_ix Performance Asc fieldid
userinfodata_use_ix Performance Asc userid
userinfodata_usefie_uix Must be unique Asc/Asc userid + fieldid

user_info_data table relationships

Close relationships within degrees of separation