user_info_data

0 rows


Description

Data for the customisable user fields

Columns

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

id from the user table

fieldid BIGINT 19 0

id from the field table

data LONGTEXT 2147483647 null

Field data

dataformat TINYINT 3 0

Indexes

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

Relationships