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