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_use_fk R

id from the user table

fieldid BIGINT 19 0
user_info_field.id userinfodata_fie_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