# 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