sys_user_values


Columns

Column Type Size Nulls Auto Default Children Parents Comments
value_id INT 10 √ null
user_id INT 10 null
sys_users.user_id FK1A4C35A428C762A3 C
name VARCHAR 100 null
value TEXT 65535 √ null
version BIGINT 19 √ 1

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc value_id
FK1A4C35A428C762A3 Performance Asc user_id
unique_name Must be unique Asc/Asc user_id + name
user_id Must be unique Asc/Asc user_id + name

Relationships

Close relationships within degrees of separation