app_user_info_data

0 rows


Description

Data for the customisable user fields

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_user_info_data_id_seq'::regclass)
userid int8 19 0
app_user.id Defined in XMLR
fieldid int8 19 0
app_user_info_field.id Defined in XMLR
data text 2147483647 null
dataformat int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_userinfodata_id_pk Primary key Asc id
app_userinfodata_fie_ix Performance Asc fieldid
app_userinfodata_use_ix Performance Asc userid
app_userinfodata_usefie_uix Must be unique Asc/Asc userid + fieldid

Relationships