app_user_info_field

0 rows


Description

Customisable user profile fields

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_user_info_field_id_seq'::regclass)
app_user_info_data.fieldid Defined in XMLR
shortname varchar 255 'shortname'::character varying
name text 2147483647 null
datatype varchar 255 ''::character varying
description text 2147483647 null
descriptionformat int2 5 0
categoryid int8 19 0
sortorder int8 19 0
required int2 5 0
locked int2 5 0
visible int2 5 0
forceunique int2 5 0
signup int2 5 0
defaultdata text 2147483647 null
defaultdataformat int2 5 0
param1 text 2147483647 null
param2 text 2147483647 null
param3 text 2147483647 null
param4 text 2147483647 null
param5 text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
app_userinfofiel_id_pk Primary key Asc id

Relationships