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

short name for each field

name LONGTEXT 2147483647 null

field name

datatype VARCHAR 255

Type of data held in this field

description LONGTEXT 2147483647 null

Description of field

descriptionformat TINYINT 3 0
categoryid BIGINT 19 0
user_info_category.id user_info_fieldR

id from category table

sortorder BIGINT 19 0

order within the category

required TINYINT 3 0

Field required

locked TINYINT 3 0

Field locked

visible SMALLINT 5 0

Visibility: private, public, hidden

forceunique TINYINT 3 0

should the field contain unique data

signup TINYINT 3 0

display field on signup page

defaultdata LONGTEXT 2147483647 null

Default value for this field

defaultdataformat TINYINT 3 0
param1 LONGTEXT 2147483647 null

General parameter field

param2 LONGTEXT 2147483647 null

General parameter field

param3 LONGTEXT 2147483647 null

General parameter field

param4 LONGTEXT 2147483647 null

General parameter field

param5 LONGTEXT 2147483647 null

General parameter field

Indexes

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

Relationships