User Info Field Table Schema (user_info_field)


Description

Customisable user profile fields

user_info_field table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
user_info_data.fieldid userinfodata_fie_fk R
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 userinfofiel_cat_fk R

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

Table contained -1 rows

user_info_field table indexes

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

user_info_field table relationships