user_page_defaults

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
userId INT 10 √ NULL
user.id Implied Constraint R
module VARCHAR 100 √ NULL
action VARCHAR 100 √ NULL
objectId INT 10 √ NULL
pageSize VARCHAR 10 √ NULL
pageSort VARCHAR 50 √ NULL
userListFilters VARCHAR 512 √ NULL

Indexes

Constraint Name Type Sort Column(s)
user_page_defaults_s_pk Primary key Asc id
PRIMARY Must be unique Asc id
userId Must be unique Asc/Asc/Asc/Asc userId + module + action + objectId

Relationships

Close relationships within degrees of separation