user_info_field

0 rows


Description

Customisable user profile fields

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
shortname VARCHAR 255 shortname
name LONGTEXT 2147483647 null
datatype VARCHAR 255
description LONGTEXT 2147483647 √ null
descriptionformat TINYINT 3 0
categoryid BIGINT 19 0
user_info_category.id user_info_fieldR
sortorder BIGINT 19 0
required TINYINT 3 0
locked TINYINT 3 0
visible SMALLINT 5 0
forceunique TINYINT 3 0
signup TINYINT 3 0
defaultdata LONGTEXT 2147483647 √ null
defaultdataformat TINYINT 3 0
param1 LONGTEXT 2147483647 √ null
param2 LONGTEXT 2147483647 √ null
param3 LONGTEXT 2147483647 √ null
param4 LONGTEXT 2147483647 √ null
param5 LONGTEXT 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
user_info_field Performance Asc categoryid

Relationships