user_info_data

0 rows

Description

Data for the customisable user fields

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

userid

BIGINT

19

0

user_info_data_erd_useridR

id from the user table

fieldid

BIGINT

19

0

id from the field table

data

LONGTEXT

2147483647

null

Field data

dataformat

TINYINT

3

0

Showing 1 to 5 of 5 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
userinfodata_usefie_uix	Must be unique	Asc/Asc	userid + fieldid

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees